Forum Replies Created

Viewing 15 posts - 646 through 660 (of 1,228 total)

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (1/5/2012)

    Thanks again everyone for their congratulations!

    You're the daddy!

    Well done dude. You know those little foam things you put in your ears when you're clay-pigeon shooting? Get some!

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

    January 6, 2012 at 6:16 am

    #1429581

  • RE: Returning a column per date in a range

    nick-1043370 (1/6/2012)

    Hi

    I need to take a set of records for people with hotel check-in/check-out dates, and display a table that has a column for each date in the range, with...

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

    January 6, 2012 at 6:11 am

    #1429578

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (1/6/2012)

    ...Am I the only person who hates the idea of an entirely NULL rowset with only an Identity in it?

    A polititian? :hehe:

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

    January 6, 2012 at 4:48 am

    #1429556

  • RE: Recusion on Group and their subGroups- how can I solve this problem?

    Shamshad Ali (1/6/2012)

    Hello chrisM@home,

    There is one scenario in which the query is not returning me expected data when there is no any Parent exists in groupAssociation table ....

    Since you...

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

    January 6, 2012 at 4:41 am

    #1429554

  • RE: Weekend data in SQL server 2000

    There's a very similar thread here.

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

    January 6, 2012 at 4:36 am

    #1429551

  • RE: Join - that may not be possible

    Without specifically capturing dates, you might get some milage from this:

    SELECT a.Reference, x1.codes, y.[DESCRIPTION]

    FROM #TempData a

    CROSS APPLY(

    SELECT codes = REPLACE(REPLACE(REPLACE(a.codes,'& ',''),'/',','),' ',',')

    ) x1

    OUTER APPLY (

    SELECT b.[DESCRIPTION]

    FROM #TempCodes...

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

    January 6, 2012 at 4:24 am

    #1429543

  • RE: Need help

    Can you post the actual plan for both queries - and the code for the function? Looks like the function is being executed once per row and it only needs...

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

    January 6, 2012 at 2:38 am

    #1429492

  • RE: Need help

    How long does this take to run:

    SELECT [item] FROM dbo.fn_Split('33',',')

    Can you post the CREATE statement for this function?

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

    January 6, 2012 at 2:22 am

    #1429483

  • RE: Quirky Update query...works on server ...fails on PC.

    SQL Kiwi (1/6/2012)

    Has anyone else managed to reproduce this now given the extra information I provided? Jeff in particular? I'm particularly interested to hear from anyone running 32...

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

    January 6, 2012 at 1:26 am

    #1429473

  • RE: Quirky Update query...works on server ...fails on PC.

    J Livingston SQL (1/4/2012)

    .....unless someone can provide a solution that is just as quick to run.???...

    A recursive CTE yielding an output set would do the job in about 4 times...

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

    January 6, 2012 at 1:25 am

    #1429472

  • RE: Deadlock Issues

    atchristian (1/3/2012)

    ...I do NOT have a primary key set. The primary key would be: TradeID, AnalysisTypeID, VolumeTypeID, Hour...

    If this is the edge case it appears to be, then you may...

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

    January 5, 2012 at 1:03 pm

    #1429318

  • RE: Deadlock Issues

    Evil Kraig F (1/5/2012)

    ChrisM@home (1/4/2012)

    Have you tried using MERGE for the upsert, instead of your current two-stage process?

    Shredding XML isn't instant - you may gain by separating this from the...

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

    January 5, 2012 at 12:51 pm

    #1429305

  • RE: Find lowest parent in recursive SQL table

    CELKO (1/5/2012)

    ...Buy a copy of HIKING IN SETS for more details...

    My cat bought this book and got completely lost on the first example - with a catnav.

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

    January 5, 2012 at 12:49 pm

    #1429303

  • RE: Update with except conditon

    drew.allen (1/5/2012)

    ChrisM@home (1/5/2012)

    drew.allen (1/4/2012)

    ChrisM@home (1/4/2012)

    say there are ten rows with the same VND_ID and only one of them matches the filter?

    You'll need to post sample data illustrating the problem and...

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

    January 5, 2012 at 12:44 pm

    #1429300

  • RE: Update with except conditon

    drew.allen (1/4/2012)

    ChrisM@home (1/4/2012)

    say there are ten rows with the same VND_ID and only one of them matches the filter?

    You'll need to post sample data illustrating the problem and the desired...

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

    January 5, 2012 at 11:14 am

    #1429236

Viewing 15 posts - 646 through 660 (of 1,228 total)