Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

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.

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'

Open in new window

0
rutledgj
Asked:
rutledgj
2 Solutions
 
knightEknightCommented:
If you can control the format of the string, I suggest this:

'2011-09-28 15:45:21'
0
 
Patrick MatthewsCommented:
That should be OK, although I would recommend an ISO-style format.  For example, instead of:

'9/28/2011 3:45:21 PM'

I would use:

'2011-09-28 15:45:21'

That said, are you positive that you entered your parameters in the correct order?
0
 
rutledgjAuthor Commented:
my goof. I was missing a param.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now