Viewing 15 posts - 346 through 360 (of 499 total)
Post the error message, please
December 19, 2014 at 1:59 pm
You need to delete the column from your report as well. It is not automatic
December 19, 2014 at 12:49 pm
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...
December 19, 2014 at 12:46 pm
What's at line 724 of Usp_CopyProcedure?
December 19, 2014 at 12:40 pm
SELECT fmc_terminal
, fmc_prodlnk
, fmc_cost
, lag(fmc_date)OVER(PARTITION BY fmc_terminal
...
December 12, 2014 at 8:50 am
SELECT fmc_terminal
, fmc_prodlnk
, fmc_cost
, lag(fmc_date)OVER(PARTITION BY fmc_terminal
...
December 12, 2014 at 7:30 am
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...
December 11, 2014 at 7:30 am
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...
December 9, 2014 at 1:41 pm
"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
December 5, 2014 at 2:26 pm
are you explicitly defining the variables by using the :Setvar command?
December 5, 2014 at 10:37 am
Viewing 15 posts - 346 through 360 (of 499 total)