Skip to Content
avatar image
Former Member

sql script - join issue

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 20, 2016 at 09:30 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded