Forum Replies Created

Viewing 15 posts - 646 through 660 (of 911 total)

  • RE: Lock on SQL data rows

    Thom A - Friday, June 22, 2018 3:53 PM

    jcelko212 32090 - Friday, June 22, 2018 3:08 PM

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    June 24, 2018 at 11:27 am

    #1995076

  • RE: Find the difference between 2 values

    NewBornDBA2017 - Friday, June 22, 2018 1:27 PM

    Experts, I am wondering if I can get some help with what I am trying...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    June 24, 2018 at 11:21 am

    #1995075

  • RE: Insert a duplicate copy of any record that meets certain criteria

    samn265 - Saturday, June 23, 2018 12:06 PM

    >> Sorry for this dumb question but I am very new to SQL. Could someone...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    June 24, 2018 at 11:12 am

    #1995074

  • RE: Lock on SQL data rows

    Lynn Pettis - Friday, June 22, 2018 1:16 PM

    Thom A actually provided a possible solution, and it has to be implemented in...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    June 22, 2018 at 3:08 pm

    #1995029

  • RE: Lock on SQL data rows

    sgmunson - Wednesday, June 20, 2018 3:12 PM

    jcelko212 32090 - Wednesday, June 20, 2018 1:12 PM

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    June 22, 2018 at 12:26 pm

    #1995003

  • RE: Lock on SQL data rows

    KGNH - Wednesday, June 20, 2018 5:53 AM

    >> All the users can see the data but only one person can work at...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    June 20, 2018 at 1:12 pm

    #1994712

  • RE: Joining a large table to itself....better ideas?

    tacy.highland - Monday, June 18, 2018 10:44 AM

    Hello all,
    I'm creating a view to use for future queries to make things easier.  Essentially...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    June 19, 2018 at 8:25 am

    #1994458

  • RE: Foreign Key Constraints

    mjdemaris - Friday, June 15, 2018 8:39 PM

    >> I am using SQL Server Express 2017, and I have a table with two...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    June 18, 2018 at 9:33 am

    #1994311

  • RE: Count of values in column

    Ronnie65 - Thursday, June 14, 2018 10:37 PM

    Why did you fail to post DDL? I guess we'll just have to do it...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    June 15, 2018 at 3:27 pm

    #1994190

  • RE: store a query instead of repeating it

    sqlfriends - Wednesday, June 13, 2018 5:02 PM

    If I have a complicated SQL query with joins and unions and with statement, and...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    June 15, 2018 at 12:07 pm

    #1994171

  • RE: Compare comma separated values

    Mauricio_ - Saturday, June 9, 2018 12:37 PM

    >> I don't know the English term for this but, in Spanish, I called...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    June 11, 2018 at 12:05 pm

    #1993594

  • RE: T-SQL help needed to eliminate duplicates from table

    Virtually everything here is wrong. SQL Server has had table constructors in it's insertion statement for several years now; so there is no need to use the old Sybase SELECT-UNION...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    June 11, 2018 at 9:23 am

    #1993562

  • RE: Compare comma separated values

    Mauricio_ - Saturday, June 9, 2018 8:21 AM

    Hi Joe,
        the values in the column, those comma separated, are as a result...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    June 9, 2018 at 9:54 am

    #1993485

  • RE: Compare comma separated values

    Mauricio_ - Thursday, June 7, 2018 3:49 AM

    Hi,
       let's say I have this:
    DROP TABLE IF EXISTS #CSV
    CREATE TABLE #CSV
    (ID INT NOT...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    June 9, 2018 at 7:37 am

    #1993478

  • RE: YTD running balance including missing months

    Jeff Moden - Tuesday, May 29, 2018 3:55 PM

    Lynn Pettis - Tuesday, May 29, 2018 3:37 PM

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    May 31, 2018 at 1:10 pm

    #1992541

Viewing 15 posts - 646 through 660 (of 911 total)