Hi moeessack123,

The problem with what you have given us is that it leaves us with a lot of detective work to do, and makes it a lot more work to...

looks like some missing commas

“Why doesn’t a virtual table in a FROM clause behave like other subqueries in...

First, minor terminology sticking point: I think you mean DERIVED table.

And second, you need to think of a derived table as a query unto itself. Think of it like...

First, you could probably be using COALESCE instead of a case statement there.

Second, can you provide some sample data for the tables which demonstrates the problem?

Be careful here, getdate() is getting you the current date AND time. And that timestamp stays after adding or subtracting days.

Do you want to compare against seven and 21...

tshad (10/7/2013)

---

That was what I figured - that I set the order in the "IN" clause. But I wasn't sure if that was how it worked.

But the other issue...

It appears that unpivot sets the sort order according to the order given in the IN clause, which is what you want anyway.

If you don't trust that, or something more...

Basically, looks like SSIS is trying to guess at the precision and scale needed, and when you multiply the smallest number first it is doing some rounding.

If you know the...

It seems to me that just because buzzwords start appearing on job descriptions doesn't mean that they are what determines who gets the job when push comes to shove.

The job...

As is often the case, good question, somewhat lacking explanation.

Its still pretty tough to understand all your business rules here. I think its probably just a weird data model throwing this out of whack, and location and resource...

Looks to me like you are one step away. Make the last query (the union) into another CTE, and then select from it grouping by plant number and summing...

Here is what I have. Sort order is not the same as the original post suggested, so we could still use a clairification on those rules.

There is likely a...

Tricky.

Could you clarify your first sample output from above? With HSBC you intersperse the vacation with the new rows of HSBC. With the other banks you show the...