drew.allen

Forum Replies Created

Viewing 15 posts - 976 through 990 (of 4,085 total)

RE: EXCEPT

jcelko212 32090 - Sunday, August 26, 2018 2:11 PM
VoldemarG - Friday, August 24, 2018 1:53 PM
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 27, 2018 at 10:08 am

#2003464
RE: Compute & Rollup

kd11 - Sunday, August 26, 2018 12:07 PM
This statement will produce: Select EmpID, Yr, sum(Sales)as Sales from Sales Group by EmpId, Yr With...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 27, 2018 at 9:43 am

#2003457
RE: Formatting date of birth using South African ID number

redbaron7 - Monday, August 27, 2018 4:46 AM
smthembu - Thursday, November 8, 2012 11:49 PM
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 27, 2018 at 9:19 am

#2003452
RE: Are the posted questions getting worse?

What con? I don't remember you mentioning a con anywhere?
I'm about to head to Baltimore for a weekend of board games. I'm probably going to stay...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 24, 2018 at 1:20 pm

#2003275
RE: Proc Fails when run in SSIS but runs fine in SSMS

I'm also not sure why you are using a WHILE loop in the first place. You should be able to do this without any loops.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 24, 2018 at 12:46 pm

#2003270
RE: Best practice question on using a primary key field opposed to using a foreign key field

chocthree - Friday, August 24, 2018 9:12 AM
Ok. Thanks.
I don't have visual on the original SQL db so I can only presume...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 24, 2018 at 12:40 pm

#2003269
RE: Best practice question on using a primary key field opposed to using a foreign key field

chocthree - Friday, August 24, 2018 8:31 AM
Hi,
Let's keep this simple (for my sake) and say we have two tables.
Table Employee contains:
e.EmployeeID ...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 24, 2018 at 8:49 am

#2003216
RE: Are the posted questions getting worse?

How can you "forget" that you posted a question on a topic two weeks ago and still be able to function in a job that requires holding a lot of...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 24, 2018 at 8:35 am

#2003209
RE: Executing same SQL code twice

NikosV - Friday, August 24, 2018 7:51 AM
I totally forgot about that. It was for another report.
Good memory Drew. That's why the...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 24, 2018 at 8:28 am

#2003205
RE: Calculate percent change between columns

NikosV - Friday, August 24, 2018 2:25 AM
I have this portion of code

SELECT
GenPar.ParameterValue AS ClaimType,
Submitted = COUNT(CASE CurrentStatus...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 24, 2018 at 8:06 am

#2003200
RE: Order of Clustered Index

Jonathan AC Roberts - Friday, August 24, 2018 5:20 AM
Mike Scalise - Thursday, August 23, 2018 7:08...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 24, 2018 at 8:01 am

#2003199
RE: Order of Clustered Index

Mike Scalise - Thursday, August 23, 2018 7:08 PM
Let's say, hypothetically, I have a table with three columns--LastName, FirstName, MiddleName and I...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 24, 2018 at 7:59 am

#2003198
RE: Executing same SQL code twice

You posted the EXACT SAME QUESTION two weeks ago.
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 24, 2018 at 7:47 am

#2003196
RE: Retrieving Values when using NOT LIKE

cjeans - Friday, August 24, 2018 5:30 AM
Hi,
I am trying to filter values in my database and am currently looking to provide...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 24, 2018 at 7:36 am

#2003194
RE: SQL INSERT that retrieves data from multiple rows that are under the same ID

Markk1244 - Wednesday, August 22, 2018 5:02 PM
andycadley - Wednesday, August 22, 2018 12:25 AM
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 23, 2018 at 8:09 am

#2003057

Viewing 15 posts - 976 through 990 (of 4,085 total)