/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 vote290 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
1 vote298 views1 answer
Mysql how to reset primary key
SQL
7 votes293 views1 answer
Alter sequence set current value oracle
SQL
0 vote338 views1 answer
How to convert external table to managed table in hive
SQL
34 votes360 views6 answers
Alter table add foreign key mysql
SQL
2 votes298 views4 answers
Mysql select into new table
SQL
37 votes471 views3 answers
Sql check duplicate value in column
SQL
2 votes290 views1 answer
Update trigger
SQL
1 vote302 views1 answer
Oracle select first result
SQL
0 vote289 views1 answer
EnvironmentError: mysql_config not found
SQL