Problem: Table does not have primary key
SELECT OpportunityName, CGN.* FROM FWB_SFAccountAndContractGroupName CGN INNER JOIN dbo.FWB_ufn_GetOpportunity(8047) OPP ON CGN.OpportunityID = OPP.OpportunityID
CGN
SELECT OpportunityName, CGN.* FROM FWB_SFAccountAndContractGroupName CGN INNER JOIN dbo.FWB_ufn_GetOpportunity(8047) OPP ON CGN.OpportunityID = OPP.OpportunityID ORDER BY CGN.COLUMN_NAME DESC
SELECT OpportunityName, CGN.* FROM FWB_SFAccountAndContractGroupName CGN INNER JOIN dbo.FWB_ufn_GetOpportunity(8047) OPP ON CGN.OpportunityID = OPP.OpportunityID ORDER BY CGN.COLUMN_NAME desc
order by CGN.date desc
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)