drew.allen

Forum Replies Created

Viewing 15 posts - 1,996 through 2,010 (of 4,085 total)

RE: A Possible Alternative to SQL UNPIVOT

Jeff Moden - Monday, January 16, 2017 4:16 PM
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

#1923531
RE: Get All Participants and their unread message

Jeff Moden - Tuesday, January 17, 2017 4:40 PM
drew.allen - Tuesday, January 17, 2017 3:24 PM
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

January 18, 2017 at 8:52 am

#1923455
RE: Get All Participants and their unread message

sgmunson - Tuesday, January 17, 2017 3:09 PM
Any chance you can change the data model? It doesn't make any sense to have a...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

January 17, 2017 at 3:24 pm

#1923293
RE: NFL Total Access vs NFL Whiparound Coverage Live Stream 2017

Reported as spam.
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

January 17, 2017 at 2:38 pm

#1923287
RE: xXx: Return of Xander Cage (2017) Full - Movie

Reported as spam.
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

January 17, 2017 at 2:38 pm

#1923286
RE: Username increment by 1 if already exists in table

crmitchell - Tuesday, January 17, 2017 6:25 AM
MMartin1 - Wednesday, November 9, 2016 11:59 AM
What...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

January 17, 2017 at 2:22 pm

#1923281
RE: NFL Total Access vs NFL Whiparound Coverage Live Stream 2017

Reported as spam.
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

January 17, 2017 at 2:11 pm

#1923278
RE: Help converting a CURSOR in a function to FOR XML PATH

James Millar-305032 - Tuesday, January 17, 2017 11:32 AM
drew.allen - Tuesday, January 17, 2017 10:41 AM
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

January 17, 2017 at 11:38 am

#1923245
RE: Help converting a CURSOR in a function to FOR XML PATH

James Millar-305032 - Tuesday, January 17, 2017 10:29 AM
Matt Miller (#4) - Tuesday, January 17, 2017 10:17 AM
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

January 17, 2017 at 10:41 am

#1923228
RE: Adding an item count as another column to a function

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

#1923220
RE: t-sql 2012 pick all records that have the most current date

dianerstein 8713 - Friday, January 13, 2017 11:04 AM
Are 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

#1922705
RE: t-sql 2012 pick all records that have the most current date

dianerstein 8713 - Friday, January 13, 2017 9:05 AM
aaron.reese - Friday, January 13, 2017 7:34 AM
You...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

January 13, 2017 at 9:24 am

#1922615
RE: t-sql 2012 pick all records that have the most current date

dianerstein 8713 - Thursday, January 12, 2017 4:57 PM

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

#1922602
RE: How to select from 5 lines but only display 3

jonathanm 4432 - Thursday, January 12, 2017 12:15 PM
whenriksen - Thursday, January 12, 2017 12:12 PM
Post...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

January 12, 2017 at 1:21 pm

#1922416
RE: Get current or historic values to calculate balance or total based on data parameters using SQL 2012

sfletcher-933270 - Wednesday, January 11, 2017 10:19 PM
Dear Drew Further to the great solution you gave me I have a problem with some...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

January 12, 2017 at 10:03 am

#1922371

Viewing 15 posts - 1,996 through 2,010 (of 4,085 total)