Of course. Can you post...

Nageswari.J (6/20/2012)

---

Hi Chris

Yeah u r correct, I also face the same problem when i checked.. I thought to ask to u. before itself u answered... Thanks once...

pwalter83 (6/19/2012)

---

Could be...

Your first post has a code sample like so:

DECLARE @eof as nchar(1)

DECLARE @replace as nvarchar(max)

DECLARE @exec as nvarchar(max)

SELECT @eof = CONVERT(NCHAR(1), 0xFDF8)

SELECT @replace = char(39) + char(39) + char(39) +...

Paul, how many rows max will you have to roll up like this? Your example shows two rows - can it be 3, or 4, or n?

snigdhandream (6/19/2012)

---

I have a large table having millions of rows. There is one datetime column which captures the date and time a row is inserted to the table. Now, I...

If you absolutely cannot follow any of Grant's excellent suggestions, then there is a cheat which may work for you:

-- fuzzy non-blocking prefetch, faster without blob column

SELECT [ONLY the...

Fuzzy matching generates a similarity index between two strings: try this and this.

Cheers

ChrisM

Gosh, thanks for the generous comments guys - however, the method fails if the sample data set is expanded to have more sales than buys within a partition. Here's code...

This generates the correct results from the given sample data, however I'd be more comfortable with a larger sample:

;WITH Buys AS (

SELECT rn = ROW_NUMBER() OVER (PARTITION BY clientcode, productid...

Interesting. Care to elaborate?

Have a look at Glenn Berry's diagnostic information queries[/url]. Two of these queries should be particularly relevant to you; missing indexes, and unused indexes. The comments attached to both are...

The #temp...

Jeff Moden (6/15/2012)

---

ChrisM@Work (6/15/2012)

---

vinu512 (6/15/2012)

---

ChrisM@Work (6/15/2012)

---

anthony.green (6/15/2012)

---

Thanks guys, much appreciated. Was racking the brain yesterday on that and for the life of me couldnt get unpivot working.

I like the...

I'm right with you on that Sean. There are some other quirks in the query which suggest that if it's generating correct results, it is, to some extent, a happy...