Unanswered: Dropping and re-adding characters on a variable.
I've searched the forum and haven't really found anything to address my issue and with all the great advice I've gotten before I tought I would give it a shot and see if someone can point me in the right direction.
I need to create a stored procedure that uses a variable to define what table data will be pulled from but the first two characters have to be dropped to pull the actual data and then re-assembled to populate another table.
I tought a Temp table would work well but have no idea how to remove the first two characters from the variable and the re-add them in the temp table.
The following stored procedure works from data retrival but the actual variable will have either a SF or SI prefix that is used to define the different tables.