/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

1 vote127 views1 answer
Oracle compile schema
SQL
0 vote178 views1 answer
Mysql select row with min date
SQL
0 vote148 views9 answers
Linq to sql converter online
SQL
-1 vote159 views1 answer
Add bool column in sql
SQL
0 vote143 views1 answer
Console output pl sql
SQL
5 votes176 views1 answer
How to get all table names in sql query
SQL
2 votes162 views2 answers
Mysql alter column default
SQL
0 vote130 views1 answer
Ms sql unique
SQL
9 votes157 views5 answers
Sql limit
SQL
0 vote164 views1 answer
Replace divide by zero error with 0 in sql
SQL