/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

2 votes196 views1 answer
Node and mysql like
SQL
0 vote200 views1 answer
Postgres meta command to show all rows in table
SQL
0 vote197 views2 answers
Timing sql queries
SQL
3 votes194 views2 answers
Tsql join multiple record in one string
SQL
0 vote179 views2 answers
Mysql on update current_timestamp
SQL
5 votes233 views1 answer
Oracle columns in all_tables
SQL
0 vote184 views1 answer
Postgres where
SQL
2 votes202 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL
0 vote182 views1 answer
Export partttion and import in oracle
SQL
3 votes182 views2 answers
Brew start mysql
SQL