/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 vote260 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
0 vote272 views1 answer
Update having mysql
SQL
2 votes269 views1 answer
Mysql trigger after update
SQL
0 vote256 views2 answers
How to save result of sqlite query in a table
SQL
0 vote267 views1 answer
Where date in datetime mysql
SQL
5 votes282 views4 answers
Start postgres server
SQL
0 vote264 views1 answer
Sql add calculated column
SQL
0 vote291 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
11 votes273 views1 answer
Sql query to find duplicates in column
SQL
0 vote291 views1 answer
Move table to a different schema
SQL