Can we close this fr3@king thread??? It's been almost 170 message already!!!!!

This will answer most of your basic questions :

http://www.w3schools.com/sql/default.asp

can you post your final solution so we can benefit from your work?

Well I'm not Remi either but I'll have to agree .

You'll have to implement this with a trigger and manually count the next value for the update. Or you could also use a datetime field which would you allow...

Please do not cross-post, we monitor all boards.

Finish the thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=213340

Please do not cross-post, we monitor all boards.

Finish the thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=213340

Where is the date kept?? That query becomes almost impossible without that.

Do this in the proc :

For each parameter, declare a new variable (same type/length/almost same name). Then copy the parameters' value to those variables, then use those variables in...

can you post some sample data and the expected results (gonna be much easier that way)?.

I can't even imagine the nightmare... I'm just hopping that it was not a 24/7 shop and that you had time to apply the updates... not to mention a kick...

Does it have to be done at the same time of the update or can it be delayed a little? I'm thinking that you could flag the rows that...

Table is too large. A row MUST fit in a data page or the insert fails. The data page size is 8060, so any row containing more than...

Are you sure they are created?

What happens if you run some insert statements/procs from QA?

Under what account is the agent running?