Forum Replies Created

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

  • RE: DTS Error

    Hi, I also got the error even choosing not to save the package.

    After trying many things I resolved the problem by formating the machine.

  • RE: DTS Error

    Thanks for your reply, I get the error when I use the DTS Import/Export Wizard to transfer data, source and destination databases are located on the local server. I receive the error message...

  • RE: Query to find missing IDs

    That's really fine!

    It's just what i need, a diferent aproach, i will use a combination of both queries:

    SELECT q.LowerMissing, q.UpperMissing, (q.UpperMissing - q.LowerMissing) AS [Difference] FROM

     (SELECT (DocVendaid + 1) LowerMissing,

      (SELECT...

  • RE: Need help with query

    I really have to visit this forum more often!

    Thanks a lot!

  • RE: Need help with query

    Nice!

    Thanks noeld for your help.

    DocTypes can be added by clients, so I will create a cursor to build a dynamic version of the...

  • RE: Transactions problem...

    Thanks cmore and ThomasH for your replies.

    My idea is to use the one field on tmptable (int) to show the sproc progression in a visual basic progress bar, that's why...

  • RE: Transactions problem...

    I need to do that because i'm writing a vb app that monitors the sproc progression by reading it on the TmpTable of the example given.

    I would really apreciate any...

  • RE: Using TOP

    Where's a way of doing it...

    declare @iRows int,

    @nvsql nvarchar(200)

    set @iRows = 10

    set @nvsql = 'select top ' + convert(char,@iRows) + ' * from TableName'

    exec sp_executesql @nvsql

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