Additional questions. What results should be for this?

CREATE TABLE #Companies (CompanyID int)

INSERT INTO #Companies (CompanyID) VALUES (1)

INSERT INTO #Companies (CompanyID) VALUES (2)

INSERT INTO #Companies (CompanyID) VALUES (3)

CREATE TABLE #CompanyGroups (CompanyGroupID char(1), CompanyID int)

INSERT INTO #CompanyGroups (CompanyGroupID,CompanyID) VALUES ('A',1)

INSERT INTO #CompanyGroups (CompanyGroupID,CompanyID) VALUES ('A',2)

a.

SET @CompanyID = 1

SET @CompanyGroupID = 'A'

b.

SET @CompanyID = 1

SET @CompanyGroupID = 'B'

c.

SET @CompanyID = 3

SET @CompanyGroupID = 'A'

d.

SET @CompanyID = 3

SET @CompanyGroupID = 'E'

e.

SET @CompanyID = NULL

SET @CompanyGroupID = NULL

:unsure: