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...

Here's a start. Test and comment.

Declare @portfolioId Varchar(8000),

@ParentWorkids Varchar(50)

Set @portfolioId = '1800m380000iot22g3t0000000_1800m380000io7c5nr50000000' -- this looks like TWO concatenated portfolioIds

set @ParentWorkids = '1801a2g0000ih0vl2abg000000'

---------------------------------------------------------------------------

SELECT child_work_id = [object_id],

PrimaryBBPProcess = MAX(CASE WHEN...