Jeffrey,

You aren't missing anything. I just didn't explain the whole picture well enough. The reason it won't work to do filtering on the adjustments table is because that...

Jeff,

The real table has more than three columns to it, but the only one that I'm interested in is the AdjustmentName column (Where they begin with pp_). We want...

I understand what you are doing but I already have the items I need in a table. I put them into the variable as a comma separated list so...

Thanks. I've got it exporting to a file now.

I need to make this more dynamic because in practice, the records equivilant to my level_id field in my example could...

I've used SSIS quite a bit and yes, that would do what we need but because of the application it would be much quicker to use this since our analysts...

Thanks Jeff to you for all of your help and follow up to all of us on the forum! Your input and help is greatly appreciated!

If it is reopened more than once it still works because we start with the first seq and then calcualte all the way through the open and close dates based...

Thanks for your help. This isn't complete yet, but after some initial checks this appears to be returning what I need.

SELECT op_m1.mileid,

op_m1.opid,

op_m1.mile_code,

op_m1.mile_status,

op_m1.seq,

CASE WHEN op_m1.seq = 1 THEN op_m1.first_open_date ELSE...

Understand. I've seen them as well.

I am going to review your suggestions (probably tonight) and see what kind of a difference it makes. Thanks for your input.

Tomm,

Thanks for your input and I understand your points. One thing that I did not mention is that this is all being pulled from a data warehouse. Thus...

Thanks for all your help John! Would have probably taken a lot longer and been less efficient if not for your input. Here is what I ended up...

Sorry John, but when I looked earlier there was a message that just said to change the FROM and WHERE clauses to something other than what you have listed here....

Thanks, but for the months that have already happened it returns two rows. One with the data and one wtih all null values. For future months it just...

I tried what you suggested with the WHERE clause but no luck.

Here is a script that builds the tables and loads them with sample data. What I want is...

Yes, I can. I'll prepare some and post them tomorrow.