Terry,

before you do much of anything, I would recommend reading Jeff Moden's article[/url] (and borrow his code) for his DelimitedSplit8K TVF. It will split your data up really easily...

Here's...

It's better to include the entire problem in your description, as well as any SQL necessary to reproduce your setup/problem. If you give people enough information to easily answer...

One option might be to add a calculated field that returns just the date (no time) to your dataset and then use that to filter your dates.

=DateValue(Fields!orderdate.Value)

Any chance you could post some data (it can be fake... just representative) in the form of either a CREATE TABLE and INSERT scripts or a union query....

SELECT TxDate, Fraction,...

I guess you need to explain the context in which you are doing this. Why is creating a stored procedure and executing it not an option? Seems silly...

Googlefu turned up this:

select

Catalog.name,

cat1.Name datasource

from

Catalog

join DataSource

on Catalog.ItemID = DataSource.ItemID

join Catalog cat1

on DataSource.Link...

So how do you identify the records you want to save?

TOP 50 (with a cross apply).

then delete the rest... so either NOT IN ... or outer join...

Can't help without understanding the question. What does this mean?

What is the query supposed to do? Is it supposed...

If you open the report as an XML file, you'll see the <DataSets> section with <Query> delimiter. So you'd just use XQuery to grab the contents of that part.

Now that I've finally gotten this to work, this is how I did it. (I'm using 2012 but compatibility is 2008).

In all honesty, since I completely forgot how to...

make the boolean parameters calculated? (based on whatever is in the other dataset(s))

You can use something like this:

Note: DummyMVParam is a multi-value parameter in my report.

so this is what my test is doing:

If there are less than 4 values selected from the...

without sample data, it's hard to tell, but my guess is that you're missing a WHERE clause...

SELECT PartNumber, SerialNumber, MAX(InspectionDate) AS LastInspection

FROM MyTable

WHERE PartNumber IS NOT NULL

GROUP BY PartNumber, SerialNumber

ORDER...

like falling down...

SELECT PartNumber, SerialNumber, MAX(InspectionDate) AS LastInspection

FROM MyTable

GROUP BY PartNumber, SerialNumber

ORDER BY PartNumber, SerialNumber;

Okay, so humor everybody...

post the entire stored procedure... pin the tail on the donkey isn't our favorite game.