Hi Mike,

in this context 'Fail' can mean many things - either the sproc did not complete or if it is say a procedure that searches our database for known issues...

Thanks all.

I'll give this a go, if I get any more problems I'll be sure to post again!

Thanks

Cheers buddy

I'm changing the date to chars to avoid the problem of 1/jan/2010 at 1pm being different from 1/jan/2010 at 3pm etc.

My brain is too muddled by now to analyse...

Ok....

Perhaps your database actually does have garbage in the contact_info column? Lots of people type junk into an email address column because they dont want to receive marketting info.

Hi Flo,

results:

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

PCS08404\SQLEXPRESS ...

Unfortunately not... I just created them using the graphical tools in management studio.

Interestingly I have just succesfully created the table using the graphical tools. I hit F4 to get the...

Ah that makes sense then 🙂

Thanks!

Thanks very much!

I'm amazed that a single null in a recordset will make the whole query fail but nevermind eh 🙂

Happy programming.

Ben