/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 vote129 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
0 vote157 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
0 vote134 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote126 views1 answer
Hibernate show sql xml property
SQL
1 vote135 views1 answer
Mysql how to truncate table with foreign keys
SQL
0 vote137 views1 answer
Tsql pad left
SQL
0 vote197 views1 answer
How to update random rows in sql
SQL
1 vote130 views1 answer
Search for replace in mysql
SQL
2 votes125 views5 answers
Tablespace ORACLE
SQL
0 vote126 views1 answer
Why mysql is used?
SQL