Viewing 15 posts - 2,086 through 2,100 (of 2,645 total)
;with myTable (StartDate ,EndDate) AS That semicolon 'initiator' is there just to...
October 22, 2018 at 5:07 pm
October 22, 2018 at 4:54 pm
ColA ColB RowNumber
100 X ...
October 22, 2018 at 2:06 pm
October 22, 2018 at 12:11 pm
I have following sample data set:
SaleID SaleMarkdown StartDate(yyyymmdd) EndDate(yyyymmdd) SaleInPreviousYear previousyearsaleID
1 20% ...
October 22, 2018 at 10:57 am
October 22, 2018 at 10:19 am
October 22, 2018 at 10:06 am
Problem
Find the name of...
October 22, 2018 at 7:13 am
October 21, 2018 at 8:53 am
The tables are first sorted on A and B (this is not by the ORDER BY in the query but an internal sort that's part of the join).
Then...
October 21, 2018 at 4:54 am
Some basic standards I'd like to see organisations adopt is to choose conventions to apply across all their projects:
Table Names - singular or plural e.g. Customer or Customers.
October 20, 2018 at 2:23 pm
October 20, 2018 at 12:36 pm
October 19, 2018 at 3:38 pm
Viewing 15 posts - 2,086 through 2,100 (of 2,645 total)