CREATE PROCEDURE [dbo].[Usp_GetCtrFundingSources]
		@contractid		int
 AS

DECLARE @ElementID	Int

DECLARE @CUR_TEMP CURSOR

SET @CUR_TEMP = CURSOR SCROLL FOR (select distinct(element_id) from tab_ccsnetelementcontracts where contractid=@contractid)

CREATE TABLE #TEMP
(
efundid              INT,
fundid                INT,
fund_source	nvarchar(100)
)


OPEN @CUR_TEMP

FETCH FIRST FROM @CUR_TEMP INTO @ElementID
WHILE @@FETCH_STATUS = 0
BEGIN
	 insert into #TEMP(efundid,fundid,fund_source) select efund.efund_id,efund.fundid, fndsrc.fund_source from Tab_ccsNetEfund efund 
	inner join Tab_ccsNetFundSource fndsrc on efund.fundid = fndsrc.fundid
	where efund.element_id=@ElementID

	FETCH NEXT FROM @CUR_TEMP INTO @ElementID
 End

Close @CUR_TEMP

Deallocate @CUR_TEMP

	 insert into #TEMP(efundid,fundid,fund_source) select efund.efund_id,efund.fundid, fndsrc.fund_source from Tab_ccsNetEfund efund 
	inner join Tab_ccsNetFundSource fndsrc on efund.fundid = fndsrc.fundid
	where efund.element_id=@ElementID
 
select efundid,fundid,fund_source from #TEMP

Drop table #TEMP