I have a string which has paranthesis and comma, I have to input this to a stored procedure and forecast qty
Since i was not sure how to do that, i have 2 list of parameters one for part id and other for qty as you can see below.
I have created 2 temp tables where the value in the string gets parsed.
i would either like to know how to parse the string with both comma and paranthesis or if i can combine the two temp tables which has totally different datatypes
As per given example, this is how it can be done (I have used a function which would split the strings using cteTally table). But mind you that the function limitation is a string upto 8000 characters. If the string can be greater than that then you can use @Oleg 's solution mentioned in this [question]
Hi Can some one tell me the reason fr the following error? I use the above code and linked it to a stored procedure to use it in a crystal report. I get an error saying
Query Engine Error: 'ADO Error Code: 0x Source: Microsoft OLE DB Provider for SQL Server Description: Error Converting data type varchar to numeric. SQL State:22018 Native Error: '
Thank You So much for your help.
answered Jul 02, 2012 at 08:23 PM