Row ordering is never guaranteed on retrieval unless you explicitly specify ORDER BY.

It just so happens that the times are being retrieved in order because that's probably the order you...

There's a performance comparison in the linked article, but the short answer is...

oliveraustin (1/28/2014)

---

Ah ha, thought how to reduce the problem size down to 12 groups 🙂

Since the Roles with multiple groups consist of<=12 groups and the rest of the all I...

Evil Kraig F (1/28/2014)

---

Amusingly:

select power(2...

Check the following article:

Logging and Error Handling for SQL Stored Procedures [/url]

In the TRY steps, where it captures the error information, you can add code to send your email alert.

You...

Nice thought, but I think you're referring to the articles by Jeff...

Check the first link in my signatures for another concept you can apply to this (the CROSS APPLY VALUES approach to UNPIVOT).

SELECT citation

FROM

(

SELECT b.citation, a.header, a.rn,...

I would bet it's not memory that's the issue. It's row counts.

Consider the case where you said you have one user in 32 groups. That user alone would...

AndrewSQLDBA (1/27/2014)

---

Thanks Dwain.C

That did the trick for that. What are you talking about, "special characters"? You did not include the article. There are some rows that use RTF data, would...

Technically what the OP is looking for is combinations (not permutations).

If your fiscal year always starts on April Fool's Day, you don't even need the master table:

WITH Detail_table (Cust_no, [Date]) AS

(

SELECT 'A',CAST('2011-07-15' AS DATETIME) -- 15/07/11

UNION ALL SELECT 'B','2011-09-21' --21/09/11

UNION...

Here's my interpretation of your requirement:

WITH SampleData (C1, C2) AS

(

SELECT 'A', 'AA'

UNION ALL SELECT 'A', 'BB'

UNION ALL SELECT...

Take a look at this SQL Spackle article by Wayne Sheffield: Creating a comma-separated list[/url]

SELECT DocumentDataID=MIN(DocumentDataID), PersonDataID

,DocumentData=

(

...

Take a look at this article:

Generating n-Tuples with SQL[/url]

Then look into the discussion thread for a slight performance improvement on the approach:

http://www.sqlservercentral.com/Forums/Topic1301485-3122-5.aspx

Coding up the improved approach with your sample data...

Lowell,

I'm sure you already know this but there are times that CPU can be quite a lot more than elapsed time, specifically when SQL parallelizes a query. That doesn't...