You're right Phil... I looked at the question too fast and didn't pay close enough attention to the desired output. Mia Culpa...

The easiest way is to simply reverse the order of your ROW_NUMBER... Just sort in DESC order instead of ASC...

Grad to help. 🙂

Here's an alternate approach...

IF OBJECT_ID('tempdb..#ReportFields') IS NOT NULL

DROP TABLE #ReportFields;

CREATE TABLE #ReportFields (

ReportID INT,

FieldName VARCHAR(20),

TotalNumberOfFields INT

);

INSERT #ReportFields (ReportID, FieldName, TotalNumberOfFields) VALUES

(1,'ID',5),

(1,'FirstName',5),

(1,'MiddleName',5),

(1,'LastName',5),

(1,'BirthDate',5),

(2,'ID',2),

(2,'LastNAme',2),

(3,'ID',1),

(4,'HairColor',3),

(4,'EyeColor',3),

(4,'Ethnicity',3);

SELECT

rf1.ReportID AS Report_1,

rf2.ReportID AS Report_2,

COUNT(*) AS...

subramanyammaruthi (9/12/2015)

---

Hello!!Can any one please let know how to use like operator select statement to retrieve multiple column names in sql server DBfor ex: I have a table say employees...

trvlbabie (9/11/2015)

---

This works if I'm only needing to use the SELECT ALL piece but where I have a multi-value parameter that if a specific or multiple auditors are selected from...

As stated by others, it's not very clear what it is your trying to accomplish...

On the off chance that I did correctly understand the requirement, give the following a...

Try it like this...

=Parameters!ReportParameter1.Count

In that case, you'll need to know the maximum number of dates the ERP can throw at you... The problem is that...

At this point I think we need to see, from the profiler, exactly what's being passed and how it's being passed.

If it looks like this... EXEC dbo.MyStoredProc '2015-01-01,2015-02-02,2015-03-03', 'ps', 't'......

Unless CR has changed drastically since the last time I used it, it's not going to be able to do anything with the ever changing set of input columns provided...

Ok... Here's yor original post...

aleksandra 81219 (9/3/2015)

---

Hi! I have some T-sql procedures and function witch are getting from system sth like this

@days='20150401,20150406'

In my code many times i have to...

Starting to feel a bit like this...

Who's on first?

aleksandra 81219 (9/4/2015)

---

Hmmm so next procedure to execute first procedure? I would prefer to avoid such step because its embedded next in erp system... What is more now we have...