omegalove
asked on
Invalid parameter 1 specified for datediff.
WHERE
[pi].IndexID > @PageLowerBound AND
[pi].IndexID < @PageUpperBound
And Country = @Country and
tbl_Profile.Gender = @Gender
and (DateDiff('yyyy', tbl_profile.BirthDate,getd ate()) >= @Age1)
and (DateDiff('yyyy',tbl_profi le.BirthDa te,getdate ()) <= @Age2)
ORDER BY
IndexID
SET ROWCOUNT 0
END
Age1 and Age2 are integers
[pi].IndexID > @PageLowerBound AND
[pi].IndexID < @PageUpperBound
And Country = @Country and
tbl_Profile.Gender = @Gender
and (DateDiff('yyyy', tbl_profile.BirthDate,getd
and (DateDiff('yyyy',tbl_profi
ORDER BY
IndexID
SET ROWCOUNT 0
END
Age1 and Age2 are integers
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER