drew.allen

Forum Replies Created

Viewing 15 posts - 766 through 780 (of 4,085 total)

RE: Help Writing SQL Query to extract information from table

carlton 84646 - Thursday, December 13, 2018 6:58 AM
Hello Community,
I'm pretty new to this forum and SQL query.
Can some please take a...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

December 13, 2018 at 10:32 am

#2016247
RE: Stumped trying to shred XML data into table rows

webrunner - Wednesday, December 12, 2018 12:31 PM
Thanks, everyone, for the feedback.
Regarding the questions/issues:
Can you please post an example that fails...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

December 12, 2018 at 2:03 pm

#2016154
RE: Stumped trying to shred XML data into table rows

webrunner - Wednesday, December 12, 2018 11:11 AM
Eirikur Eiriksson - Wednesday, December 12, 2018 1:39 AM
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

December 12, 2018 at 11:34 am

#2016140
RE: Pivot from row-level without loosing the ColNames

This is obviously a continuation of your previous thread. You should just learn how to shred XML documents correctly in the first place instead of trying to cobble...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

December 12, 2018 at 11:24 am

#2016137
RE: Get all Attributes from this XML

info 58414 - Wednesday, December 12, 2018 8:24 AM
Great Mark! Only view Lines for this big Result 😉
do you still have a...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

December 12, 2018 at 9:33 am

#2016111
RE: Stumped trying to shred XML data into table rows

webrunner - Tuesday, December 11, 2018 2:23 PM
Here is my problem:
1. When I select the XmlCol as is, I get what...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

December 11, 2018 at 3:15 pm

#2016036
RE: Trouble grouping data series when a group crosses a date line (in some cases) and when a group shows up again further down in the sequence.

WITH CTE AS (
    SELECT
        CASE WHEN LAG(serial_number, 1) OVER( ORDER BY trans_date, trans_time) = serial_number THEN 0 ELSE 1 END AS is_start,
        index_num,
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

December 11, 2018 at 2:58 pm

#2016032
RE: Case when inside of partition by?

Data Cruncher - Friday, December 7, 2018 4:42 AM
Thanks Drew, actually your solution works well for the given dataset, but it assumes...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

December 7, 2018 at 7:14 am

#2015753
RE: Using SQL to fill DataTable

kennyhuang0108 - Thursday, December 6, 2018 12:08 PM
Yes Sir.
The back end is Oracle. Is there anyway i can make below statement...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

December 6, 2018 at 12:44 pm

#2015696
RE: Case when inside of partition by?

Data Cruncher - Wednesday, December 5, 2018 9:35 AM
Hi smugson,
I'm sorry but it doesn't do the trick:

CREATE TABLE #TAB1(
ID...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

December 6, 2018 at 9:19 am

#2015684
RE: For XML Explicit Column order

Yes, but it's MUCH, MUCH, MUCH, MUCH easier to use FOR XML PATH. Do you really need to use FOR XML EXPLICIT?
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

December 3, 2018 at 4:06 pm

#2015386
RE: Pseudo code help

This is a variation on the Set Cover Problem and has been proven to be NP-Complete.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

December 3, 2018 at 3:28 pm

#2015384
RE: Inserting a new row into a table using a cursor

jcelko212 32090 - Wednesday, November 28, 2018 8:26 AM
Most of the duplicate Social Security numbers. We've got are from illegals stealing...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

November 28, 2018 at 11:24 am

#2014861
RE: String split help

Jonathan AC Roberts - Wednesday, November 28, 2018 9:57 AM
Just use this and replace myTable with your table name.
SELECT...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

November 28, 2018 at 10:12 am

#2014839
RE: View that sums payments by person over a period of years

briancampbellmcad - Tuesday, November 27, 2018 1:45 PM
I am trying to create a view that sums the [amount] by [peopleId] in...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

November 27, 2018 at 2:24 pm

#2014722

Viewing 15 posts - 766 through 780 (of 4,085 total)