Lynn Pettis (3/26/2009)

---

Having found out he lives in Denver, we just need to get him to start attending the SQL Server Users Group meetings up there. Perhaps by interacting...

Chris Morris (3/26/2009)

---

Luke L (3/26/2009)

---

Best part is one of the local wineries grow radioactive grapes for their wines, or so the story goes... Never tested it to see if it...

Grant Fritchey (3/26/2009)

---

Bob Hovious (3/26/2009)

---

CONGRATULATIONS, ROY !!!!!

YOU are Mr. 3000.

In honor of this momentous occasion, you get to buy beers for the whole...

RBarryYoung (3/26/2009)

---

Well, I do...

Dang... now I'm disappointed... I was sure that you could read minds... 😛

krushnasahu (3/26/2009)

---

I have some more doubts.

Actually I need to run an exe file from stored proc.

So, I wrote the stored proc like:

create proc callExe

As

EXEC xp_cmdshell '\\192.10.10.245\E:\PrintToPDFConsole.exe'

In this 192.10.10.245 is another...

mark_92708 (2/27/2009)

---

Thanks Jeff for the feedback. I did look over your article prior to coming up with the solution I used. My only challenge with the approach in the article,...

Heh... I'm with Michael... you don't need to call someone a name to hit them with the pork chop that has the code stuffing.

Cool... would you mind posting your function... we may be able to make an improvement here and there.

Wow.... you're right. I've never seen the XML concatenation method run so slow. Now that we have the test data you want, I believe we can do a...

Correct... ROW_NUMBER() does not exist in 2k.

Lowell's code looks good to accomplish what you want, I believe. The question would be, what's in the table with the number when...

Hey Shamshad... any feedback on this?

C'mon Grady... the reason why I'm asking is because I believe you're getting the wrong answer. Besides, it's a two way street here. 😉

Ummm..... no it's not... INSTR in PL/SQL is the equivalent of CHARINDEX...

BWAA-HAA!!! I guess "it depends" on who produces the non-Null/greater than zero result set to that query and when. 😀