You have to admire the courage of his convictions... Deleting his own posts so that people won't throw his own words back at him?

Perhaps someone should...

Call me old-school, but I cannot understand someone STARTING their career as a consultant.

Boy, I missed all the fun last night... and missed free beer to boot. That's what I get for paying attention to my wife. :w00t:

Face it people, we...

But it bears repeating..... because NOBODY ever expects the SQL Inquisition!

... and yes... Lynn is a saint.

It ain't pretty, but will this get it?

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

create table #temp (entry_id int ,group_id int,cost int,level int)

insert into #temp

select 1001, 2001, 5,...

Paul, I believe noel's point is that if you have a stored procedure to insert rows into Table B, and you want to use it whenever you insert a row...

I think Greg stated it well. Don't put the OP on the defensive.

As for my calling a "cursor" a dirty word.... I wasn't trying to get more...

If the col1 values are always at the end, so you can do it with the code at the bottom. This same principal be used to remove a...

Gail and Steve, I understand why you always want to discuss the full problem when you see someone about to go seriously wrong. But there is the point...

Jeff and Gail:

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

Is this "feed a fish", "teach to fish", or ask "Why on earth do you want fish?" I'm waiting to see if the OP comes...

I was referring to inadequacies of alleged IT professionals 😉

My war story is that our development group used to have a guy whose entire job...

Applause for Lynn !!!!

He actually persuaded a new OP to go back and set up their question correctly 🙂

...

I see what you were doing with both a parentID and a childId column now, and I would guess that type 2 means child and type 1 means parent. ...

MUCH more helpful. Thank you. Looking at your tables now.

I just have to ask, how much of your coding efforts are spent on compensating...