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? 😉

I wondered when you were going to get to that point...

Daniel Storm (1/17/2008)

---

OK, based on the two posted responses thus far, some more clarification regarding my question is obviously required …

- I’m not asking about what a deadlock is (been...

Ah... sorry... I see what you're getting at, now... yes, you are correct... only way to trully avoid the RBAR of the function is to, in fact, limit to a...

Yeah, huh? You expect us to guess what the record layout and target table schema is?

Another obvious cheat, Sandy?

Sandy (1/17/2008)

---

Hey sqluser,

Thanks, It is working...

Jeff,

Actually I asked about this post...

" http://www.sqlservercentral.com/Forums/Topic444141-338-1.aspx "

Jeff,

-------------

Sandy learned nothing about what Sandy was supposed to learn... except how to cheat. Great job, Pal!...

I'm thinking that there's a lot of people that don't understand what a good data dictionary is nor how it's made. Regardless of the tool involved, without intelligent and...

Definitely a kindred spirit... round of beers... motorcycle for an avatar...

Man, some people just don't get it... Who's goin' for the...