/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 vote109 views1 answer
Sql query tags
SQL
7 votes122 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
-1 vote77 views1 answer
Mysql if example
SQL
35 votes111 views5 answers
Sql alter column
SQL
57 votes258 views5 answers
How to create a new user in postgresql
SQL
1 vote153 views3 answers
Showing all columns in an sqlite table
SQL
0 vote101 views1 answer
Codeigniter dbforge add index
SQL
0 vote110 views2 answers
Sql trigger difference between for and after
SQL
1 vote64 views1 answer
Unique vs distinct sql
SQL
0 vote95 views1 answer
Mysql where in keep order
SQL