Viewing 15 posts - 1,426 through 1,440 (of 4,085 total)
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 19, 2017 at 2:28 pm
I was thinking that for most purposes, an explicit transaction would suffice.
BEGIN TRAN
DELETE statement
INSERT statement
COMMIT TRAN
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 19, 2017 at 10:27 am
I dumped the CASE data into a temp...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 19, 2017 at 10:25 am
You've been around long enough to know to provide sample data and expected results.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 19, 2017 at 10:17 am
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 19, 2017 at 10:12 am
What I meant was that using UNION ALL could result in duplicate rows which...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 19, 2017 at 9:34 am
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 19, 2017 at 9:26 am
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 19, 2017 at 9:23 am
Isn't it as simple as a CASE expression?
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 19, 2017 at 9:16 am
First, when working with dates, store them as dates. Part of the reason that you're having problems is...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 18, 2017 at 1:19 pm
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 18, 2017 at 9:30 am
You just use both columns in your PARTITION BY clause.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 18, 2017 at 7:57 am
Joe Torre - Friday, December 15, 2017 1:07 PMtake a look at this
This article depends on data where the records...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 15, 2017 at 1:40 pm
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 15, 2017 at 1:18 pm
It requires two different ROW_NUMBER()s.
;
WITH StatusGroups AS
(
SELECT *
, Grp = ROW_NUMBER() OVER(PARTITION BY EID ORDER BY StartDate, Stat) - ROW_NUMBER() OVER(PARTITION BY EID,...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 15, 2017 at 12:37 pm
Viewing 15 posts - 1,426 through 1,440 (of 4,085 total)