/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 vote148 views1 answer
Alter owner in PostgreSQL
SQL
0 vote128 views1 answer
How to tell if i have lactose intolerance
SQL
4 votes100 views1 answer
Sql list users and roles
SQL
0 vote128 views1 answer
How to create a new shema using query languaage
SQL
1 vote131 views1 answer
Postgresql if 0 then 1
SQL
1 vote120 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
0 vote115 views1 answer
Distinct data types in a table sql query
SQL
21 votes127 views3 answers
Sql server search column name in all tables
SQL
1 vote155 views1 answer
Mysql is odd
SQL
0 vote154 views1 answer
How to pass list as parameter in SQL query
SQL