Viewing 15 posts - 511 through 525 (of 10,144 total)
November 6, 2017 at 8:28 am
Here's an alternative method. The results match your expected output except for the last row which I think has incorrect startdate:SELECT pd.Stack, pd.ProductCode, pd.Discount1,
x.ValidFrom, x.ValidTo
November 6, 2017 at 6:18 am
Jeff Moden - Thursday, November 2, 2017 8:20 AMWe're still testing with only 40 rows though, correct?
Not any more 😉
November 2, 2017 at 8:33 am
November 2, 2017 at 8:18 am
TryingToLearn - Thursday, November 2, 2017 5:22 AMThank you so very much...Exactly what i needed...
November 2, 2017 at 7:20 am
I am working for a company that still uses Sql 2008 R2 and so...
November 2, 2017 at 5:43 am
I did not realize I was in a comedy forum, lol.
Problem was solved by putting...
November 2, 2017 at 5:10 am
Interesting...I found similar results to Jason.
Here's another solution which so far appears to be quite fast:WITH Tally -- Chris2
AS (SELECT n = 0...
November 2, 2017 at 4:40 am
November 2, 2017 at 2:42 am
November 1, 2017 at 8:24 am
November 1, 2017 at 6:44 am
Is it possible to calculate pkDateKey and pkTimeKey from the date / time of your source tables, rather than using joins to Dim_Date / Dim_Time?
November 1, 2017 at 5:54 am
== John =============================================================
(39 rows affected)
Table 'Worktable'. Scan count 1, logical reads 2079, physical...
November 1, 2017 at 2:50 am
Viewing 15 posts - 511 through 525 (of 10,144 total)