Skip to Content
0

sql script - join issue

Dec 16, 2016 at 09:51 AM

79

avatar image
Former Member

Hi,

In script I use sql code - update, and in one of my join I faced issue - I'd like to join to ID:
A.ProductID = B.Product ID

In Management Studio (mssql) the code works: A.ProductID = B.[Product ID] but in BODS I get error, I tried: A.ProductID = /'B.Product ID/' and valid doesn't show error but script do nothing :)

In Management Studio I can use this query A.ProductID = B.[Product ID] and it works fine

Regards

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Dec 16, 2016 at 10:35 AM
0

Hello Rad,

I think we don't have to guess the exact error you are having, so in order to receive good advice on this error, please provide some screenshots or paste the exact script you are using in both SQL MS and BODS.

Regards,

Bogdan

Share
10 |10000 characters needed characters left characters exceeded
Akhilesh Kiran Dec 20, 2016 at 09:30 AM
0

Hi Rad Nap,


I suggest you to use the print function a check the output how it is generating. you removed [] for product id. I suggest you to please you the [] in the script and escape the [].

A.ProductID = B.\[Product ID\]

Regards,
Akhilesh Kiran.

Share
10 |10000 characters needed characters left characters exceeded