Forum Replies Created

Viewing 15 posts - 1,021 through 1,035 (of 1,228 total)

  • RE: Merge Statement Question. Using Inserted value

    mandar.dasgupta (11/20/2010)

    ...Hope i made myself clear...

    Nearly. It would help if you could summarise this in terms of source and target tables and their locations.

    It's a little confusing because...

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

    November 21, 2010 at 3:25 am

    #1253471

  • RE: Are the posted questions getting worse?

    WayneS (11/20/2010)

    ChrisM@home (11/20/2010)

    WayneS (11/19/2010)

    LutzM (11/19/2010)

    WayneS (11/19/2010)

    LutzM (11/19/2010)

    I hope you folks in the U.S. will have the following Friday as well as the weekend off and you'll have a wonderful weekend...

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

    November 20, 2010 at 2:31 pm

    #1253438

  • RE: Are the posted questions getting worse?

    WayneS (11/19/2010)

    LutzM (11/19/2010)

    WayneS (11/19/2010)

    LutzM (11/19/2010)

    I hope you folks in the U.S. will have the following Friday as well as the weekend off and you'll have a wonderful weekend with your...

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

    November 20, 2010 at 10:48 am

    #1253417

  • RE: Today's Random Word!

    Manchili.

    Meat and chillies, no beans.

    Onions, garlic, whole cumin seeds browned with the meat. Red chillies for colour, green for flavour. Cumin powder with the crushed tomatoes. Rich stock from...

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

    November 20, 2010 at 10:39 am

    #1253415

  • RE: Are the posted questions getting worse?

    GilaMonster (11/19/2010)

    ChrisM@home (11/19/2010)

    If your birthday's next week I'll eat my hat. Or the remains of my finger.

    Your hat is safe. 2 and a half weeks away.

    p.s. What's special about next...

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

    November 19, 2010 at 3:01 pm

    #1253334

  • RE: Are the posted questions getting worse?

    Alvin Ramard (11/19/2010)

    Grant Fritchey (11/19/2010)

    GilaMonster (11/19/2010)

    Irreparably suspect, no backups.

    http://www.sqlservercentral.com/Forums/Topic1023390-146-1.aspx

    Doesn't say much for my mood that I slightly enjoyed posting that last message there. Wrong, I know.

    That's it. We're cancelling Christmas...

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

    November 19, 2010 at 2:13 pm

    #1253311

  • RE: Are the posted questions getting worse?

    GilaMonster (11/19/2010)

    Grant Fritchey (11/19/2010)

    GilaMonster (11/19/2010)

    Irreparably suspect, no backups.

    http://www.sqlservercentral.com/Forums/Topic1023390-146-1.aspx

    Doesn't say much for my mood that I slightly enjoyed posting that last message there. Wrong, I know.

    That's it. We're cancelling Christmas for...

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

    November 19, 2010 at 2:12 pm

    #1253310

  • RE: Learn cross tab query

    CELKO (11/19/2010)

    I give several ways to do this in SQL FOR SMARTIES.

    SSC publishes several ways for free.

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

    November 19, 2010 at 1:15 pm

    #1253283

  • RE: Are You a Ten?

    sqlsystemadministrators (11/17/2010)

    The best DBA is the one who can goolge the fastest.

    Nah it's not it's the one hoo can spel.

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

    November 17, 2010 at 2:08 pm

    #1252154

  • RE: After indexing subquery gives wrong result

    Edit: duplicate.

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

    November 16, 2010 at 2:31 pm

    #1251594

  • RE: To calculate the delta difference in same table

    This looks like homework, but that's okay, you've put some real effort in here. Couple of pointers:

    If a student only pays once in one year, then you don't need all...

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

    November 15, 2010 at 2:04 pm

    #1250988

  • RE: Left outer join in my sql procedure

    bob mazzo (11/12/2010)

    My left outer join below works in a sql query window just as I would expect however not in my stored proc result.

    Let me explain:

    1) Here's the stand...

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

    November 13, 2010 at 2:43 pm

    #1250386

  • RE: Loop through string and test if substring of another string

    Are you working with one table looking for potential dupes?

    Are you working with two or more tables looking for potential matches? Please provide as much information as you can.

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

    November 3, 2010 at 4:35 pm

    #1246330

  • RE: Are the posted questions getting worse?

    Dave Ballantyne (10/30/2010)

    Anyone kind enough to do a spot of proof reading / editing for my article for

    http://www.sqlservercentral.com/Forums/Topic1012017-2824-1.aspx

    TIA

    It would be an honour and an educational opportunity (heh...for me!), Dave.

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

    October 31, 2010 at 9:04 am

    #1244626

  • RE: A twist on the Merge statement

    If the source table is more than a few hundred rows, I'd use a temporary table instead of a table variable. You can index a table variable

    DECLARE @EXTERNAL_CUSTOMER TABLE(<<columns>>, UNIQUE(CUST_REF))...

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

    October 31, 2010 at 8:40 am

    #1244624

Viewing 15 posts - 1,021 through 1,035 (of 1,228 total)