/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 vote304 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
2 votes357 views1 answer
Install postgresql centos 5
SQL
0 vote314 views1 answer
SQL Query to delete all the tables in a database
SQL
0 vote326 views1 answer
Mysql remove last character
SQL
0 vote399 views1 answer
Run docker container with database as rds metabase
SQL
1 vote311 views1 answer
Change old domain to new domain name wordpress
SQL
0 vote334 views1 answer
Sql express database size limit
SQL
1 vote359 views1 answer
Mariadb get column names from table
SQL
6 votes380 views2 answers
Oracle compile trigger
SQL
0 vote299 views1 answer
How to use lower case in mysql
SQL