How can we help you today? How can we help you today?

no columns suggested

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]
con tractor
0

Comments

4 comments

Sort by
  • Eddie D
    Sorry for the delay in replying to your post.

    Can you please check to see if this is a caching issue:

    In your query editor, select the SQL Prompt menu->Refresh Cache or press the following keys together Ctrl+Shift+D.

    Many Thanks
    Eddie

    Eddie Davis
    Red Gate Software Ltd
    Technical Support Engineer
    e-mail: support@red-gate.com
    Eddie D
    0
  • con tractor
    First thing I tried. Makes no difference.
    con tractor
    0
  • Tom Harris
    Hello,

    I'm really sorry that you have run into problems. All the developers are out attending Tech Ed in Barcelona this week. I will try and find someone to investigate once we are back in the office on Monday.

    Please accept my apologies,

    Tom Harris
    Head of Development
    Red Gate Software
    Tom Harris
    0
  • con tractor
    It is not working as advertised.
    con tractor
    0

Add comment

Please sign in to leave a comment.