Forum Replies Created

Viewing 15 posts - 1 through 15 (of 140 total)

  • RE: Rounding Tips and Tricks

    The Conditional rounding is not giving the desired results, based on the statement

    people need to round only if it would round down.

    That would imply an OriginalValue greater than...

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: SQL Battleship

    game_outcome

    Game over. Human player wins in 40 shots! With just my Patrol boat left. Phew :w00t:

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: Insert Rows from excel file

    I was going to suggest UNPIVOT but then noticed it's in dwains signature.

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: Excel File with more than 256 columns

    Phil Parkin (8/12/2013)


    twin.devil (8/12/2013)


    For Some reason ... Excel and SSIS dont really like each other 🙂

    It's because Excel thinks it knows what you want: so that even when you...

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: Cannot open New SSIS Project in SQL Server 2008 R2

    Thanks a lot for that. Saved hours of head scratching and throwing things at the monitor 😀

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: Nested Temporary Tables

    Thanks for the explanation Wayne.

    Learned something new and another place to look if results don't meet expectations 😉

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: Nested Temporary Tables

    hmm, I get

    Msg 213, Level 16, State 1, Procedure Proc2, Line 4

    Column name or number of supplied values does not match table definition

    SQL 2008

    Win 2008 R2

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: default schema trouble

    As with Cliff, I glanced over the important bit.

    I must read the question completely.

    I must read the question completely.

    I must read the question completely.

    I must read the question completely.

    .

    .

    .

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: Load Tab delimited file while modifying

    Be aware of the QOTD from the 5th July

    http://www.sqlservercentral.com/Forums/Topic947263-1694-1.aspx

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: We Still Need Human Judgment

    Sometimes even with cash registers people will struggle if you were to give them 20.47.

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: T-SQL SQL 2008

    Picture didn't appear for me either.

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: HAVING

    That's just plain wrong. 😉

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: insert into temp table

    Good question and good explanation by Hugo.

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: HAVING

    Ah well. Got it wrong but at least learned something new.

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: The Death March

    Hours worked last week 0

    Nice holiday 😛

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

Viewing 15 posts - 1 through 15 (of 140 total)