..as I said. Pity...

Luis Cazares (12/23/2014)

---

g.britton (12/23/2014)

---

The problem with the fourth option is that the nested query needs to be in parentheses. So this works:

SELECT SUBSTRING( ( SELECT ', '...

Simple, yes. Performant?...

The problem with the fourth option is that the nested query needs to be in parentheses. So this works:

SELECT SUBSTRING( ( SELECT ', ' + productname FROM...

That's what parameters are for in SSRS

Post the error message, please

You need to delete the column from your report as well. It is not automatic

Try adding an ORDER BY clause at the end like this:

ORDER By CASE EDI_PARTNER

WHEN 'INTTRA' THEN 1

WHEN 'GTNEXUS' THEN 2

...

WHEN 'EXPEDITORS' THEN 9

ELSE 10

END

, EDI_PARTNER_CD

Idea is, you have a two-tiered...

What's at line 724 of Usp_CopyProcedure?

SELECT fmc_terminal

, fmc_prodlnk

, fmc_cost

, lag(fmc_date)OVER(PARTITION BY fmc_terminal

...

SELECT fmc_terminal

, fmc_prodlnk

, fmc_cost

, lag(fmc_date)OVER(PARTITION BY fmc_terminal

...

Reading the question literally, I would say that no rows are "affected" in the Message pane. That is, nothing happens to whatever appears in the message pane; stuff just...

Since SSRS just passes a comma-delimited string, I write my query like this:

select ...

from ...

where column in (@var)

and either:

1. put the base query in a view or TVF and add...

"The With statement executes just fine. sub 2 seconds on 974 records"

Do you mean the With clause plus the first query? Otherwise it make no sense

are you explicitly defining the variables by using the :Setvar command?