Thanks Craig,

I've hardly had any experience with CTE's before but I am learning thanks to helpful people like yourself and few good examples/articles on the internet. Thanks for pointing out...

Craig Farrell (3/7/2011)

---

Note in cte that there's the ROW_NUMBER() component. Inside there, is the PARTITION BY. That Partitioning will control how it organizes the data. Take a...

Thanks Craig,

I've tried the code out it works as expected but the results get a bit screwed when I add other columns, e.g. from the data example above if I...

If more data/information is required please do let me know.

Thanks heaps!

K

Hi Craig,

Sorry about that, below sample code.

Also this for 2008 R2

IF OBJECT_ID('TempDB..#mytable', 'U') IS NOT NULL

DROP TABLE #mytable

--===== Create the test table with

CREATE TABLE...

Solution

=IIf(((Parameters!Param_Table.Value = "TABLE_CC_") AndAlso (Parameters!Param_System.Value <> "R")),False,True)

Good idea, but this wont really work if the subscriptions are on 'Linked Reports'

Should have mentioned it in my questions - that the subscriptions are actually on the Linked Reports

Fantastic, I got my result.

Looking at the query, I now I understand what mistake I was doing.

Thanks for your help and support.

Pakki (8/27/2009)

---

Give some other table name as the alias for the nested table (lets say tli2)

U mean to say this is also giving the same error?

SELECT c.claimnumber AS claimnumber,

tli1.UpdateTime as...

Pakki (8/27/2009)

---

Not sure if I am overlooking this, the last 'ON' cluase is,

ON c.ID = t1.ClaimID

Dont you think it should be tli1 instead of t1 in t1.ClaimID?

Ohh sorry, you...