If anyone can help I would be very grateful
Here is what i need, to pull a random person from a single table based on a Date parameter for a stored procedure,
ALTER proc [dbo].[random_winner_RR_SC]
@date smalldatetime = null
as
SELECT TOP 1 * FROM scandata
where sdDateTime = @date
ORDER BY NEWID()
When I put in a date time that I know is in the database I don't get any results, I know I have to convert the date but can't get it working, Can someone please help me with this.