Viewing 15 posts - 646 through 660 (of 4,086 total)
February 22, 2019 at 1:41 pm
My first question was whether ITEMS.UnitCost was character. If so, the coalesce would change the sort method from alphabetic to numeric, which could have a profound effect on the sort...
February 21, 2019 at 12:57 pm
February 21, 2019 at 12:48 pm
Brandie Tarvin - Thursday, February 21, 2019 10:48 AMWhat is the wingspan of an unladen swallow?
African or European?
Drew
February 21, 2019 at 12:38 pm
One is a proper subset of the other. Also, sub-queries are necessarily nested, so nobody uses the term nested.
Drew
February 21, 2019 at 12:30 pm
This is a fairly standard gaps and islands problem.
WITH gaps_and_islands AS
(
SELECT *, DATEADD(DAY, -ROW_NUMBER() OVER(PARTITION BY RecordID, Quantity ORDER BY dateID), dateID) AS...
February 21, 2019 at 12:15 pm
It never ceases to amaze me how many people think that the error message is irrelevant to resolving an error.
Drew
February 20, 2019 at 7:55 am
Multi-select parameters are passed to stored procedures as a comma-delimited list.
Drew
February 20, 2019 at 7:43 am
English is obviously not your first language. This post has nothing to do with the forum that it was posted in and your description of the problem is almost unintelligible.
February 19, 2019 at 10:19 am
Im thinking to use this method as I have more columns. Would like to...
February 19, 2019 at 8:28 am
February 15, 2019 at 9:02 am
February 14, 2019 at 2:08 pm
February 14, 2019 at 1:50 pm
You can't given the data provided. SQL tables represent sets, which are unordered. Your output requires an order that is not supported by your data. There is no way to...
February 14, 2019 at 12:36 pm
February 14, 2019 at 8:51 am
Viewing 15 posts - 646 through 660 (of 4,086 total)