I use them on SSIS packages.

I need to pivot on some not all rows, I have search the sqlservercentral site for the answer but nothing yet..

Thanks

You are correct, this is only for Dev to test... then after intensive test we deploy to prod..

Let me try that script and I'll let you know..

Thanks

This is great!!!

Thank you!!!:cool:

I just have to say that you guys are great, I really apreciate all your help -

SQLServerCentral Rocks!!!

I guess I cannot leave the date blank if I do want to test on it.

With the Or I have to pick a date for any datetime column, but what...

I need to be able to enter a date for InvoiceDate and leave the other alone or enter a date for PaidDate and leave the others alone.

I have created this procedure with only 2 date columns, but I get nulls and all the records when I enter a date and it wont narrow it down...

It did not work, maybe because I do not understand how is suppost to work, can you please explain?

THANK YOU!!!!!!:)

LOL -- That's funny!

thanks, here is the line I entered and gave me the same error!

CASE when ODCDAT = ' ' or ODCDAT is null then null

else convert(datetime, ODCDAT,102)END AS LastDateUsed,

🙂 thanks!!