Thank you, Luis. I have had a chance to look it over. I am comfortable with most of it, but still looking over a few pieces of the code to...

also, I will be adding columns to these rows after I get the rows to display.....they will be calculations based on values in other tables.

Here is what I have so far:

SELECT

prod.ID,

prod.Machine,

prod.StartTime,

DATEADD(dd, DATEDIFF(dd, 0, prod.EndTime), 0)

FROM

prod

WHERE

...

I resolved this....thank you.

nevermind.....i got it!!! just put the query in the WITH, aliased that. then followed through the example.

thank you soo much!!

okay....had a chance to get back to this....sorry about the delay.

in the from clause there are 3 table joins. I see that you use raw_data and then reference this again...

not that familiar with CTEs. I was able to make this work and was able to follow it, but could it be done without a CTE? For example, just joining...

I ended up going with the first suggestion by Want a cool Sig and it worked just as I needed.

I will also try the others to see if I...

THAT DID IT!!!

Thank you so much for the help. It has been over a day of looking around online for why this was erroring out and I had a...

This makes sense...since there is no data present for today's date......

Would this be done in the stored procedure or in the control flow? What is the best way to do...

Yes...Here is what is under the Result Set

Result Name = 0

Variable Name = User::XMLVariable

When I look at the variables:

Name = XMLVariable

Scope = Package

Data Type = String

I did a test with...

After countless hours of troubleshooting, I found the problem that caused the filtering not to work. The table that I was accessing that stored the team name (in this case...

Hello Jack,

Yes, I did some research online over the weekend and I came across that suggestion. I tried the following:

A

"A"

=A

="A"

None of which worked, but when I ran the query to...