I think it would be easier for most of us if you'd provide sample data and expected result instead of a code snippet (not even sure what programming language that...

Revenant (9/7/2010)

---

The correct way is to celebrate a Feb 29th birthday on the 28th, that's how the Roman (Catholic) calendar does it. In fact, it is not the 29th...

Instead of trying to explain what you're looking for it would be more efficient if you would provide table def and sample data in a ready to use format as...

Quite a while ago I thought using PIVOT would be, well... "cool".

After I figured how the syntax needs to be I was surprised that it didn't provide any performance gain...

Try one...

I would use CROSS APPLY on a 10 row table (or subquery):

DECLARE @t TABLE(ID INT, SNO INT)

INSERT INTO @t

SELECT 1,5124 UNION ALL

SELECT 2,6231

SELECT t.ID , t.SNO + z.N

FROM @t...

Would you mind sharing your solution so others might benefit from it?

ioani (9/7/2010)

---

Sorry, I have a little error in may sample data. P5 should have only one '20100803' ParameterTimestamp value. The ParameterID should have distinct ParameterTimestamp (the ParameterID and ParamterTimestamp form...

Errrmmm... that's a requirement not seen very often... 😉

One option would be to create a c.u.r.s.o.r. on a rather large table (to "avoid" a set based operation).

Inside the c.u.r.s.o.r.:

Join a...

I would change the design of the table:

Unpivot the data, reduce it to have only values other than Zero and add a unique constraint on Flg_type.

You'd basically have a table...

Herer's the CrossTab method I would use. It's describe in more details in the related link in my signature.

One thing to notice: Your sample data have multiple rows for P5...

anuhya.mudumba (9/6/2010)

---

Hey Lutz......

U r right....i have the same doubts though but i instructed to bring the max benifits of using ssrs and it is one among them.

i have to do...

I think you're looking for UNION ALL...

Select A1, A2 from A WHERE @CheckA = 1

UNION ALL

Select B1, B2 from B WHERE @CheckB = 1

UNION ALL

Select C1, C2 from C WHERE...

You should specifically state the collation you want to use.

Example:

SELECT col2 COLLATE Latin_General_CP1_cI_AS AS col1_collation FROM myTable WHERE col1=1

anuhya.mudumba (9/5/2010)

---

Thanks Lutz for your reply...

I cannot use it in the sql part. The requiremment is such that i should get the raw data from the tables and perform all...