/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

5 votes258 views1 answer
Find table from column name in sql
SQL
0 vote242 views1 answer
Select top 3 sql
SQL
1 vote270 views2 answers
Sql server add time to date
SQL
0 vote250 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
3 votes283 views6 answers
Jwt laravel
SQL
0 vote240 views1 answer
Mysql local password denied
SQL
0 vote252 views1 answer
Safe mysql
SQL
2 votes291 views3 answers
Xampp mysql database not starting
SQL
0 vote249 views1 answer
How to convert DateTime to VarChar SQL
SQL
4 votes263 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL