Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: Fun with Transactions - Part I

    You cannot simply rollback a named nested transaction you can only rollback to a savepoint.

    "Naming multiple transactions in a series of nested transactions with a transaction name has little effect...

  • RE: PRINT vagaries

    Yes, it seems inconsistent that '-' will convert to int but not float. This comes out another way with the order of evaluation:

    select 6 + '-' + 1.0;

    select 6.0 +...

  • RE: Concurrent processing in SSIS – Part 1

    I have dual core and 4GB. When I get the chance I'll try using a remote SQL Server that should help.

  • RE: Concurrent processing in SSIS – Part 1

    Interesting stuff but I tried adding "waitfor delay '00:00:01';" to each of the sample work SQL tasks in the OnePackageMethod (before the update statement). That way you can see what...

  • RE: Capturing Real-Time Currency Conversions in SSIS

    There may be other motives for the method shown that I'm not getting but it seems to be an insanely inefficient and complicated way to do it: read service, write...

  • RE: An interesting thing about isnull

    It's also interesting that coalesce behaves a different way from isnull.

    My point in giving the isnull/convert formulation was to show how to make isnull behave in the way you might...

Viewing 6 posts - 1 through 6 (of 6 total)