Viewing 15 posts - 1,321 through 1,335 (of 8,761 total)
Just for fun, here is a completely different kind of solution
😎
Using Phil's data sample
;WITH PROD_COMPARE AS
(
SELECT
...
July 1, 2018 at 2:11 am
Cannot see any reason for scanning the table to produce the week numbers when it can be done more efficiently without it.
😎
Here is a far better...
July 1, 2018 at 1:12 am
Did you manage to do this?
😎
July 1, 2018 at 1:00 am
June 29, 2018 at 9:20 am
June 29, 2018 at 8:29 am
Good Morning Experts,
As per our DBA guidelines, tempdb data files are stored in G...
June 29, 2018 at 3:32 am
June 26, 2018 at 6:58 am
The solution is to use FOR XML PATH('') inside the sub-queries and alias the selection of those.
June 26, 2018 at 6:21 am
Can you post the expected results please?
😎
June 26, 2018 at 5:20 am
June 25, 2018 at 11:15 am
June 25, 2018 at 10:49 am
Not very easy to discern which Excel version includes the product, and how we'd...
June 25, 2018 at 10:09 am
I mean it is...
June 23, 2018 at 11:43 am
Viewing 15 posts - 1,321 through 1,335 (of 8,761 total)