Forum Replies Created

Viewing 15 posts - 1,396 through 1,410 (of 1,473 total)

  • RE: Return all rows where one is a match

    Here is what I get when running the three methods. Apologies for the somewhat sloppy code, I wrote this on my laptop while laying on the couch.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 12, 2008 at 3:02 pm

    #883939

  • RE: Return all rows where one is a match

    Jeff Moden (10/11/2008)

    Garadin (10/10/2008)

    The IN clause is actually faster than the multiple joins. I tested it on the Northwind database (so it was easily repeatable) as so:

    I ran your...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 12, 2008 at 9:58 am

    #883912

  • RE: Return all rows where one is a match

    It was my understanding that these subqueries are basically the equivalent of derived tables, as they don't reference the outer rows and thus should not repeat for every row. ...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 11, 2008 at 4:07 pm

    #883829

  • RE: Return all rows where one is a match

    The IN clause is actually faster than the multiple joins. I tested it on the Northwind database (so it was easily repeatable) as so:

    [font="Courier New"]

    SELECT

                oh.orderid

                , od.productid

                , od.quantity

        FROM dbo.Orders oh

                JOIN...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 10, 2008 at 7:57 pm

    #883714

  • RE: COMBINE ROWS OF ONE TABLE

    He double posted.

    http://www.sqlservercentral.com/Forums/Topic584195-338-1.aspx

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 10, 2008 at 7:28 pm

    #883709

  • RE: COMBINE ROWS OF ONE TABLE

    Hah, you caught me there for a second. In your second post, you posted some data and an expected result. Then in your third, the actual inserts had...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 10, 2008 at 2:18 pm

    #883634

  • RE: COMBINE ROWS OF ONE TABLE

    Please refer to the post in my signature on how to post data on this forum and then post some sample data and your table structure.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 10, 2008 at 1:02 pm

    #883607

  • RE: Changing sql keywords to lower or upper

    Yes, I too like upper cased keywords because:

    Except he's not trying to make them uppercase, he's trying to make keywords(and only keywords) all lower. Hence the amount of outrage...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 10, 2008 at 8:29 am

    #883449

  • RE: Needs help to update multilple records in a table which has a composite PK

    Go ahead and create your temp table, but then instead of a loop, use this:

    [font="Courier New"]UPDATE table_name

    SET    field1=T2.value1,

       field2=T2.value2

    FROM table_name T1 INNER JOIN temp_table T2 ON T1.ID = T2.ID AND T1.RecNo...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 10, 2008 at 5:52 am

    #883357

  • RE: Job processing all views in DB

    Heh, I briefly thought about putting all of that into one huge string to exec... but that kinda thing just makes me a bit nervous. No practical reason for...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 9, 2008 at 9:40 pm

    #883230

  • RE: SQL Server 2008 Intellisense! Love it or hate it?

    I was super excited about it, and while it may just be that I'm so used to coding without it that I can't appreciate it yet, so far it just...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 9, 2008 at 6:56 pm

    #883192

  • RE: Concatenate

    Yeah... don't do what I posted, that's what I get for trying to respond real quick before I answered someone's email. That way will have you dropping all your...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 9, 2008 at 10:19 am

    #883015

  • RE: Updating NULL Values

    Well, I spent a couple hours attempting to beat the speed of Jeff's method(not that I actually believed I could, but I figured a lot out about it while trying)...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 9, 2008 at 10:10 am

    #883006

  • RE: Concatenate

    SELECT REPLACE(CAST(col1 as varchar(20)) + CAST(col2 as varchar(20)),'0','')

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 9, 2008 at 9:34 am

    #882979

  • RE: Need to change 1000 SP's drop & re-recreate them with permissions?

    Rather than updating 1000 SP's, couldn't you just create a view named what the table used to be that references the new database / table with a SELECT * ?

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 9, 2008 at 9:30 am

    #882974

Viewing 15 posts - 1,396 through 1,410 (of 1,473 total)