Forum Replies Created

Viewing 15 posts - 31 through 45 (of 1,228 total)

  • RE: Performing a Right and Comprehensive Age Calculation

    m2c2 - Wednesday, March 29, 2017 11:55 AM

    ChrisM@home - Wednesday, March 29, 2017 11:45 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]

    March 29, 2017 at 12:14 pm

    #1935560

  • RE: Performing a Right and Comprehensive Age Calculation

    m2c2 - Wednesday, March 29, 2017 10:08 AM

    NBSteve - Tuesday, March 28, 2017 4:43 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]

    March 29, 2017 at 11:45 am

    #1935550

  • RE: How to join these tables together

    mcfarlandparkway - Tuesday, March 28, 2017 2:28 PM

    How to join Employee and Student tables with HR table, - using ID and date...

    [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]

    March 28, 2017 at 2:52 pm

    #1935386

  • RE: looping through INSERT results: what's the best way?

    rgouette - Monday, March 27, 2017 9:22 AM

    sorry for the lack of detail, here's what I tried:
       BEGIN
        UPDATE o
        SET generic_custom_description =...

    [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]

    March 27, 2017 at 10:52 am

    #1935129

  • RE: Warning: Null value is eliminated by an aggregate or other SET operation.

    mcfarlandparkway - Friday, March 24, 2017 7:30 PM

    Here is my code - I am using the count in this query, May I...

    [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]

    March 25, 2017 at 11:05 am

    #1934938

  • RE: Instance is under memory pressure. How to relieve from pressure

    Sean Lange - Friday, March 24, 2017 12:25 PM

    We are back to you needing to ask a question. What that means 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]

    March 24, 2017 at 12:40 pm

    #1934854

  • RE: A little help with a simple CASE statement

    seubanks00 - Friday, March 24, 2017 12:04 PM

    Correct -  if the SETUP_TIME is equal to zero then I want to return zero....

    [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]

    March 24, 2017 at 12:19 pm

    #1934851

  • RE: update table column with value from another table

    wmbc - Thursday, March 23, 2017 12:12 PM

    I'm trying to sequentially get the row of id's from TableB.id into TableA.tableid from row...

    [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]

    March 23, 2017 at 12:21 pm

    #1934615

  • RE: update table column with value from another table

    wmbc - Thursday, March 23, 2017 11:38 AM

    i tried this:

    UPDATE TableA
    SET tablebid = t1.id
    FROM TableB t1
    where t1.id IN (
    SELECT NULL AS id...

    [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]

    March 23, 2017 at 11:45 am

    #1934600

  • RE: tuning help

    Tara-1044200 - Wednesday, March 22, 2017 2:30 PM

    following qry is taking more than 3 hrs to run , it has billion records...

    [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]

    March 22, 2017 at 2:51 pm

    #1934400

  • RE: Windows Functions: Tell me when that changes.

    Jeff Moden - Saturday, March 18, 2017 3:31 PM

    ChrisM@Work - Friday, March 17, 2017 10:37 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]

    March 18, 2017 at 4:07 pm

    #1933869

  • RE: Conversion failed converting to integer

    elzool - Thursday, March 16, 2017 5:27 PM


    SELECT CONVERT(VARCHAR(10), GETDATE()+2, 1) AS 'Date'
    union
    SELECT DISTINCT User.id FROM User

    Msg 245, Level 16,...

    [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]

    March 17, 2017 at 3:24 pm

    #1933847

  • RE: Create a view to view encrypted columns from a table

    SSRS Newbie - Friday, March 17, 2017 2:12 PM

    Hello All,

    I have a table that has 5 encrypted columns. I'm using Symmetric Key...

    [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]

    March 17, 2017 at 3:15 pm

    #1933842

  • RE: Covering Index

    Welsh Corgi - Wednesday, March 15, 2017 5:39 PM

    Welsh Corgi - Wednesday, March 15, 2017 4:03 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]

    March 16, 2017 at 3:19 pm

    #1933651

  • RE: delete taking loooong time

    davidsalazar01 - Wednesday, March 8, 2017 2:51 PM

    Hello All,

    This block of code below is taking a long time to complete whereas other...

    [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]

    March 8, 2017 at 3:05 pm

    #1932421

Viewing 15 posts - 31 through 45 (of 1,228 total)