We'll have to wait 'till you get home...

HTH.

DDL = Data definition language.

Go in enterprise manager, select the 2 tables then right-click, copy, then you'll be able to paste the results in the boards here.

Then I'd like to...

Why do you want to do something like this?

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

Finish the thread here

Outch, would be nice if we could catch the recordset into a table...

Never seen it written that way, but as long as it works for you .

Joe HATES identity columns like the pest, now you wanna create the clustered index on it ???

I'm not gonna restart that discussion here....

Can I get both tables' DDL, with a few inserts statements for the sample data (don't wanna guess the column's name) ?

Obviously, nice thinking about this script.

In the same line.. I often resort to decompiling the whole project and recompiling to correct bugs like this.

It sure helped me a lot in the past.

I never understood you didn't like my postings .

Thanx, how about the input parameters??

Sorry to keep asking questions. My thaughts process is a little slow atm (starting to imagine how many new ways to solve problems this...

Oops, I taught for a sec that Suri was one of your nicknames. I may have missed something after all .

I hope Joe's not gonna read this... we're not gonna hear the end of it.