Viewing 3 posts - 1 through 3 (of 3 total)
Very good article. Is it possible to share the definition of your date dimension table? Thanks.
October 18, 2016 at 5:04 pm
Keep up the good work!
SELECT
Id
,[1] As Note1
,[2] As Note2
,[3] As Note3
FROM
(
SELECT a.Id, a.Note
, RANK() OVER (PARTITION BY a.Id ORDER BY a.CreatedDate DESC, a.Id DESC) AS RankNum
FROM (SELECT Id, Note,...
December 5, 2013 at 9:30 am
Keep up the good work!
SELECT
Id
,[1] As Note1
,[2] As Note2
,[3]As Note3
FROM
(
SELECT a.Id, a.Note
, RANK() OVER (PARTITION BY a.Id ORDER BY a.CreatedDate DESC, a.Id DESC) AS RankNum
FROM (SELECT Id, Note,...
December 5, 2013 at 9:25 am
Viewing 3 posts - 1 through 3 (of 3 total)