Forum Replies Created

Viewing 15 posts - 91 through 105 (of 211 total)

  • RE: Omit selected fields from the GROUP BY clause

    ZZartin - Wednesday, August 15, 2018 8:14 AM

    Well can you just use a windowed function for the SUMS?  Then filter it down...

    Saravanan

    August 15, 2018 at 10:31 am

    #2001931

  • RE: SQL Like ( not beginning with )

    savioceg - Wednesday, August 15, 2018 9:16 AM

    Hi ,

     I am trying to do a pattern search and my query is generic and...

    Saravanan

    August 15, 2018 at 10:30 am

    #2001930

  • RE: Deleted

    chocthree - Tuesday, August 14, 2018 6:56 AM

    Hi,
    I hope this is the right forum to ask this question. Not sure where else...

    Saravanan

    August 14, 2018 at 10:04 am

    #2001697

  • RE: Duplicate records

    Eirikur Eiriksson - Sunday, August 12, 2018 7:35 AM

    As we do on this site, we don't assume, we state the facts.
    So, just to put...

    Saravanan

    August 12, 2018 at 12:19 pm

    #2001405

  • RE: Today's Random Word!

    Eirikur Eiriksson - Saturday, August 11, 2018 9:41 AM

    ManicStar - Friday, August 10, 2018 12:43 PM

    Saravanan

    August 11, 2018 at 2:43 pm

    #2001378

  • RE: split string into two columns

    Lowell - Friday, August 10, 2018 11:57 AM

    here you go, here is one way:
    i just used a case statement to examine the fifth character,...

    Saravanan

    August 11, 2018 at 2:39 pm

    #2001377

  • RE: Duplicate records

    msramos - Friday, August 10, 2018 2:32 PM

    Hi All:
    I appreciate your help with this situation:

    After creating a union between 2 tables in a CTE, there...

    Saravanan

    August 11, 2018 at 2:35 pm

    #2001376

  • RE: Today's Random Word!

    Ray K - Monday, August 6, 2018 12:34 PM

    ZZartin - Monday, August 6, 2018 10:53 AM

    Saravanan

    August 6, 2018 at 1:11 pm

    #2000492

  • RE: SQL help with date comaprisons

    komal145 - Monday, August 6, 2018 12:43 PM

    drew.allen - Wednesday, August 1, 2018 1:03 PM

    Here is...

    Saravanan

    August 6, 2018 at 1:08 pm

    #2000490

  • RE: Find the second occurrence in the string

    andycadley - Thursday, August 2, 2018 7:42 PM

    Drop Table If Exists #Temp
    Create Table #Temp
    (
     Code VarChar(20)
    )

    Insert Into #Temp(Code)
    Values
    ('C1588-27-3'),
    ('C1588-28-3'),
    ('C1588-29-8')

    Select Code, SubString(Code, 2, SecondHypen...

    Saravanan

    August 3, 2018 at 5:31 am

    #2000141

  • RE: SQL help with date comaprisons

    drew.allen - Wednesday, August 1, 2018 12:12 PM

    saravanatn - Wednesday, August 1, 2018 11:47 AM

    Clue:...

    Saravanan

    August 2, 2018 at 1:27 am

    #1999970

  • RE: SQL help with date comaprisons

    komal145 - Wednesday, August 1, 2018 10:28 AM

    Hi,
     I have a scenario where i need to calculate the number of days of hold...

    Saravanan

    August 1, 2018 at 11:47 am

    #1999923

  • RE: How to get min and max date?

    Luis Cazares - Wednesday, August 1, 2018 7:01 AM

    This would work if you always have contiguous dates. Otherwise, you might need an...

    Saravanan

    August 1, 2018 at 8:07 am

    #1999877

  • RE: How to get min and max date?

    ThomasRushton - Wednesday, August 1, 2018 2:28 AM

    Here's one option using windowing functions and aggregates.

    WITH
    CSIDChange -- mark the first line of each...

    Saravanan

    August 1, 2018 at 8:06 am

    #1999876

  • RE: Standard Deviation (variance) using columns in same row.

    tshad - Tuesday, July 31, 2018 2:47 PM

    Is there a way to get a variance from two columns in the same row? 

    I have...

    Saravanan

    July 31, 2018 at 3:25 pm

    #1999794

Viewing 15 posts - 91 through 105 (of 211 total)