OH yeah, Nice one Jeff. As always! Thanks a lot for taking time to teach us some of the tricks of the game. Thaks a lot 🙂

CRAP Reply, please ignore

You are lucky because your columns did not contain any NULLs; that's why you are seeing the same result for all the columns!

Try this examples to know how COUNT(*) and...

Should be careful with the trailing spaces.

declare @var varchar(100) = '1234567890 '

select len(@var)

select datalength(@var)

select SUBSTRING(@var, 1, len(@var)-4) , SUBSTRING(@var, 1, datalength(@var)-4)

Len ...

tommyh (3/28/2012)

---

Wouldnt something like this work just as well?

SELECT

CustomerId

FROM #Purchase

WHERE ProductCode IN ('A','B', 'C')

GROUP BY CustomerID

having sum(case when ProductCode = 'A' then 1 else 0 end) >...

If there are frequent Start and end times, then the number of columns is going to increase heavily and the report will look ugly. Are you sure you want the...

WHy not direct compariosn of colA <> colB ?

You have shown us the sample data, but we need it need it in readily consumable format.. Please read the article i provided in my last post and give us...

There are multiple ways.. We need to see some data and ur table structure to effectively...

What is MAT ? can you explain what your desired result it?

Can we get sample data please?

Please take a look at the following article and give us extra information.. I see that your requirement may be trivial, but with extra information, we can always give tested...

I dint wuite understand what you are trying to achieve here. Can you please take a look at the following article and provide some extra information?

http://www.sqlservercentral.com/articles/Best+Practices/61537/

I know what you are up to and i have a code for that, but i have limited time to set-up sample data and create a query for that

Can you...

How about this?

SELECT T1.ID

,T1.DUE_DTE

,max_ind =...