I have to ask why you would return the columns of...

Sorry it took me so long to get back to this...

No... no \t's here... I believe this is what you're looking for. Note that the forum ate the...

Ya kinda left things hanging here... did that work for you or what? 😉

Douglas De Ivey (10/17/2004)

---

No, what you want to do can't be done with SQL2000. You would need to join your 'inpt table' to the output from the function.

Apparently the next...

Yep... that's what I do to, Todd... the "habit" I was talking about, though, is the inclusion of the 'U' in the OBJECT_ID function... it's really not necessary.

...and thank you for the feedback! 🙂

Ed (3/6/2009)

---

Jeff Moden (3/5/2009)

---

I've gotta ask, Ed... why do you need this type of denormalize output? What is that output going to be used on? I'm asking because...

Mike... how long do just one of these take to run?

select count(*) as ControlTotals

from ' + @RevStateDB + '.dbo.Budget1995 where srcflag =...

Mike Levan (3/6/2009)

---

Can i do this through SSIS pkg or BULK Insert to spped up my load.??

Few questions on BULK INSERT

1. Does a user need to be bulkadmin to do...

Jeff Moden (3/6/2009)

---

Got some cold ones? We can look up some old...

Got some cold ones? We can look up some old ISO standards...

Bob Hovious (3/6/2009)

---

Does that mean all pork chops, katanas, longbows, and trebuchets would have to be checked at the door? Doesn't sound like much of a party...

Bob Hovious (3/6/2009)

---

Nah.... I'd never get invited.

Seriously, what is to be gained by exclusivity? If you have a complex topic or problem you want to discuss, why not...

Michael Valentine Jones (3/6/2009)

---

Instead of this being a club, I like to think of SSC as more like a bar. Come in, set down, have a cold one, and...

Heh... With all the ring knocking going on, I just knew THAT was coming.