Skip to main content
Dynamics 365 Community / Forums / Finance forum / How to resove the erro...
Finance forum
Suggested answer

How to resove the errors shown in SSMS(Sql Server Management studio).

editSubscribe (1) ShareShare
ReportReport
Posted on by 9

//

Attachments
  • Waed Ayyad Profile Picture
    Waed Ayyad 1,996 on at
    How to resove the errors shown in SSMS(Sql Server Management studio).
    Hi Community member,
     
    What is ivc? Does it refer to Table?
     
    Thanks,
    Waed Ayyad
  • Suggested answer
    Anthony Blake Profile Picture
    Anthony Blake 756 on at
    How to resove the errors shown in SSMS(Sql Server Management studio).
    Your comment says "-- sub query 1" so i suspect whichever script you copied this from has "ivc" defined somewhere in the outer query
  • Suggested answer
    MuthukumaranAX Profile Picture
    MuthukumaranAX 2,893 on at
    How to resove the errors shown in SSMS(Sql Server Management studio).
    1. you can hardcode the contract number instead of "ivc.IndivOrChgCmplContrNumber" OR
    2. you need join the table form where you are expecting the value of  "ivc.IndivOrChgCmplContrNumber"
  • Suggested answer
    How to resove the errors shown in SSMS(Sql Server Management studio).
    Could you please how to extend the query to include a table called "ivc"
  • Suggested answer
    Anthony Blake Profile Picture
    Anthony Blake 756 on at
    How to resove the errors shown in SSMS(Sql Server Management studio).
    You haven't declared "ivc", so SQL interpreter doesn't know which table you want that value to come from.
     
    replace that with a fixed value, or extend the query to include a table called "ivc".

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,126 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,646 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans