depends on what the SP FRACAS_TicketVsEvent does

That proves why my code...

Yeah Gus, it occured to me just after posting the code. Thanks for...

How about this?

; WITH CTE AS

(

SELECT P.CustomerID

, Indicator1 = CASE WHEN P.ProductCode IN('A') THEN 0

WHEN P.ProductCode IN('C') THEN -1

END

,...

THis?

SELECT Tab.String

,NewStr = CASE WHEN LEFT(Tab.String,1) = '0' THEN STUFF (Tab.String,1, PATINDEX('%[1-9]%',Tab.String) -1 , '' )

...

This?

SELECT Tab.String

,NewStr = CASE WHEN LEFT(Tab.String,1) = '0' THEN STUFF (Tab.String,1,1,'')

...

Can you post the query you tried ?

And also, can you post the data in readily-consumable format? I cannot download content at my office.

Please read here on how ro format...

GROUP BY with ROLLUPs may be?

Interestingly, this yields 0 for a table that contains no null values and also uses COUNT(*) as the StreamAggregate operator. (It is also once noted by Paul White, but i...

Sean Lange (3/29/2012)

---

You have me a bit confused by this. Count(*) and Count(1)...

chintan.j.gandhi (3/29/2012)

---

How about this? Although i agree query might get longer when there would be more than 3 items

SELECT DISTINCT CustomerID

FROM #Purchase P

WHERE EXISTS...

LIke this

IF OBJECT_ID('TempDB..#Temp') IS NOT NULL

DROP TABLE #Temp;

GO

;

CREATE TABLE #Temp

(

Store INT

,PhoneNr VARCHAR(20)

)

;

INSERT INTO #Temp (Store,PhoneNr)

...

Look up PIVOT in SQL MSDN Online.

dwain.c (3/29/2012)

---

ColdCoffee:

So I think what you're saying (I am not an XML Plan-master, nor even a Paduan) is that COUNT(column_name) returns the number of rows that have non-NULL values? ...

dwain.c (3/28/2012)

---

My understanding is that it doesn't matter whether you count all columns (*), a single column or a scalar value, the count returned is always the number of rows...