News and Announcements icon

Dynamics 365 CommunityForums Finance forum How to resove the erro...

Finance forum

Suggested answer

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

(1) Share

Report

Report

Posted on by Community member

9

Categories:

Financial Management

All responses Img

All responses (5)

Answers Img

Answers (0)

Waed Ayyad 3,904 on at

Like (0)

Report

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 1,257 on at

Like (0)

Report

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 2,897 on at

Like (0)

Report

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

Community member 2 on at

Like (0)

Report

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 1,257 on at

Like (0)

Report

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

Leaderboard

#1

André Arnaud de Cal... 288,768 Super User

#2

Martin Dráb 225,985 Super User

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans