Forum Replies Created

Viewing 15 posts - 1,336 through 1,350 (of 26,488 total)

  • RE: Starting a CTE

    Sean Lange - Thursday, July 12, 2018 7:15 AM

    Was helping somebody just yesterday on another site and they couldn't for the life...

  • RE: Getting Max date from rows

    JaybeeSQL - Wednesday, July 11, 2018 5:24 PM

    It's  all good I cracked  the joins, just had to repeat the joins twice as...

  • RE: Getting Max date from rows

    JaybeeSQL - Wednesday, July 11, 2018 5:03 PM

    Thanks bud, that code works stand-alone, now I'm trying to do a couple of joins...

  • RE: Getting Max date from rows

    JaybeeSQL - Wednesday, July 11, 2018 4:08 PM

    Hi all,
    I'm trying to get the latest date for every distinct value in a column: 
    CREATE...

  • RE: Who Likes NULL?

    Dennis Q Miller - Wednesday, July 11, 2018 10:57 AM

    I don't know why StartDate would be NULL, but it could be. ...

  • RE: Licence

    For the best answer to this, contact the vendor that sold you SQL Server or Microsoft.  Any answer you may get here is simply opinion and worth what you pay...

  • RE: Who Likes NULL?

    Dennis Q Miller - Wednesday, July 11, 2018 9:12 AM

    Jeff Moden - Wednesday, July 11, 2018 8:28...

  • RE: Who Likes NULL?

    Dennis Q Miller - Wednesday, July 11, 2018 8:23 AM

    You are illustrating how NULL is prone to coding error.  The first...

  • RE: Ensuring Each Client has a Full Set of Key-Value Pairs

    EAV design has a place.  It is a tool that can be used for good or evil.  Microsoft uses in their compliance system for all the products they offer.  I...

  • RE: SQL query with Json certain key info

    Siten0308 - Tuesday, July 10, 2018 3:09 PM

    awesome big thanks Lynn,

    one last thing, i am really sorry, is there a way to...

  • RE: script

    Okay, let us just throw out a wild a$$ guess:

    declare @DeletedRec table (id int);

    insert into A.PP_OLD
    output inserted.id into @DeletedRec(id)
    select * from A.PP where isactive...

  • RE: SQL query with Json certain key info

    Siten0308 - Tuesday, July 10, 2018 2:20 PM

    Hey Guys,

    I have this example below:

    CREATE TABLE #Test
    (
    ID int,
    Personname varchar(16),
    JsonColumn varchar(256)
    )

    insert into #Test(ID,Personname,JsonColumn)
    values(1,'bob','[{"TableName:Orders,"ID":10},{"TableName":"PurchaseOrders","ID":15}]')

    What...

  • RE: Log activity in relation to simple recovery

    DataAnalyst011 - Tuesday, July 10, 2018 12:46 PM

    I know this is basic, but I'm having trouble understanding the MSDN articles and forum...

  • RE: I need to extract the 5 char length substring between dashes

    ScottPletcher - Tuesday, July 10, 2018 10:49 AM


    SELECT *,
         CASE WHEN start_of_value = 1 THEN ''
         ELSE SUBSTRING(CI_NUM,...

  • RE: how do i find a specific status, and only that status

    So am I wrong to provide other alternatives?  Is so I will just go away.

Viewing 15 posts - 1,336 through 1,350 (of 26,488 total)