Viewing 15 posts - 1 through 15 (of 582 total)
I remember reading about a new campus which intentionally did...
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
January 29, 2019 at 7:45 am
Exactly!
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
January 26, 2019 at 3:20 pm
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
March 25, 2018 at 3:21 pm
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
January 2, 2018 at 4:36 pm
bhupendra.baraiya (4/16/2015)
SELECT
CustomerID
, ...
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
June 3, 2016 at 9:31 am
samot-dwarf (4/20/2015)
Of course only if I don't need both (FIRST and LAST) because it...
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
June 3, 2016 at 9:27 am
amd.repetto (6/3/2016)
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
June 3, 2016 at 9:26 am
EDIT: This is an answer to the question about using LAST_VALUE(TotalDue) OVER(PARTITION BY CustomerID, ORDER BY CustomerID)
There are a couple. First, the performance could be bad. ROWS will generally perform...
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
June 3, 2016 at 9:22 am
Nice solution!
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
March 28, 2016 at 7:47 pm
Brian.Klinect (4/27/2015)
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
April 27, 2015 at 7:07 am
palotaiarpad (4/27/2015)
Link is already in my first post, but please: https://msdn.microsoft.com/en-us/library/ms187810.aspx
I would say BOL does have an error. Not the first time. You can definitely use the OVER...
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
April 27, 2015 at 7:03 am
palotaiarpad (4/26/2015)
Hmm. According to BOL, if OVER used with a SUM, then an order by clause is required...
Be sure to reread the question and try all three queries in...
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
April 27, 2015 at 6:59 am
ROWS and RANGE are only supported with Window Aggregates (for example, running totals) and FIRST_VALUE and LAST_VALUE.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
April 14, 2015 at 6:40 pm
In your test, are you just performing the update or are you also selecting the data?
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
April 4, 2015 at 1:22 pm
I'm not an expert on the Quirky Update, but don't you have to run the update which reads the entire table and then select the data after that which also...
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
April 4, 2015 at 12:42 pm
Viewing 15 posts - 1 through 15 (of 582 total)