Viewing 15 posts - 901 through 915 (of 10,144 total)
This is a little bit involved (for me!) as it is...
February 15, 2017 at 6:21 am
Thanks.
Try this - which gets rid of some implicit conversions:
SELECT
February 14, 2017 at 6:57 am
February 14, 2017 at 6:45 am
This actually may be more of a math problem than anything else.... apologies if inappropriate.
We...
February 14, 2017 at 6:22 am
Also, check the output of this against your original. It's likely to be different.
SELECT
February 14, 2017 at 5:42 am
Can you capture the actual execution plan in ssms and post it as a .sqlplan file attachment please?
The query looks overengineered.
February 14, 2017 at 5:35 am
There are dupes in your sample data set - is this intentional or an oversight?
IF
February 13, 2017 at 2:06 am
| ParentWO 2088/1.1 | IssueQty 14 | ChildWO 2088/1.1.1 | Production_Qty 40 | Qty_Complete 40 |
| 2088/1.1 | 25 | 2088/1.1.1 | 40 | 40 |
| 2088/1.1 | 1 | 2088/1.1.2 | 40 | 40 |
| 2088/1.1 | 14 | 2088/1.1.2 | 40 | 40 |
| 2088/1.1.1 | 40 | 2088/1.1.1.1 | 40 | 40 |
| 2088/1.1.2 | 40 | 2088/1.1.2.1 | 40 | 40 |
I have rewritten the CTE query...
February 13, 2017 at 1:55 am
This is about as far as anyone can help until you've followed up Thom's post:
SELECT...
February 10, 2017 at 5:54 am
Dunno how I landed here, but...here's how I'd do it in current versions (this doesn't work with '2005):
SELECT
February 10, 2017 at 2:53 am
-- Original date expression
February 10, 2017 at 2:01 am
February 10, 2017 at 1:42 am
Here's another way of doing the same as Luis' suggestion which I find more intuitive (but that's just personal preference)
February 10, 2017 at 1:24 am
February 9, 2017 at 9:22 am
February 9, 2017 at 9:10 am
Viewing 15 posts - 901 through 915 (of 10,144 total)