Perhaps it's the language barrier, but it looked to me that you wanted us to give you all of the differences between the different versions for you to write your...

That's the key... can't really speak for Matt but it was starting to look like you were having him debug every little thing without actually...

Whitt,

What I really want to know is that, although this was a great exercise for me personally, I did sort of bust a hump to give you a complete high-speed...

Ture enough... and I've not tried the SSIS solution for this, but (just something to consider) the DTS solution was horribly slow compared to the BULK INSERT that used the...

For the original problem given where certain parameters determine which function may be exercised and returned, a simple CASE statement would be in order whether it be for a RBAR...

Ok, thanks, Matt... good information. I'll get my arms around all this "new" 2k5 stuff, soon.

But I'm pretty sure that Scope_Identity isn't "login" sensitive as you suggest. That...

We'll see... when you figure out the correct answer for the real question being asked, post it here.

Guess the next questions would be...

How many of you make the mistake of letting developers create their own tables? How many of you allow that to occur without...

Step 1... find the person that designed the ID column... take him/her to dinner... feed him/her 2 pound porkchops... at point blank range with a sling shot!

Ok... having said that,...

Heh... let's see... take a urine test, hair test, background check, credit check, education check, check for bounced checks, check for references, check for traffic and felonly violations, etc, etc,...

Matt Miller (1/14/2008)

---

Since you're in 2005 - you can avoid all of the scope_identity nonsense by using the OUTPUT predicate from within the INSERT statement.

It looks something like

declare @nextid as...

And people wonder why I get ticked at some users... what were you thinking when you posted this...

I'm thinking "simple answer" here... what were the grants on the old box?

Changing the format of the "date" column is just a repetitition of the original mistake... for more reasons than will fit in this meager window, you must NEVER store dates...

Quick show of hands... how many require that table and column comments be included in table definitions? Next question... How many require that they be done correctly? 😉