Forum Replies Created

Viewing 15 posts - 10,951 through 10,965 (of 11,676 total)

  • RE: Incremental additions

    Hardy21 (10/29/2010)


    Thanks for the link. Hence, @a =+ @b-2 means @b-2 value assign to @a so @a = -21.

    Indeed. But why doesn't SQL Server give a syntax error? I would've...

  • RE: Incremental additions

    Iulian -207023 (10/29/2010)


    Great question, thanks

    Here is a reference to the compound operators: http://msdn.microsoft.com/en-us/library/cc645922.aspx

    Regards,

    Iulian

    Thanks for the reference, but it still doesn't explain the question. In the question =+ is used, while...

  • RE: Incremental additions

    Good question, but I've liked a little more explanation and if possible, a reference.

  • RE: SSIS File System Task

    parthi-1705 (10/28/2010)


    Hi

    I was not able to do as u said above.Any other way.

    ...

  • RE: Enable Broker Service

    Hardy21 (10/27/2010)


    that's really good observation - I think most of us didn't check the backup file which author has used for restoration.

    Well I did 🙂 I just ignored it because...

  • RE: Date Puzzle

    SanDroid (10/27/2010)


    You have done well in contradicting your own "facts" in your own posts about the nuts of SQL installs. Is the information in your other post is as correct.

    :rolleyes:

    German:...

  • RE: overlapping problem

    OK seriously, you have to formulate your questions better.

    We are all unpaid volunteers here. Help us to help you.

    I really think most of us won't even try to read/understand your...

  • RE: Date Puzzle

    SanDroid (10/27/2010)


    da-zero (10/27/2010)


    Have smileys totally lost their value nowadays?

    I am not certain. Are they? :w00t:

    I just used your response as a jumping off point. 😛

    I know you are...

  • RE: Date Puzzle

    SanDroid (10/27/2010)


    da-zero (10/27/2010)


    All I am reading is: easy question = good, difficult question = bad 😉

    I can tell by your reading and writing level you might be the moderator checking...

  • RE: Date Puzzle

    SanDroid (10/27/2010)


    I give this question Five Stars!

    It was code correct, the question was clear and had no typo's, and the author clearly understood the concept his question was testing.

    This Question...

  • RE: Date Puzzle

    This one was too easy, but thanks for the question anyway.

  • RE: stored procedure not working in Execute Sql Tak

    Glad that it worked out.

    We all have been struggling at some point with SSIS and temp tables...

  • RE: stored procedure not working in Execute Sql Tak

    The reason why it works in SSMS is because your connection is still open, so you can still access the global temp table ##temp.

    In SSIS however, the connection manager does...

  • RE: Don't capture the Result of Execute SQL Task in a Variable

    Lisset (10/26/2010)


    I see the variablewhile is running using a breakpoint.

    I has tried declaring the variable like Object, and don't capture the value.

    There is no need to declare the variale as...

  • RE: time and % data datatype

    GSquared (10/26/2010)


    da-zero (10/26/2010)


    If you really want to keep your % sign, then you'll have to import it as strings.

    Bad idea!

    First, you won't be able to query it mathematically. Second,...

Viewing 15 posts - 10,951 through 10,965 (of 11,676 total)