/SQL/Best practive to pass multiple table to stored procedure in sql server

Best practive to pass multiple table to stored procedure in sql server

CREATE PROCEDURE MySproc
    @PrimaryTable primary_tbltype READONLY,
    @RelatedTable related_tbltype READONLY
AS
BEGIN
DECLARE @CurrentKey INT
DECLARE @FirstName VARCHAR(30)
DECLARE @LastName VARCHAR(30)
DECLARE @AccountTotal MONEY

DECLARE PersonCursor CURSOR LOCAL FAST_FORWARD FOR
    SELECT personkey, firstname, lastname FROM @PrimaryTable
OPEN PersonCursor
FETCH NEXT FROM PersonCursor INTO @CurrentKey, @FirstName, @LastName
WHILE @@FETCH_STATUS= 0 BEGIN

    SELECT @AccountTotal = SUM(accountbalance) FROM @RelatedTable 
        WHERE fk_personkey = @CurrentKey

    PRINT @FirstName + ' ' + @LastName + ' - account total: ' + CONVERT(VARCHAR(30), @AccountTotal)

    FETCH NEXT FROM PersonCursor INTO @CurrentKey, @FirstName, @LastName
END
END;

Source: stackoverflow.com

Similar codes

1 vote146 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote134 views1 answer
Sql cursor example multiple columns
SQL
1 vote126 views2 answers
Mysql trim whitespace
SQL
2 votes180 views1 answer
Username sql
SQL
0 vote144 views1 answer
Drop procedure sql
SQL
2 votes144 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
2 votes145 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
0 vote147 views1 answer
How to locate pg_hba.conf file
SQL
0 vote138 views1 answer
How to know if table in rigt or left in sql
SQL
0 vote142 views1 answer
Sql dmv to capture updates
SQL