Forum Replies Created

Viewing 15 posts - 2,611 through 2,625 (of 2,741 total)

  • RE: Database Size

    Add me to the angry chorus.

    This is not a fair question. More detail is needed before we can give an honest answer.

    I want my points back.

  • RE: GOOD BOOK OR ONLINE CLASS TO LEARN SQL

    norrisbiney (1/20/2010)


    thanks for the prompt response. Where can i get the BOLs from.

    BOL comes with SQL Server.

  • RE: GOOD BOOK OR ONLINE CLASS TO LEARN SQL

    A lot of people on these forums (myself included) will probably suggest that you get yourself acquainted with the documentation that comes with SQL (referred to as "Books Online," or...

  • RE: Talking baseball

    tosscrosby-60625 (1/20/2010)


    Heck, I'd take 8 mil and walk to the bank smiling all the way.

    So would I, but hey, I don't play big-league ball! 🙂

    I'd be concerned about offering a...

  • RE: SQL Statement to retrieve date from two weeks ago

    roundel1900 (1/20/2010)


    I am assuming I would use the dateadd function but how would I retrieve the date from two weeks ago from today's date. I basically need to retrieve records...

  • RE: Talking baseball

    I heard King Felix signed a five-year extension with Seattle. And a number of others avoided arbitration by signing contracts.

    Speaking of arbitration, I understand Tim Lincecum submitted a figure...

  • RE: Refreshing a SQLDataSource in VS2008

    For others' reference: I figured it out. The SQLDataSource object was refreshing just fine. The problem was with the GridView object. I had to refresh that as...

  • RE: Talking baseball

    Steve Jones - Editor (1/18/2010)


    Should be three week until we start practice.

    Looking forward to the season. Thinking to drive to KC this year for a game.

    To go see the Royals,...

  • RE: Talking baseball

    Only a month until pitchers and catchers report! 🙂

    Spring Training is right around the corner!

  • RE: @@error

    stephenhai (1/15/2010)


    My company is going to upgrade from 2000 to 2008.

    Do I need to change all the @@error logic to Try...Catch logic

    No, you should still be able to use @@error,...

  • RE: Changing a FLOAT column to VARCHAR

    lmu92 (1/15/2010)


    Since FLOAT is an approximate-number data type, the character length may vary, therewith exceeding the VARCHAR(10) limit.

    You need to get the value converted to a "known length".

    Either one...

  • RE: Changing a FLOAT column to VARCHAR

    Update: I came up with a kludge solution where I only updated a ZIP with len(ZIP) = 5.

    For my future refence: any thoughts to my initial post?

  • RE: Talking baseball

    Jan Van der Eecken (1/15/2010)


    Re WBC, what I meant with "I really wouldn't know" was that I'm not an official of the SA Baseball Union, so I have no idea...

  • RE: Subroutines in TSQL

    Jeff Moden (1/14/2010)


    But it sounds like a cursor (GAH!) could serve as a "subroutine".

    I'll bet it was really painful for you to type this! 😀

  • RE: Nested Update Statement

    greggoble2 (1/14/2010)


    --first I grab all the ID's that have a status of 4

    Select MessageID

    From MessageQueue

    Where MessageStatusID = 4

    --Then I put the messageID's from the results of the above query into...

Viewing 15 posts - 2,611 through 2,625 (of 2,741 total)