Sergiy is correct... the "table" can't be defragged without a clustered index.

Now, with that in mind, you will, unfortunately, need a loop of some sort to get throgh all of...

I guess a better question would be, how did the double quotes get there in the first place? Did you import some text-qualified CSV or something? If so,...

Heh... thanks for the plug, BitBucket!

A way kind of backwards from Cross Tabs is shown in the following article...

http://www.sqlservercentral.com/articles/Test+Data/61572/

The method would allow you to concatenate all the stakeholders into a...

rbarryyoung (8/24/2008)

---

This is the same conclusion that I have come to over the past few months, Jeff. I would much rather rewrite a query straight from the Specs, than...

You're welcome... but if you post the CREATE TABLE and data that I suggested, you might even get a tested example to play with... 😉

John R. Hanson (8/21/2008)

---

These are Important Ideas even more so today, as Enterprise Data is growing. My concern with the solution is that you are inserting rows to the table,...

Heh... the thing I absolutely "love" about the idea of ANSI standards is... if we all do it their way, there will be no need for competition amongst the makers...

Heh... stop and look at it this way... you didn't get that old being stupid and employers who want some real talent in their ranks are beginning to realize that...

Sagar (8/24/2008)

---

code looks like below... also have another question as well... there are lots of temp table inside stored proc.. i was thinking of removing temp table and using...

Hey guys... Arjun is trying...

Heh... I'm a little biased... please see the following articles on the subject of Tally tables and splits...

http://www.sqlservercentral.com/articles/TSQL/62867/

http://www.sqlservercentral.com/articles/T-SQL/63003/

For the problem at hand, the following works just fine...

First, create the Tally...

Sagar (8/23/2008)

---

Can someone help to how to remove the cursor. when i look at the stored proc most of the stored proc are using cursor. I also figuered...

It sounds like they don't really know databases at all because they don't really understand that SQL is not SQL and that taking care of the servers for different RDBMS's...

Very cool feedback, Rog. Thanks.

You better believe that even a simple subquery is beyond many users. I hope you understand where I'm coming from. How to make this stuff...

dphillips (8/20/2008)

---

When one wants no NULLs in the output, is it not faster to put that in the base FROM "derived table", view, or query... the same as mentioned when...