Forum Replies Created

Viewing 15 posts - 31 through 45 (of 54 total)

  • RE: Healthcare Data Warehouse - Starting new - small scale

    Thanks, xsevensinzx, and others.

    I think as my first step I...

    -Mark
    MSSQL 2019 Standard, Azure Hosted. Techie/Sysadmin by trade; Three years as a "DBA" now.

    August 31, 2018 at 8:21 am

    #2004138

  • RE: Healthcare Data Warehouse - Starting new - small scale

    drew.allen - Tuesday, August 28, 2018 3:03 PM

    usererror - Tuesday, August 28, 2018 10:48 AM

    -Mark
    MSSQL 2019 Standard, Azure Hosted. Techie/Sysadmin by trade; Three years as a "DBA" now.

    August 29, 2018 at 9:48 am

    #2003833

  • RE: Healthcare Data Warehouse - Starting new - small scale

    jonathan.crawford - Tuesday, August 28, 2018 11:04 AM

    ...I actually started laughing at the thought of the different insurers and...

    -Mark
    MSSQL 2019 Standard, Azure Hosted. Techie/Sysadmin by trade; Three years as a "DBA" now.

    August 28, 2018 at 1:18 pm

    #2003705

  • RE: Healthcare Data Warehouse - Starting new - small scale

    Drew,

    I should have added that each source set of data has a different set of columns. They do not have any kind of primary key already.

    -Mark
    MSSQL 2019 Standard, Azure Hosted. Techie/Sysadmin by trade; Three years as a "DBA" now.

    August 28, 2018 at 10:48 am

    #2003655

  • RE: LEFT JOIN with CASE subquery ?

    drew.allen - Tuesday, July 24, 2018 8:25 AM

    INS4_LIMITED is the name he gave to the result set returned by the CTE...

    -Mark
    MSSQL 2019 Standard, Azure Hosted. Techie/Sysadmin by trade; Three years as a "DBA" now.

    July 24, 2018 at 9:19 am

    #1998812

  • RE: LEFT JOIN with CASE subquery ?

    Steve,
    This may be a silly question, but what is the significance of '_LIMITED' that you appended to the original table name "INS4" so it was 'INS4_LIMITED' on the subquery...

    -Mark
    MSSQL 2019 Standard, Azure Hosted. Techie/Sysadmin by trade; Three years as a "DBA" now.

    July 24, 2018 at 7:31 am

    #1998777

  • RE: LEFT JOIN with CASE subquery ?

    Thanks, now I know what CTE stands for when I see it here. Also, CTE is apparently not covered in my beginners guide to SQL. I'm only 3/4 of the...

    -Mark
    MSSQL 2019 Standard, Azure Hosted. Techie/Sysadmin by trade; Three years as a "DBA" now.

    July 19, 2018 at 12:58 pm

    #1998274

  • RE: LEFT JOIN with CASE subquery ?

    sgmunson - Thank you, that did exactly what I was looking for. I would have never gotten that on my own. I am going to see if I can expand on...

    -Mark
    MSSQL 2019 Standard, Azure Hosted. Techie/Sysadmin by trade; Three years as a "DBA" now.

    July 19, 2018 at 12:01 pm

    #1998259

  • RE: LEFT JOIN with CASE subquery ?

    Lynn Pettis - Wednesday, July 18, 2018 1:51 PM

    First off, the value of INS4.Modifier cannot be both 26 and NULL in...

    -Mark
    MSSQL 2019 Standard, Azure Hosted. Techie/Sysadmin by trade; Three years as a "DBA" now.

    July 19, 2018 at 5:35 am

    #1998164

  • RE: LEFT JOIN with CASE subquery ?

    Phil Parkin - Wednesday, July 18, 2018 11:55 AM

    Please elaborate a little: in the case where INS4.Modifier <> '26', what do you want...

    -Mark
    MSSQL 2019 Standard, Azure Hosted. Techie/Sysadmin by trade; Three years as a "DBA" now.

    July 18, 2018 at 1:25 pm

    #1998092

  • RE: Count(*) with LIKE

    @jackie Lowery - At this point, I don't know the OVER command, yet.  My full query with the updated CASE statements is below.

    @Drew Allen - Also I am not...

    -Mark
    MSSQL 2019 Standard, Azure Hosted. Techie/Sysadmin by trade; Three years as a "DBA" now.

    February 15, 2018 at 8:15 am

    #1979918

  • RE: Count(*) with LIKE

    gvoshol 73146 - Thursday, February 15, 2018 5:20 AM

    You need to reverse the WHEN's in your last sum.  Currently the first...

    -Mark
    MSSQL 2019 Standard, Azure Hosted. Techie/Sysadmin by trade; Three years as a "DBA" now.

    February 15, 2018 at 6:55 am

    #1979891

  • RE: Count(*) with LIKE

    drew.allen - Wednesday, February 14, 2018 10:18 AM

    You need to replace your COUNTIF with a COUNT(CASE .... WHEN ...) 

    For example,  COUNT(CASE WHEN...

    -Mark
    MSSQL 2019 Standard, Azure Hosted. Techie/Sysadmin by trade; Three years as a "DBA" now.

    February 14, 2018 at 11:55 am

    #1979798

  • RE: Extract Text around comma and space into other columns

    sestell1 - Tuesday, February 6, 2018 1:52 PM

    There could be spaces in the last name as well...  combined names (Smith, Jim...

    -Mark
    MSSQL 2019 Standard, Azure Hosted. Techie/Sysadmin by trade; Three years as a "DBA" now.

    February 7, 2018 at 7:16 am

    #1978871

  • RE: Extract Text around comma and space into other columns

    drew.allen - Tuesday, February 6, 2018 1:02 PM

    And what happens when someone has a first name that includes a space?  "Jackson, La...

    -Mark
    MSSQL 2019 Standard, Azure Hosted. Techie/Sysadmin by trade; Three years as a "DBA" now.

    February 6, 2018 at 1:11 pm

    #1978767

Viewing 15 posts - 31 through 45 (of 54 total)