drew.allen

Forum Replies Created

Viewing 15 posts - 841 through 855 (of 4,085 total)

RE: Use CTE/WITH to concatenate TWICE.

ben.brugman - Tuesday, October 16, 2018 2:20 PM
2.
Although the data is randomly generated, the end results I had were all very...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

October 16, 2018 at 2:47 pm

#2009964
RE: Use CTE/WITH to concatenate TWICE.

ben.brugman - Tuesday, October 16, 2018 2:17 AM
drew.allen - Monday, October 15, 2018 2:07 PM
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

October 16, 2018 at 12:50 pm

#2009940
RE: Are the posted questions getting worse?

Jeff Moden - Tuesday, October 16, 2018 9:02 AM
drew.allen - Tuesday, October 16, 2018 8:34 AM
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

October 16, 2018 at 10:00 am

#2009909
RE: Are the posted questions getting worse?

Thom A - Tuesday, October 16, 2018 3:25 AM
Maybe I "missed" them for awhile, but is it me or are the Chinese...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

October 16, 2018 at 8:34 am

#2009882
RE: Convert int field into date and format issue

daniness - Monday, October 15, 2018 2:49 PM
Thanks for your input as well, Jeffrey Williams. I do have a question...does anyone know...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

October 15, 2018 at 3:05 pm

#2009757
RE: Use CTE/WITH to concatenate TWICE.

It's not pretty, and it may not be efficient, but this does produce something CLOSE to what you are expecting.

; WITH CTE AS
(
...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

October 15, 2018 at 2:07 pm

#2009738
RE: Is this query correct ?

spectra - Monday, October 15, 2018 7:31 AM
Jonathan AC Roberts - Monday, October 15, 2018 6:51 AM
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

October 15, 2018 at 7:44 am

#2009605
RE: What are some really dumb things you could write in a SQL Query

jasona.work - Friday, October 12, 2018 11:53 AM
usererror - Friday, October 12, 2018 11:26 AM
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

October 12, 2018 at 12:23 pm

#2009425
RE: date timeframe

What have you tried?
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

October 12, 2018 at 12:05 pm

#2009424
RE: Are the posted questions getting worse?

ChrisM@Work - Friday, October 12, 2018 4:29 AM
I think the secret view guy is just bored.
I gave up on that thread...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

October 12, 2018 at 9:39 am

#2009400
RE: SQL Server Merge Command On Match update and insert together

Use the OUTPUT clause of the MERGE to insert the new record.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

October 12, 2018 at 9:21 am

#2009391
RE: Showing all records that appear more than once

ScottPletcher - Wednesday, October 10, 2018 12:56 PM
drew.allen - Wednesday, October 10, 2018 12:02 PM
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

October 11, 2018 at 8:26 am

#2009135
RE: Showing all records that appear more than once

ScottPletcher - Wednesday, October 10, 2018 12:56 PM
drew.allen - Wednesday, October 10, 2018 12:02 PM
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

October 11, 2018 at 8:18 am

#2009129
RE: Options to assign a dynamic content to XMLNAMESPACES area

Why don't you just have two separate namespaces? The whole reason for introducing namespaces in the first place was so that you could distinguish between similar elements from two different...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

October 11, 2018 at 8:12 am

#2009127
RE: What are some really dumb things you could write in a SQL Query

Hugo Kornelis - Thursday, October 11, 2018 7:16 AM
Encountered way too often in code at my current customer:
IF (SELECT COUNT(*)...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

October 11, 2018 at 7:49 am

#2009113

Viewing 15 posts - 841 through 855 (of 4,085 total)