Yeah... my first swag would be that this might be a boondoggle... tell me which company in the world has 50 million employees as the op suggests. 😉

Ah... understood. Then, you may not need a book at all... there're examples in Books Online.

Mike Levan (11/3/2008)

---

we have db's with same schema in the same instance, and this query is ran in all the db's and they run very gud except this db. what...

Lynn Pettis (11/3/2008)

---

Jeff Moden (11/3/2008)

---

Sridevi (11/3/2008)

---

Many Thanks to you.

I wrote a function and i got the result too.

CREATE FUNCTION select_concat (@A INT )

RETURNS VARCHAR(MAX) AS BEGIN

...

Then you should probably split it up... doing an update on something that large all at once will probably drive your code past the "tipping point" that every server seems...

aevans1981 (11/4/2008)

---

First, thanks for a great function, however...

I have read through most of this post, but not all, I am using the code that was originally supplied.

When I try fn_WorkDays(27/10/2008...

Heh... the best tip has already been given... did you get rid of the cursor?;)

Some will take exception to it, but my feeling is that if it will never me anything but a (-1), then hardcoding it makes it pretty clear when it comes...

Heh... thanks, Peter... I put that in my code but forgot to mention it.

sam (11/4/2008)

---

Hi Jeff,

Thanks for the direction. I still am finding it difficult to understand how to do this. The deadline for this is today, is there anyway you...

I'd probably make a Clustered PK on Phone_ID.

I'd seriously question why User_ID is going to be stored as a VARCHAR(20) but believe it would also need an index.......

Robert klimes (11/4/2008)

---

The tally table is definately something I can use, thank to all who pointed it out. But I am now having trouble now getting all the parsed values...

Spot-on, David.

stax68 (11/4/2008)

---

Oh, I do - mens sana in corpore sano old chap.

And, don't blame me if you don't understand what I'm saying....

Keep it clean, slick. 😉 And, don't blame me if you don't understand what I'm saying. :w00t: