rutledgj
asked on
tsql parameter question
I have a stored proc that accepts a number of parameters including 3 datetime parameters.
I'm trying to run this inside the query analyzer. When I pass in the datetime as a string I get a conversion error. What is the correct way to do this? It is sql server 2005.
I'm trying to run this inside the query analyzer. When I pass in the datetime as a string I get a conversion error. What is the correct way to do this? It is sql server 2005.
exec DrFirst.usp_insPrescriptions
'BB-17450275',
'11291',
'MSNTN',
'kstepniakowski',
'Wal-Mart Pharmacy 91',
'diltiazem HCl',
'diltiazem HCl',
'n',
'180 mg',
'1',
'twice a day',
'30',
'60',
'4',
'',
'',
'3/29/2011 12:51:12 PM',
'3/29/2011 12:51:12 PM',
'sent,signed',
'fax',
'9/28/2011 3:45:21 PM',
0,
'y',
'',
'mewart'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER