Unfortunately, that's about as clear as mud. When you set up a report to execute a stored procedure, there are a couple of ways to do it....

Unfortunately, I didn't know about the compatibility level because you didn't mention it, and you posted the question in the SQL 2008 forum, so I naturally assumed I could develop...

Okay Scott... what, exactly, is "DAS" ? I'm usually in a contract role, and usually for long enough that I don't stay in one place for all...

I meant how the report executes the stored procedure. If it uses query text to do an EXEC sp_name @parm1, @parm2, ... then you might need to make...

I had decided to just stop posting on this topic until I saw your most recent post. I may not have the right interpretation of it, as it is...

Check how it executes the stored procedure. If that parameter is still part of that process, it will need to be changed to not use the parameter.

You didn't mention what technology "DAS" is, but I have to assume that since local disk is faster, that it's probably a SAN. Are you good to go...

As posted by pietlinden, yes, that's how you learn. Check out Books Online (as was suggested), and don't expect someone else to do ALL the work for you.

I'm pretty sure this has to be done with dynamic SQL, as I believe the OPENROWSET requires a text string input, and can't accept a variable, so that's the only...

It seems likely that your assumption about the meaning of the value for @unix_date is where the problem lies, and it appears that seconds or milliseconds or microseconds just isn't...

The results from the final query I supplied are as follows:

Score Percentile

===== ========

37 25

55 25

73 25

75...

If you aren't doing a backup to a local disk, then it's either another server across the network, or it's a SAN, across a SAN network. Either way,...

Also, instead of NTILE(4), the ROW_NUMBER() function would need to be used, with the OVER clause including the new sorting field I mentioned previously.

Did you have a typo in your desired results? You have the same percentile in the last two sets of numbers as you have for the first...

I'm still pretty sure you don't need a sub-report at all. You can derive the averages and any column totals if needed, within SSRS. Did you...