Forum Replies Created

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

  • RE: Hanging Restore

    If I were a gambler, I'd bet you do not have sufficient disk space to complete the restore. A similar experience happened with a client of mine and boggled...

  • RE: database move

    If your have Enterprise edt. and have access to Enterprise mgr, then make a back up file (.BAK) transfer the file to the new server and restore database from the...

  • RE: Duplicates

    Matt,

    I've had to work similarly and the staging table approached worked best for me. It's very clear, easy to validate, and easy to clean up.

    -Kel

  • RE: Getdate() in user defined function

    because the UDF is going to be used in search functionality as a view, I need join on it. When I realized I needed to pass in a date,...

  • RE: Getdate() in user defined function

    ...which I can appreciate, and so they don't allow for the getdate() function in the udf ...BUT passing it in as a param should be allowed. Te return value...

  • RE: Getdate() in user defined function

    Ugh! Yeah that's where I'm headed I guess, but selecting from a table, or a view that is created to house or supply, something that should be as easily...

  • RE: Rollback Transaction on error

    You should be checking for errors after any insert, update or deletes and responding to them within you proc (rolling back the transaction) and responding to the calling procedure or...

  • RE: Help with Query !!!!

    Sarat

    Is this what you're looking for? Just paste my code into QA replacing my table vars with your tables.

    Hope this helps.

    -kel

    begin

    declare @tblVendor table (VendorId INT IDENTITY,DataId INT )

    declare...

  • RE: Table variable vs. Temp Table

    Thanks for the input guys, I guess it's in part my opinion of small...1000's of rows is what I'm dealing with and for SQL server I consider that small. ...

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