Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2007
    Location
    Stalybridge, Manchester
    Posts
    273

    Unanswered: Temp Table to Live Tables

    I have a Stored Procedure that appends the data in the Temp Table into the Live Table. on Append how is it possible to do a count of whats in the Temp Table and match against whats appended into Live Table?

    This is my Execute SP

    Code:
    EXEC sp_WL_Data
    SELECT * FROM WL_DATA

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Return the number of affected rows (@@RowCount) as an output parameter of the stored procedure?
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •