I don't know what "SP_Generate_Inserts" does... but there's a couple of things I see wrong here...

First, it's a very bad practice to name your procs starting with SP_... those should...

Pretty sure the OP said something to the effect of "without using a additional column levelno".

Vamshi,

Lookup "Expanding Hierarchies" in Books Online...

Uh... what happens when you have more than 1 year?  In other words, why are you storing the salary month and not a salary date/time so you can do multiple...

Where do you get those?  Wouldn't mind seeing the rest of them...

Gotta love that... a GUI based tool that doesn't support the base product... kinda like EnterPrise Manager with Case statements...

Heh... or...

Infinity = undefined

Null = undefined

1/Infinity = undefined?

1/Infinity = Null?

Just havin' fun

Didn't think of them that way... operative words were "didn't think"   Thanks, Serqiy.

And, if you do have a clustered index in the right spot...

GO

--===== Create and populate a 1,000,000 row test table.

     -- Column RowNum has a range of 1...

Pretty sure (been a while since I've had to check, DBA's at work normally do this) PCI compliance doesn't allow trusted connections.  If you're not worried about PCI, then that'll...

From the FROM clause down, updates with joins look pretty much like what you'd find in a SELECT...

 UPDATE t1

    SET somecol =t2.somecol

   FROM @Table1 t1,

        @Table2 t2

  WHERE t1.someothercol...

There's some sort of nasy ol' timeout... I always do a select-all and copy before I try to post... just in case...

Heh... good thread, huh?

You bet... thanks for the feedback!

Better have a good list of logins and passwords, then   And figure out a really good way to change them in the code...