Hello people,

I am haivng an issue passing a smalldatetime into a stored proc.

The issue is on MSSQL to be valid, you have to enter it as

'2003-10-03 00:00:00'

This makes it into a stored proc with no issues,

but to be valid

I need something like this

select * from FIWORKING where DEALDATE > '@WINDOW'

I can't seem to get the ' to stick in the stored proc,
is there a way to protect it ??

Chris

Got it to work by passing the datetime into the stored proc using the
below syntax

{ d '2003-31-11' }

Anyone know of another way to pass datetime into a Stored Proc ?