Girish Talluru Variable manipulation in stored procedure
Feb 12, 2013; 12:03
Girish Talluru
Variable manipulation in stored procedure
Hi All,
I have a variable in stored procedure named Project_Number and it is of varchar type.
My Requirement is "for each project number query the table project_Number_List get results from list and insert into other table"
Lets say, Project_Number might be like this 22,21,34,43,434 corresponding tables I need to query is something like this 22_List, 21_List,34_List .....
I'm using cursor to loop through the Project_Number but my problem is how to mix the project_number and _list i.e., 22_list to query the table 22_List
Any suggestions?
Thanks, Girish Talluru
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!