/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 vote214 views1 answer
Psql client write to bash variable
SQL
0 vote183 views2 answers
Demmarrer un service mysql teminal cmd
SQL
1 vote164 views1 answer
Drop function
SQL
2 votes163 views2 answers
Select multiple tables mysql
SQL
0 vote168 views1 answer
Dbms_output sql developer
SQL
0 vote228 views1 answer
Restart serial number for postgres
SQL
1 vote113 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
6 votes186 views3 answers
Date_trunc postgres
SQL
0 vote173 views1 answer
Xampp mysql version
SQL
4 votes196 views4 answers
Mysql get date from datetime
SQL