Advertisement
Guest User

Untitled

a guest
Aug 22nd, 2014
160
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. Operand data type date is invalid for subtract operator.
  2.  
  3. CREATE FUNCTION Salman( @Date date )
  4. RETURNS TABLE
  5. AS
  6. RETURN
  7. (
  8.  
  9. SELECT TOP 1000 [ID]
  10. ,[Name]
  11. ,[LastDate]
  12. ,[Rule]
  13. ,[CoA]
  14. FROM [Scheduling_Employee].[dbo].[Group]
  15. where ([LastDate]-@Date)%[Rule]=0
  16. )
  17. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement