Forum Replies Created

Viewing 15 posts - 781 through 795 (of 1,473 total)

  • RE: Why do people need to do this?

    We'll see if Lynn's new photo avatar helps him. Little green guy... lots of wrinkles... you know it's rare that you actually guess what someone looks like from talking...

    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]

    January 24, 2009 at 9:29 am

    #932230

  • RE: How to replace a cell value with a cell value in previous row

    He wrote an article on it actually. See the Running Totals link in my signature.

    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]

    January 23, 2009 at 11:53 pm

    #932180

  • RE: Why do people need to do this?

    Ahh... and that one has a link to that "Performance and Integrity" thread. Of course, that particular issue is like 4 steps past this one in terms of WTF-itude.

    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]

    January 23, 2009 at 9:00 am

    #931844

  • RE: Why do people need to do this?

    It's not "one of those talks" if you win =).

    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]

    January 21, 2009 at 10:05 pm

    #930881

  • RE: Why do people need to do this?

    Jeff Moden (1/21/2009)

    Garadin (1/20/2009)

    Michael Valentine Jones (1/20/2009)

    In the end, does the reason why really matter?

    We had a meeting where we objected to a project as complete waste time and money,...

    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]

    January 21, 2009 at 8:09 pm

    #930861

  • RE: Arithmetic overflow when CASTing to decimal

    I figured you did. That's why I didn't whip out any BOL links ;).

    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]

    January 21, 2009 at 8:09 am

    #930373

  • RE: Arithmetic overflow when CASTing to decimal

    Decimal 8,2 means you have a total of 8 digits, not 8 to the left of the decimal point. Therefore, if you break a million (7 digits, you only...

    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]

    January 21, 2009 at 7:57 am

    #930359

  • RE: update one table from another using a join

    Try running this query.

    SELECT I.item_no,I.std_cost,I.loc, C.HBG_std_cost

    FROM HBG.dbo.IMINVLOC_SQL I

    LEFT JOIN FT.dbo.Std_Cost_Compare C ON I.item_no = C.item_no AND I.loc = C.HBG_loc

    A bit easier to read than yours. You're getting fewer...

    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]

    January 20, 2009 at 11:03 pm

    #930105

  • RE: Why do people need to do this?

    Michael Valentine Jones (1/20/2009)

    In the end, does the reason why really matter?

    We had a meeting where we objected to a project as complete waste time and money, and were 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]

    January 20, 2009 at 10:49 pm

    #930100

  • RE: how to get maxium value of a table when there are no records

    Lynn Pettis (1/20/2009)

    Garadin (1/20/2009)

    SELECT IDENT_CURRENT('yourtablename')+1

    I thought about this, but the OP's post didn't indicate that the PK (int column) was defined as an identity column. With out that info,...

    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]

    January 20, 2009 at 3:56 pm

    #930005

  • RE: IF statement with Select INTO error

    You cannot use SELECT INTO twice within a script even if you wrap it in an IF. You need to create your temp table first, then use INSERT INTO...

    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]

    January 20, 2009 at 3:42 pm

    #930000

  • RE: how to get maxium value of a table when there are no records

    Probably should have clarified. That returns the last used identity value from your table and adds 1 to it. That may not be what you actually want. ...

    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]

    January 20, 2009 at 3:39 pm

    #929999

  • RE: how to get maxium value of a table when there are no records

    SELECT IDENT_CURRENT('yourtablename')+1

    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]

    January 20, 2009 at 3:30 pm

    #929996

  • RE: How long will SQL 2005 hang around with 2008 being released?

    We still use 2K in production. A lot of companies that have highly customized software packages built on earlier versions have a very hard time upgrading.

    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]

    January 20, 2009 at 3:21 pm

    #929993

  • RE: how do i summarise and transpose table data

    Yeah, definitely read that one too quick. Sorry for the bad answer Jon.

    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]

    January 20, 2009 at 6:58 am

    #929709

Viewing 15 posts - 781 through 795 (of 1,473 total)