/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

0 vote305 views2 answers
Coursera spark sql max count
SQL
0 vote282 views1 answer
How to check which table has data in mysql
SQL
25 votes273 views4 answers
Metadata
SQL
4 votes258 views2 answers
What is table in sql
SQL
1 vote275 views1 answer
Show structure of table in sql
SQL
0 vote318 views1 answer
Generate sql from specific migration ef core
SQL
0 vote264 views1 answer
Ora 00001 error catch plsql
SQL
0 vote281 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
5 votes270 views1 answer
Postgresql functions
SQL
1 vote278 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL