Stored Procedure Sub-Select?

[Steven Schafer]

Trying to get a sub-select to return a set of data that would then be passed into the stored procedure as a value that sproc is expecting a as a paremeter.

Any help is appreciated!!

declare @energy_code nvarchar(500)

set @energy_Code = (select distinct crcode from onetool..session s
	join cronline..vwActiveinc ai on
	s.contractorid = ai.contractorid
	where auditid = 67 and datecompleted is not null)

EXEC cronline..rpt_Energy @energy_code, 67, '2010, 2011'