Just do a SELECT 1/0.... trust me, it'll throw an error 😉

Correct... If the IDENTITY column is the last column, you wouldn't need a list of columns in the INSERT clause.

Heh... I've got a real live appreciation for being a bit...

Absinthe (12/23/2007)

---

Actually we have 2 differnt issues here:

1.

I was not saying that the code was fast, merely that it specifically satisfied the described problem of doing it inline without...

C'mon, Midan... this one is easy. Figure it out. If you're returning a column you don't want, then remove it from the SELECT list!

Here's an example of how bad your "gee-whiz" factor code is... first, create the following test table... yeah, I know... It uses SELECT INTO... just do it...

--===== Create and populate...

Not worth the risk? What risk? I think you're over reacting to "Clone SQL Advise". SELECT INTO will create a new table with a million rows in...

Why? And, pretty sure it's not possible.

AndrewSQLDBA (12/23/2007)

---

That is what I thought also. I have tried to explain that to the company that wrote this aweful piece of software. I wish that the Exec's would have...

Then take a look at "recursive CTE" in Books On Line for 2k5 and look for "Using a recursive common table expression to display a hierarchical list". They've got...

Good to see I'm not the only one stuck with 7 year old software at work, Ian. To keep up though, I finally broke down and installed the Dev...

Absinthe (12/21/2007)

---

Red Flag time again....

A covering index could certainly help... but there's a lot of things that will change an Index Seek into and Index Scan... usually non-sargeable WHERE clauses and ON clauses. ...

Then, it should be a single table. If you make it an "adjacency" (parent/child) model, you may be ok depending on how you're going to drill down and how...

Not only is it a "doosie", but it's darned near a duplicate...

http://www.sqlservercentral.com/Forums/Topic435994-361-1.aspx

Which "above script"... don't waste time, be specific, please.

You also said you wanted to update the table with address info... heh... what if a person has 2 addresses?