ChrisM@Work (12/4/2013)

---

Dwain, I thought some of that code looked familiar - didn't we...

You can also build a calendar table on-the-fly:

WITH SampleData (accountid, stockid, startdate, enddate) AS

(

SELECT 1,2,CAST('2012-01-02' AS DATETIME),CAST('2012-01-31' AS DATETIME)

UNION ALL SELECT 1,3,'2013-01-31',...

Take a look at these two articles by Jeff Moden on Crosstabs:

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns [/url]

Cross Tabs and Pivots, Part 2 - Dynamic...

Here's another way that avoids DISTINCT:

SELECT a.IPCode, ID

FROM Profile a

JOIN

(

SELECT IPCode

FROM Profile

GROUP BY IPCode

...

If you must do your formatting with SQL (hint: I agree with Sean), you might want to take a look at this article to give you some ideas:

A SQL-Based Universal...

This problem should be solvable without a loop.

However, if you'd like a tested solution you're going to need to help us help you by providing:

- DDL to create the tables...

GordonLiddy (12/3/2013)

---

This article is a complete ripoff from Itzik Ben-Gan's book Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions! Nowhere is there any credits to the original author ......

Steve,

I thought you might want to see this:

http://www.sqlservercentral.com/Forums/FindPost1519227.aspx

By alerting you, I am not vouching for its veracity.

I heard somewhere that TEXT data type is being deprecated.

Is there any reason you can't use a VARCHAR(8000) type? That would be a pretty long text message.

And are all...

OldFashionGang (12/2/2013)

---

You have chosen a strange title for the article. It`s starts with "High-Performance..." but there is no performance comparison between Windowed Functions and other approaches. The article itself is...

To add to pietlinden's suggestion regarding Gail's article, here's...

Your answers to short-circuiting the CSQ is something I've been wondering about for quite some time, without really knowing how to go about testing for it.

So thanks!

Jeff Moden (12/1/2013)

---

dwain.c (12/1/2013)

---

I've lived in Thailand more than 10 years and I can honestly say I've never seen "Crying Tiger" on the menu. But if it made your...

Lynn Pettis (12/1/2013)

---

dwain.c (12/1/2013)

---

Lynn Pettis (12/1/2013)

---

Revenant (11/30/2013)

---

Steve Jones - SSC Editor (11/30/2013)

---

Thanks and a good holiday here. Quiet, with family.

Personally I have no issue with stores opening on Thanksgiving. The...

Lynn Pettis (12/1/2013)

---

Revenant (11/30/2013)

---

Steve Jones - SSC Editor (11/30/2013)

---

Thanks and a good holiday here. Quiet, with family.

Personally I have no issue with stores opening on Thanksgiving. The first time I...