no columns suggested

con tractorcon tractor Posts: 5 Bronze 2
edited November 15, 2007 5:58AM in SQL Prompt Previous Versions
the following does not give any suggestions V.3.6.0.109

SELECT
d.DealCode AS [DealNumberTradeID]
,cty.cif AS [CIFofCounterparty]
,bu.<CURSOR>

FROM
deal d
INNER JOIN [dbo].[counterparty] cty ON cty.counterpartyid = d.counterpartyid

LEFT OUTER JOIN dbo.[businessunit] bu ON bu.businessunitid = cty.businessunitid[/b]
SSIS is the worst product ever
· Share on Twitter

Comments

Sign In or Register to comment.