/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

16 votes215 views1 answer
Sql comment'
SQL
-1 vote240 views1 answer
Brisanje dupliranih konatakata
SQL
0 vote234 views1 answer
T-sql delete view if exists
SQL
0 vote211 views2 answers
Android sqlite query join
SQL
0 vote241 views1 answer
Make parameters nullable in sql server
SQL
1 vote202 views1 answer
Truncate table in postgresql and reset id
SQL
0 vote220 views1 answer
Mysql conf.d exampel
SQL
0 vote227 views1 answer
Get sum sqlite android
SQL
11 votes222 views1 answer
Sql insert multiple rows from select
SQL
0 vote208 views3 answers
Get count of null in column sql
SQL