3 Replies Latest reply: Oct 10, 2017 2:55 PM by Sunny Talwar RSS

    Range of values in scripting

    Eddy Van Eynde

      Hi,

       

      I have a question regarding range of values in scripting.

      In my script I do the following

       

      Load

         ....

         ....

      where [product-code] =  (29306)or(29307)or(29310)or(29388)or(29470)or(29471)or(29473)or(29474)or(29476)or(29479)

       

      With this I have my selection, but it seems not so good for the performance

       

      Before I used the following, I didn't receive a syntax error, but I was missing data

       

      Where [product code] = (29306,29307, 29310,...) 

       

      So think the first syntax is right but maybe it can be different for better performance

       

       

      Best regards,