/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 vote271 views1 answer
Get week day name sql server
SQL
3 votes284 views2 answers
Postgres alter table owner
SQL
0 vote294 views1 answer
Ms sql print more than 1 variable
SQL
0 vote360 views1 answer
How to rename a database in tsql
SQL
0 vote280 views1 answer
Sql query to get column names and data types in sql server
SQL
20 votes292 views5 answers
Sql show tables
SQL
14 votes284 views1 answer
Sql value of string
SQL
0 vote279 views1 answer
Mysql database hyphen
SQL
0 vote268 views1 answer
First mysql
SQL
21 votes237 views7 answers
Table drop if exist sql server
SQL