Forum Replies Created

Viewing 15 posts - 796 through 810 (of 911 total)

  • RE: Calculating averages

    SQLPain - Monday, August 28, 2017 5:27 PM

    I have the following sql code that gets me Total no of days taken for...

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

    August 28, 2017 at 7:22 pm

    #1957174

  • RE: Left outer join make duplicate column name

    adonetok - Wednesday, August 23, 2017 1:55 PM

    Based on almost 40 years with RDBMS, I smelled something really bad here. First of...

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

    August 28, 2017 at 7:09 pm

    #1957173

  • RE: Using Dynamic Query in a Transact SQL Select

    imanalimi - Tuesday, August 22, 2017 8:49 PM

    Hi Guys,
    I am trying to calculate formula  using SQL Server 2016.
    How can I get the...

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

    August 23, 2017 at 4:09 pm

    #1956508

  • RE: Group by select

    Aditya-313343 - Tuesday, August 15, 2017 6:36 PM

    >> I need a help in writing a query. <<

    No you need help understanding how...

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

    August 20, 2017 at 3:17 pm

    #1955924

  • RE: Exclude weekends

    PSB - Thursday, August 10, 2017 9:11 AM

    Are those 2 day or 3 day or 4 day weekends?...

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

    August 19, 2017 at 10:29 pm

    #1955908

  • RE: Case When issue

    d13rosew - Wednesday, August 16, 2017 1:59 PM

    Your first problem is that case is not a statement...

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

    August 19, 2017 at 10:17 pm

    #1955907

  • RE: Select Statement Help

    reggiete - Friday, August 18, 2017 2:00 PM

     >> Below is a table I have with data. I am wanting to group the...

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

    August 19, 2017 at 9:34 pm

    #1955905

  • RE: Update same row twice

    >> I know this is illegal with a MERGE, but is there a way to update the same row twice with a regular UPDATE statement? <<

    The short answer...

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

    August 17, 2017 at 11:34 am

    #1955694

  • RE: Case Statement Help

    koti.raavi - Sunday, July 23, 2017 9:04 AM

    SQL has a CASE expression, not CASE Statement!

    You really need to read a book...

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

    July 24, 2017 at 9:00 am

    #1952382

  • RE: update column based on max date for each employee

    Shanmuga Raj - Wednesday, July 19, 2017 4:06 AM

    Kinl provide the update query for update column TeamId based on max date for...

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

    July 20, 2017 at 9:50 am

    #1951890

  • RE: Inner/Outer Join

    kd11 - Wednesday, July 12, 2017 2:56 PM

    First of all, I hope you know that columns and fields are totally different. In...

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

    July 13, 2017 at 2:24 pm

    #1950843

  • RE: Multiple Values for Single Parameter in User Defined Function

    sgmunson - Wednesday, July 5, 2017 1:48 PM

    Joe,

    Why is it that you insist on unnecessary rules when highly performant alternatives are readily...

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

    July 5, 2017 at 5:32 pm

    #1949592

  • RE: SQL Streaks

    michelle.mabbs - Tuesday, July 4, 2017 6:56 AM

    This looks so fundamentally wrong that it bothers me. We don’t...

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

    July 5, 2017 at 2:01 pm

    #1949570

  • RE: Multiple Values for Single Parameter in User Defined Function

    Luis Cazares - Friday, May 26, 2017 9:41 AM

    jcelko212 32090 - Friday, May 26, 2017 9:33 AM

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

    July 5, 2017 at 1:12 pm

    #1949561

  • RE: Using Cursors And Fetch

    vincentshanecurtis - Wednesday, June 28, 2017 11:34 AM

    Thanks for your input Drew.  Would this method allow me to move freely back and...

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

    June 28, 2017 at 12:59 pm

    #1948618

Viewing 15 posts - 796 through 810 (of 911 total)