Viewing 15 posts - 2,086 through 2,100 (of 2,643 total)
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
See my answer in your other post.
https://www.sqlservercentral.com/Forums/FindPost2004619.aspx
October 19, 2018 at 7:30 am
;WITH CTE AS
(
SELECT a.HoldingID,
a.IndicatorID,
a.[Status],
a.HistoryDateTime,
CAST(a.HistoryDateTime AS date) AS ActivityDate,
...
October 19, 2018 at 6:55 am
Viewing 15 posts - 2,086 through 2,100 (of 2,643 total)