You would have to check the input parameters for NULLs and then skip those. That might mean that you have a zillion different updates (one for each parameter), or...

Once you use the code in the link, you could use XQuery to extract the information from the report's XML that you need... just parse it and then insert that...

This might get you started:

http://bretstateham.com/extracting-ssrs-report-rdl-xml-from-the-reportserver-database/

sounds like you need a subreport

How many rows are in your table?

You could do something simple like

DELETE FROM MyDB.dbo.MyTable WHERE <filter>...

but if you are deleting a lot of rows, there may be better ways...

I would check to see that when you're doing an assignment like that, are you returning a single value... Does all the code work as expected?

Normally, I would document this...

Maybe start by telling us what you think is the logic. Not sure of the question, though... One usually starts with a question about what one wants to see...

In Crystal Reports, when adding parameters, it allowed you to easily display a description field with the parameter field value.

For example, I could display the project name with the project...

Since you're kinda new here, I fixed your SQL so that it works...

use tempdb;

go

CREATE TABLE ProviderData (PROVIDER_ID CHAR(10),

PATIENT_ID CHAR(10),

CARE_LEVEL CHAR(10),

BEGIN_DT DATETIME,

END_DT DATETIME);

GO

INSERT INTO ProviderData(Provider_ID, Patient_ID, Care_level, Begin_Dt, End_Dt) VALUES...

Are you doing this in SSRS? Use a Matrix... does the pivot for you.

Use DelimitedSplit8K and grab the 3rd item?

Yes, because otherwise SSRS will see it as a single long text string. If you're passing it to a stored procedure as a parameter value, then you absolutely need...

If you do that, you'll have to parse the values yourself. Try DelimitedSplit8K[/url] and put that in your WHERE clause.

Marie,

That's what I was thinking... It's just easier to do this in steps. Then maybe put them all in a stored procedure, if this has to be done more...

so write it to a temp table and do a series of updates on it.