Click Here

:-P:-D

Ramya, sample data will be quiet useful here 🙂

Mike, are u sure you will be getting only 3 colors per name ?

-If yes, then we can fix the query easily.

Are there chances that u might get more...

How about this?

select

'MonthNr' ColDesc,

max(case when f1 = '1' then cast(f1 as varchar) end) as [1],

max(case when f1 = '2' then cast(f1 as varchar) end) as [2],

max(case...

You're Welcome, Walter!

This?

; WITH CTE AS

(

SELECT station, addate, adtime, duration, fk_stateid, fk_productid, fk_brandid,

rn = ROW_NUMBER() OVER(PARTITION BY station,substring(adtime,1,5) ORDER BY (SELECT 0))

FROM tbl_radio

)

SELECT station, addate, adtime, duration,...

This ?

SELECT

CASE WHEN KL_EQUIPMENT_TYPE_CD = '20D86' THEN EQ_CNT END AS [20DRY] ,

CASE WHEN KL_EQUIPMENT_TYPE_CD = '40D86' THEN EQ_CNT END AS [40DRY]...

Try this:

SELECT

[20D86] AS [20DRY] ,

[40D86] AS [40DRY] ,

[40D96] AS [40DHC] ,

[45D96] AS [45DRY]...

Can you post your expected result of that sample data ? i am finding it quite hard to understand your requirement..

Thanks for this cute Spackle,Jeff 🙂

Try this :

; WITH Grouper AS

(

SELECT NM.Name , Clr.Color ,

RN = ROW_NUMBER() OVER(PARTITION BY Clr.Name_ID ORDER BY (SELECT 0))

FROM Name NM

INNER JOIN Colors Clr

ON NM.Name_ID...

I feel this is a straight forward answer ; we can understand the intricacies of the problem only if u post sample data.

For the meantime, you can have this:

SELECT NM.Name...

Also i suggest you read thro the following article from one of the Masters of SQL,Mr.Jeff Moden..

Why doesn’t ISNUMERIC work correctly? (SQL Spackle)[/url]

😛 question pls...