Cross database insert breaks auto-complete

StormRider · October 24, 2013 2:20PM

insert into [AnotherDB].dbo.summarytable
select * from SaleOrder so inner join SaleOrderDetail sod on ...

at this point SQLPrompt is unable to generate suggestions for the join condition, nor is it able to generate suggestions for the select fields.

cross database selects work just fine:
select * from [AnotherDB].dbo.summarytable s inner join SaleOrder so on ...

This generates a s.SaleOrderID = so.SaleOrderID suggestion.

SQL Prompt 6.1.0.72

Anu D · October 28, 2013 9:05AM

Thanks for your post. We have logged a support ticket for you and I will email you shortly.

KevinGreiner · October 31, 2013 10:28AM

I'm seeing a similar problem with a cross database SELECT. Expanding "SELECT a.*" with tab produces a list of fields that are completely unrelated to any joined tables. Expanding "SELECT *" works as expected. I did "refresh suggestion" to make sure I wasn't use a stale cache.

Object names are modified....

SELECT   Ref.&#91;AP21&#93;.&#91;AP_DRG&#93;,
        Ref.&#91;AP21&#93;.&#91;AP_DRG Desc&#93;,
        Ref.&#91;AP21&#93;.AP_MSC,
        Ref.&#91;AP21&#93;.&#91;AP_MDC DESC&#93;,
        Ref.&#91;AP21&#93;.ID
FROM    B.&#91;qCalc&#93; a
LEFT JOIN Dev_SafeCopy.B.&#91;qCalc&#93; b
    ON a.&#91;ICODE&#93; = b.&#91;ICODE&#93;
        AND a.&#91;CPAY&#93; = b.&#91;CPAY&#93;
        AND a.&#91;MAJOR&#93; = b.&#91;MAJOR&#93;

Aaron L · November 1, 2013 11:02AM

Hi Kevin,
Could you tell me if this build fixes the issue for you http://download.red-gate.com/EAP/SQLPro ... 1.0.82.exe ?

Thanks!

KevinGreiner · November 5, 2013 8:07AM

Yes, this build appears to fix the problem. Thanks so much!

Cross database insert breaks auto-complete

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk