Forum Replies Created

Viewing 15 posts - 136 through 150 (of 211 total)

  • RE: update query question

    Guras - Friday, June 22, 2018 11:27 AM

    I have the following table

    fiirstname lastname SSN , DOB, orderId
    AAA    BBB   null  01/01/1980    null
    AAA    BBB   null  ...

    Saravanan

    June 22, 2018 at 12:26 pm

    #1995004

  • RE: Return last amount larger than 0

    Ian C0ckcroft - Friday, June 15, 2018 4:56 AM

    Hi guys,
    I have a table of accounts by month.
    I need to return the last...

    Saravanan

    June 15, 2018 at 5:50 am

    #1994100

  • RE: Query a Field and Ignore Commas and Periods in DB Value

    mcromarty - Thursday, June 14, 2018 9:10 AM

    Hi,

    I'm not sure how to query a field that contains commas...

    Saravanan

    June 14, 2018 at 9:25 am

    #1994016

  • RE: Cross Apply not summing correctly

    Eirikur Eiriksson - Monday, June 11, 2018 4:33 AM

    saravanatn - Monday, June 11, 2018 4:00 AM

    Saravanan

    June 11, 2018 at 4:50 am

    #1993521

  • RE: Cross Apply not summing correctly

    saravanatn - Friday, June 8, 2018 11:42 PM

    Eirikur Eiriksson - Friday, June 8, 2018 11:22 PM

    Saravanan

    June 11, 2018 at 4:00 am

    #1993514

  • RE: Correlated subquery using two different tables...

    jarodjp42 - Monday, March 26, 2018 2:30 PM

    Can anyone give an explanation of why you put the subquery after the divided sign?...

    Saravanan

    June 11, 2018 at 2:33 am

    #1993507

  • RE: Cross Apply not summing correctly

    Eirikur Eiriksson - Friday, June 8, 2018 11:22 PM

    You can simplify this query, no need to use cross apply or a CTE.
    😎

    [code...

    Saravanan

    June 8, 2018 at 11:42 pm

    #1993467

  • RE: Cross Apply not summing correctly

    You did the 1st part right by posting the sample data. Now can post us the desired results. Then what version of  sql server are you using? because higher version...

    Saravanan

    June 8, 2018 at 10:51 pm

    #1993465

  • RE: Can anyone explain why this isn't populating the two desired columns?

    Luis Cazares - Thursday, June 7, 2018 7:00 AM

    I would check these expressions. You might be confused on what you're doing.
    LEFT(cnd.Name, CHARINDEX(':',...

    Saravanan

    June 7, 2018 at 7:26 am

    #1993214

  • RE: Can anyone explain why this isn't populating the two desired columns?

    chocthree - Thursday, June 7, 2018 6:00 AM

    Hi,
    Please see the below query. When executing this query I find two derived columns [Candidate...

    Saravanan

    June 7, 2018 at 7:23 am

    #1993211

  • RE: Conversion failed when converting the nvarchar value '/' to data type int.

    ahmed_elbarbary.2010 - Monday, June 4, 2018 10:16 PM

    thank you for reply 
    right side OK working on EXPR2 but
    expr1 not working as left side 
    my...

    Saravanan

    June 5, 2018 at 1:49 am

    #1992935

  • RE: create table from select

    MinhL7 - Saturday, June 2, 2018 10:02 PM

    What's the correct syntax?
    CREATE TABLE Title2
    AS SELECT * FROM Title
    Msg 156,...

    Saravanan

    June 2, 2018 at 10:31 pm

    #1992751

  • RE: Count

    darsha.shashank - Friday, June 1, 2018 11:02 AM

    Hello All,

    I am trying to calculate total DISTINCT COUNT for names.

    Saravanan

    June 1, 2018 at 11:27 am

    #1992674

  • RE: AVG days between max and second last date

    ScottPletcher - Wednesday, May 23, 2018 10:11 AM

    I don't think "AVG" really has any meaning for the diff between only 2 dates?!

    SELECT...

    Saravanan

    May 23, 2018 at 11:18 am

    #1991665

  • RE: AVG days between max and second last date

    ringovski - Wednesday, May 23, 2018 12:57 AM

    Hi I am trying to work out a script to return the average number of...

    Saravanan

    May 23, 2018 at 2:57 am

    #1991572

    • Viewing 15 posts - 136 through 150 (of 211 total)