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

Please Fix

This is just one example.. the intellisense does not work with the SC variable inside a Sub-Query

SELECT SC.SnomedID ,
       SC.SnomedCode AS [Code] ,
       6 AS [CodeSystem_ID] ,
       SC.SnomedDescription AS [DisplayName]
FROM   DataCenter.ref.SnomedCode AS SC
WHERE  EXISTS ( SELECT *
                FROM   DataCenter.der.fn_LoadPatientsByRequestID(3, 25) AS P
                       
                WHERE  EXISTS ( SELECT *
                                FROM   DataCenter.dbo.TobaccoUseStatus AS TUS
                                WHERE  TUS.DataCenterID = P.DataCenterID
AND TUS.CurrentStatus_ID = SC.Sn));
MikeO
0

Comments

2 comments

Sort by
  • Tianjiao_Li
    Hi @MikeO

    Thanks for reporting this issue!

    We have it logged as SP-7109, so please keep an eye on the release note!

    Our apologies for the inconvenience caused.
    Tianjiao_Li
    0
  • Tianjiao_Li
    Hi @MikeO

    Please upgrade to the latest version (9.2.1.5713) which has the fix for this issue!
    Tianjiao_Li
    0

Add comment

Please sign in to leave a comment.