Since DATEDIFF returns an Integer value, SQL Server tries to cast your @strSQL also to an INT, because INT has a higher precedence. What about this?

DECLARE @strSQL NVARCHAR(50)

DECLARE @MyDate DATETIME

Set...

http://www.sommarskog.se/error-handling-II.html

http://www.sommarskog.se/error-handling-I.html

See if this helps: http://www.sommarskog.se/dyn-search.html

Thanks Calvin, I've downloaded the book and will read it. At a first glance it's doable with a dictionary at my side.

The intellectual...

Not only that...

You can frequently observe the question why one cannot use GETDATE() inside a UDF. And equally frequent you will see someone suggesting to wrap GETDATE() inside a view...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=61&messageid=173285 

From your sample data, is it possible that a product can appear in only one table, or do they always appear in both tables?

Without having a crystal ball in...

Thanks Phill!

Meanwhile I've read a bit closer into this copyfight thingy. Sad, but true. For now, I'll stick to this one...

It deletes ALL the data in the table without using the log file, regardless of recovery mode.

Slightly incorrect. TRUNCATE is minimally logged. The deallocation of the datapages actually is recorded...

Äh, yes?

Let's leave it here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=173895

What is the reason why you want to keep permanently this redundant information?

wtf *?@3$%&"gr@| If someone complains, it's still enough time to remove it.

Yeah, I don't like it, too, but it's the best I've found doing a quick search....I'll work on this.

Haha, Remi, thanks for correcting my on this. This shows how much I deal with UDF's.

Aah, now I understand. And although I personally think that's nothing but ridiculous, I have changed the avatar. I don't want to cause any trouble here.