Forum Replies Created

Viewing 15 posts - 1,291 through 1,305 (of 4,085 total)

  • RE: Selecting item from xml where multiples can exist.

    gzt4gs - Friday, February 2, 2018 2:03 AM

    drew.allen - Thursday, February 1, 2018 8:34 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 2, 2018 at 12:33 pm

    #1978409

  • RE: Two tables that they have foreign keys pointing to each other

    Joe Torre - Thursday, February 1, 2018 3:16 PM

    Try doing both in a single transaction:

    begin tran
       delete tbl1 where ...
       delete tbl2...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 1, 2018 at 3:18 pm

    #1978276

  • RE: Sql Max query

    DD-533246 - Thursday, February 1, 2018 12:52 PM

    SQL server 2012 : 
    Need help with building query for max.
    Table A has a record Ex:...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 1, 2018 at 3:13 pm

    #1978273

  • RE: Format of result

    mikeaspnet - Thursday, February 1, 2018 12:53 PM

    That was not my question.
    i'm asking how can i achieve this in T-sql 🙂

    Reason i...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 1, 2018 at 2:34 pm

    #1978271

  • RE: Format of result

    mikeaspnet - Thursday, February 1, 2018 11:49 AM

    i want clear.
    it simple.
    i want the head category followed be the sub categories

    headcat
    subcat 
    subcat 
    subcat 
    subcat 
    headcat
    subcat 
    subcat 
    subcat 
    headcat

    Yes, it's simple. ...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 1, 2018 at 11:57 am

    #1978253

  • RE: Selecting item from xml where multiples can exist.

    If you want a specific section, use the path that gives you that specific section.


    SELECT Title = Title.c.value('@Value', 'nVarChar(max)')
    FROM Appraisals
    CROSS APPLY aAppraisal.nodes('/cBusinessAppraisal/ProductsSummaryItems/CollectionItems/cUnitSummaryData/Children/CollectionItems/cUnitSummaryData/Title') Title(c)

    Also, does...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 1, 2018 at 8:34 am

    #1978212

  • RE: Format of result

    mikeaspnet - Tuesday, January 30, 2018 3:40 PM

    Hi all, im trying to do something, but have no idea how to acief this.

    Here...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 1, 2018 at 7:43 am

    #1978188

  • RE: Need help with simple IF THEN in WHERE CLAUSE

    karlw - Tuesday, January 30, 2018 9:07 AM

    Drew,
    I ultimately ended up with the following for the CASE statement part:

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 30, 2018 at 12:53 pm

    #1977939

  • RE: Calendar table

    K. Brian Kelley - Tuesday, January 30, 2018 11:40 AM

    drew.allen - Tuesday, January 30, 2018 11:37 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 30, 2018 at 12:16 pm

    #1977932

  • RE: Calendar table

    K. Brian Kelley - Tuesday, January 30, 2018 11:21 AM

    Another idea for a PK is a composite key (two columns) consisting of...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 30, 2018 at 11:37 am

    #1977922

  • RE: Looking to sort two queries by Date, Time

    chef423 - Tuesday, January 30, 2018 9:46 AM

    Steve Jones - SSC Editor - Tuesday, January 30, 2018...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 30, 2018 at 11:24 am

    #1977918

  • RE: Show data based on MAX Action date - end of the month

    jaggy99 - Tuesday, January 30, 2018 12:17 AM

    Thanks Sean that worked. What about the below approach?

    ;with dates(Month_End) as (select cast('2014-01-01'...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 30, 2018 at 10:07 am

    #1977902

  • RE: Looking to sort two queries by Date, Time

    And there is only one sort on the entire UNION.

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 30, 2018 at 9:12 am

    #1977881

  • RE: Need help with simple IF THEN in WHERE CLAUSE

    It's missing the WHEN right after the CASE.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 29, 2018 at 3:06 pm

    #1977788

  • RE: Need help with simple IF THEN in WHERE CLAUSE

    karlw - Monday, January 29, 2018 2:12 PM

    First, thank you for reading this.
    Next, I'm using SQL Server Management Studio 2012.
    Lastly, I'm very...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 29, 2018 at 2:37 pm

    #1977778

Viewing 15 posts - 1,291 through 1,305 (of 4,085 total)