when i excecute this stored procedure, i am getting 4 data set instead of one,
ALTER PROCEDURE [dbo].[Study]
(
@nber int,
@year char(4),
@cuo char(4)
)
AS
BEGIN
SET NOCOUNT ON;
SELECT DISTINCT
a.transport, a.office
FROM hed AS a INNER JOIN
history AS b ON a.year = b.year AND a.cuo = b.cuo AND a.nber = b.nber INNER JOIN
asgn AS d ON b.nber = d.nber AND b.year = d.year AND b.cuo = d.cuo INNER JOIN
reg AS e ON d.nber = e.nber AND d.year = e.year AND d.cuo = e.cuo INNER JOIN
dec_reg AS f ON e.nber = f.nber AND e.val_reg_year = f.val_reg_year AND e.val_reg_cuo = f.val_reg_cuo
WHERE (a.nber = @nber) AND (a.year = @year) AND (a.cuo = @cuo)
------------------------------------------------------------------------------------------------------
SELECT nber, CASE WHEN importer_cod = dec_ ...
Go to the complete details ...