Not to mention that this trigger will fail if you update more than one row at the time... Take a look at the inserted/deleted tables.

Quite simple to do actually... but why do you need to have a model like this? Why can't you just use the quantity and date data as is?

Just use a bigger range of dates and add a group by for the months and you're golden.

When you need to keep foreign dialects like chinese in the db. You need to use unicode for this task (N). Note that these datatypes take double the...

Wouldn't it be simpler to use the numbers table to do the splitting of the text fields??

If I were in that situation I think I would start to write one function per important project in rotation so that each project gets the same attention all the...

What's the authentication mode?

Did you try the sa account?

Did you check the WINDOW'S application even log?

You may want to read this before going down that road :

Dynamic Search Conditions in T-SQL

So how did you make him change his mind about that??

Can you post the query??

If you can't create a new query or change this one, then I suggest that you might be screwed.

Who is he?

Can't really help you without the table definition and required output...

Select * from dbo.YourTable Y inner join

(Select key1, key2, max(date) as date from dbo.YourTable group by key1, key2) dtY

on Y.key1...

Can you rephrase that???

What information is available, what information do you need to extract??

Can we see the whole code?? there's just no way that this can take a long time (asssuming there's no locking problems).

print @VariableName

then execute from QA