Its random. I'd say one out of 3 times on average. BTW, where did you get the update to SSMS?

You could also pass the parameter as a string "1,2,3,4" and use Jeff Moden's CSV splitter to parse it.

http://www.sqlservercentral.com/articles/Tally+Table/72993//url%5D

1. What does the execution plan look like? Do you see scans instead of seeks? Does the plan suggest indices? These could be performance factors.

2. the Order by...

You're feeling the pain of many of us who have done the same thing. Basically, SSRS does not export to Excel very well. There are some things ...

I initially had trouble parsing the suggested answers since "The Heap had rebuilt." is missing a participle. I suppose what was meant is "The Heap was rebuilt."

Perhaps the...

Are you displaying the string "1.00 - 2.00"? If so, you'll have to roll your own formatting. Something like (untested):

=FormatCurrency(Fields!val1.Value,0) + " - " + FormatCurrency(Fields!val2.Value,0)

Add another windowed function:

sum(hours) over (partition by NiveauZPT)

(Interresant om het nederlands in de schema te zien!)

What errors are you getting? It's actually normal for a dataset in SSRS to return no rows. The Table and Matrix widgets handle that automatically. You'll just...

In a textbox, right-click and choose Expression. There you can use the CountRows (and many other) functions

Add a new column to the select:

Count(*) over(partition by MwID) as MwID_Count

There is a CountRows function that you can use. If it returns 0 for your dataset, display the No Rows Found message.

If you reformat your big query as a collection of smaller CTEs and one final insert, it will be easier to read (for you, me and whoever has to support...

Does the query plan show scans instead of seeks? Are the predicates (JOINS and WHERE clauses) indexed in the source tables? Are there many indexes on the target...

when you execute dynamic sql, it runs in a different context and cannot see variables declared in the calling context

Use DateDiff (in seconds) then extract hours and minutes from the result (divide by 60, the remainder is seconds, divide the quotient by 60, the quotient is hours and the...