Thank You Jeff,

Let me read thru it, mess around with some data, I will get back with some data if I get hung up.

I really appreciate the info, Thank you...

Hi JEff,

Thanks for getting back. I have posted before, but honestly , not sure how to post the data in consumable format. Any how to links?

Thanks

Hmmm,

The data seems to be all over the place ,but it would be the datetime between "~__ " and "GMTOFFSET=-18000"

even though it looks like there is a DPT number on...

Hi Scott,

Thank You, that's exactly what I needed.

The only issue I have now is, I looked thru the entire table(500k+ records) , since I got a error, and discovered that...

Hi Steve,

Thanks for getting back. I was given this table and figured out that this field a varchar(4000) was the field with the start and end dates times.  I know...

I Think I'll have to split them into multiple tables. Thank You for the advice...

Sorry after looking at my output, that's exactly what I did use matrix instead of a tablix 🙂

Thanks

Hi Brian,

I think is the exact logic, I'm looking for.

I do have some more if,and or but's, but let me play around with it.

I do reserve the right to ask...

Ok, sorry, I did not Define Start and End Dates.....

But , do the value not get passed from the reports main report to the subscriptions query?

Because when I ran it...

Well, I started testing with real data and I think this will work...

I wrote the data to a temp table, applied your logic and getting the results I think I...

Yes! thank you....

I've been a bit busy with other things, but dying to start playing with this!! lol

I'll report back...

Thanks Kevin,

Not totally sure on what's going on it the code, but I'll teach myself....lol

Let me apply it to a real life situation and I'll get let you know....

Thanks Again...

Joe

Thank You Phil,

I think I can work with this ....

Much appreciated!!

I was using this as a sample, I actually order by a personObjectId in the query that writes to the temp table.

I see ur point,  but wouldn't I be safe if I ran it thru something like Ssrs using a date parameter?