Forum Replies Created

Viewing 15 posts - 16 through 30 (of 1,228 total)

  • RE: Which data type store unit cost price and amount in sqlserver 2012?

    ahmed_elbarbary.2010 - Sunday, May 21, 2017 4:25 AM

    i ask about what is suitable to my case decimal or money

    What are the smallest...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    May 21, 2017 at 5:18 am

    #1943471

  • RE: how to select several columns with one being distinct

    perry.59 - Wednesday, May 17, 2017 10:08 AM

    As you can see in the screenshot below (I hope it is legible) I have...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    May 17, 2017 at 10:57 am

    #1942976

  • RE: Extracting Episode Start and End Dates From Multiple Assignments

    DesNorton - Sunday, May 7, 2017 2:57 AM

    Nice Chris

    Just one small change to your script
    Need to change MIN(ENDDATE) to MAX(ENDDATE)

    SELECT ACCOUNT, PROGRAM,...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    May 7, 2017 at 5:27 am

    #1941463

  • RE: (Quickly) Delete records from a table, with condition

    Jeff Moden - Saturday, May 6, 2017 8:59 PM

    tacy.highland - Friday, May 5, 2017 12:17 PM

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    May 7, 2017 at 2:05 am

    #1941457

  • RE: (Quickly) Delete records from a table, with condition

    tacy.highland - Friday, May 5, 2017 2:20 PM

    An update is not an option here. 

    Any other ideas?  I'm getting desperate....

    Why is UPDATE...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    May 6, 2017 at 1:00 pm

    #1941439

  • RE: problem in connect tosql of internet

    kiasystemsoft - Saturday, May 6, 2017 10:49 AM

    hi
    i have coneccted to sql server with ip valid of sqlserver management
    password sa is...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    May 6, 2017 at 12:53 pm

    #1941438

  • RE: Extracting Episode Start and End Dates From Multiple Assignments

    DesNorton - Saturday, May 6, 2017 12:47 AM

    After re-reading my post from last night, I notice that the solution will only work...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    May 6, 2017 at 9:42 am

    #1941425

  • RE: Federal Holiday Function

    ScottPletcher - Tuesday, May 2, 2017 1:18 PM

    Here's another alternative.  Btw, I corrected two holiday descriptions, for Jan and Feb.  It's not...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    May 2, 2017 at 1:52 pm

    #1940777

  • RE: SQL Query Running Count

    lhynlen - Friday, April 28, 2017 8:35 AM

    Any idea how can i get a running count in sql?
    This is my desired result:

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    April 28, 2017 at 10:22 am

    #1940406

  • RE: Help with SQL Loop Query

    rocky_498 - Friday, April 21, 2017 12:29 PM

    Chris, 
    It's a HUGE effort that you doing. Highly appreciate. However, from the test/live data example...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    April 21, 2017 at 1:27 pm

    #1939384

  • RE: Are the posted questions getting worse?

    SQLRNNR - Friday, April 7, 2017 11:04 AM

    Brandie Tarvin - Friday, April 7, 2017 10:58 AM

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    April 7, 2017 at 12:47 pm

    #1937275

  • RE: Help me rearrange the SQL statement - It works but ?

    Luis Cazares - Monday, April 3, 2017 11:59 AM

    ChrisM@home - Monday, April 3, 2017 11:46 AM

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    April 3, 2017 at 12:49 pm

    #1936402

  • RE: Help me rearrange the SQL statement - It works but ?

    Thom A - Monday, April 3, 2017 12:00 PM

    ChrisM@home - Monday, April 3, 2017 11:54 AM

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    April 3, 2017 at 12:45 pm

    #1936401

  • RE: Help me rearrange the SQL statement - It works but ?

    Thom A - Monday, April 3, 2017 11:51 AM

    For my own sanity, and probably others:
    SELECT CLAIM.DClaim.FormNbr, CLAIM.DClaim.AdmitDate, CLAIM.DClaim.Membernbr,
       ...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    April 3, 2017 at 11:54 am

    #1936373

  • RE: Help me rearrange the SQL statement - It works but ?

    mw112009 - Monday, April 3, 2017 11:41 AM

    Or let me make everyones life easier a bit...
    I ve never seen a SQl statement...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    April 3, 2017 at 11:46 am

    #1936370

Viewing 15 posts - 16 through 30 (of 1,228 total)