Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Operand data type date is invalid for subtract operator.
- CREATE FUNCTION Salman( @Date date )
- RETURNS TABLE
- AS
- RETURN
- (
- SELECT TOP 1000 [ID]
- ,[Name]
- ,[LastDate]
- ,[Rule]
- ,[CoA]
- FROM [Scheduling_Employee].[dbo].[Group]
- where ([LastDate]-@Date)%[Rule]=0
- )
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement