Viewing 15 posts - 1,996 through 2,010 (of 4,085 total)
For those interested in how to unpivot a multi-row table, you do need some form...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 18, 2017 at 1:04 pm
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 18, 2017 at 8:52 am
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 17, 2017 at 3:24 pm
Reported as spam.
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 17, 2017 at 2:38 pm
Reported as spam.
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 17, 2017 at 2:38 pm
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 17, 2017 at 2:22 pm
Reported as spam.
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 17, 2017 at 2:11 pm
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 17, 2017 at 11:38 am
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 17, 2017 at 10:41 am
Just add
, cnt = COUNT(*) OVER()
You need the OVER clause, because there is no group by, but you don't have to have any partition or...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 17, 2017 at 10:12 am
dianerstein 8713 - Friday, January 13, 2017 11:04 AMAre you saying there is no solution to this problem?
No, I'm saying that it's not...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 13, 2017 at 2:24 pm
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 13, 2017 at 9:24 am
SELECT stulink,stringtemplate,updateddate=MAX(updateddate)
FROM atlltr
WHERE (atlltr.language IS NOT NULL)
AND (atlltr.stringtemplate IS NOT...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 13, 2017 at 9:08 am
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 12, 2017 at 1:21 pm
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 12, 2017 at 10:03 am
Viewing 15 posts - 1,996 through 2,010 (of 4,085 total)