If @resultSet < 1
	Begin
		FROM TAB_ccsNetDM AS A 
	End

Else
	Begin
		FROM #result_set  inner join TAB_DM AS A on #result_set.dmid=A.DMID
	End
	

SET @SQL = 	'SELECT  DISTINCT A.ProgID,' + @SQLField + 'F.Contractno,A.ProjID, A.ContractID, A.DMNo, A.DMTypeID, A.DMID,
								  A.Agency, A.DMTitle, A.Deleted
		FROM #result_set  inner join TAB_DM AS A on #result_set.dmid=A.DMID
		JOIN TAB_UserAccess AS B ON (A.ProgID = B.ProgID AND A.ProjID = B.ProjID AND A.ContractID = B.ContractID) 
		Left Outer Join TAB_Contracts F ON A.ContractID = F.ContractID  ' + @SQLJOIN