drew.allen

Forum Replies Created

Viewing 15 posts - 1,036 through 1,050 (of 4,085 total)

RE: Parsing data

I've updated the staging table definition. I used a temp table here, but you should use your regular table.
CREATE TABLE #table(
id INT IDENTITY,
...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 10, 2018 at 8:59 am

#2001250
RE: Table entry appears multiple times

NikosV - Friday, August 10, 2018 7:54 AM
No problem Drew. After some fiddling I saw that too but couldn.t make it work.
Any...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 10, 2018 at 7:57 am

#2001235
RE: Parsing data

There is a third option if you can add an identity column to your staging table. Is that possible?
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 10, 2018 at 7:27 am

#2001225
RE: Table entry appears multiple times

NikosV - Thursday, August 9, 2018 11:46 PM
I've seen ROW_NUMBER and I'm pretty sure this is the...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 10, 2018 at 7:22 am

#2001224
RE: Color alternate column group in matrix

Please don't post in multiple forums. It fragments the discussion.
Please post all responses here.
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 9, 2018 at 2:23 pm

#2001141
RE: Splitting a comma separated string in one field and populate several fields

Eirikur Eiriksson - Wednesday, August 8, 2018 11:36 PM
Since you are posting on the SQL Server 2012 forum, you may want to...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 9, 2018 at 10:22 am

#2001080
RE: How to GROUP BY in one condition and simply SELECT in another in one go?

It's hard to tell on such a small sample, but using GROUPING SETS might actually perform better.
WITH payments AS
(SELECT 100.00 AS Ex_VAT,
20.00 AS...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 9, 2018 at 10:01 am

#2001077
RE: Converting decimals to HH:MM:SS

Ken McKelvey - Thursday, August 9, 2018 7:16 AM

DECLARE @t decimal(10,2) = 3.25;
SELECT CONVERT(char(8), DATEADD(second, @t%1 * 60, DATEADD(minute, @t, 0)),...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 9, 2018 at 7:29 am

#2001000
RE: Count the amount of times values appear in the database

paul 69259 - Wednesday, August 8, 2018 9:19 AM
Hmmm, it doesn't seem to like me using the square brackets when I'm doing...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 8, 2018 at 2:44 pm

#2000914
RE: tSQLt AssertEqualsString

leeholden - Wednesday, August 8, 2018 1:18 PM
The collation is Latin1_General_CI_AS, but I've created a function that camel cases the input, so...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 8, 2018 at 2:38 pm

#2000910
RE: tSQLt AssertEqualsString

Use a case sensitive collation in your test. It's simple enough that you really don't need a stored procedure.
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 8, 2018 at 8:57 am

#2000830

RE: Execute same SELECT with a different condition

I think that a cross tab might perform better here, especially since you're already doing aggregates on the data. I used a CROSS APPLY instead of writing essentially the same...

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

August 8, 2018 at 8:47 am

#2000826