can you use a case statement to filter out the records that can't be converted to date?

something like this? I haven't checked for feburary because i'm not sure how to...

i would just add the following code into the CATCH block

SELECT ERROR_NUMBER() AS ErrorNumber,

ERROR_MESSAGE() AS ErrorMessage

I would think if you want to use the RAISERROR function you would use it...

thank you so much, Lutz.

I've used this way of bringing back information before but i think i'm constantly in the mindsite of using PIVOT so was trying to get it...

Brandie Tarvin (10/15/2010)

---

Not a horror story, but definitely a cringe moment.

A job where the Dev instance was on the same server as the Production Instance. SQL Security was not their...

hi, i notice in the following link, for what i see as the same problem, they give a similar answer but wrap it with the STUFF function.

I've tested this on...

I think you must be right.

i ended up with the following:

declare @subjectline varchar(100) = 'test subject',

...

this is a thread that gave me alot of help on this subject.

http://www.sqlservercentral.com/Forums/Topic747597-392-1.aspx

great article and some great posts. I shall be keeping an eye on this article/thread!

edit

at skcadavre, fair enough 😀

thanks for the responses.

so if i wanted to find out if 'lowell@davidandrews.com' exists on my own server how would i go about that?

lets say that the email in the database...

http://databases.aspfaq.com/general/why-do-some-sql-strings-have-an-n-prefix.html

this says that it denotes the following string is Unicode

oh wow!, thanks!

i had sort of found a way and was half way through implementing it but this way is much less code 🙂

i tend to put PRINT lines in my code to see what its returning.

would it be easier to have another table?

1st table stores the patients

2nd table stores the definitions of the drugs

3rd table stores the informatoin that links the two

-------------

Patients

-------------

ID Name

1 John Smith

2...