It may seem weird, but i came across this. i have a stored procedure written which takes isource_db as input, Eg: UAT_GCFR_VIEW.XYZ
Now Ahead in the Stored Procedure, i need to execute select statement like (eg.) : SELECT * FROM DEV_GCFR_VIEW.XYZ However, I want to replace the DEV with UAT(i.e whatever given by user in iSource_db variable.
Guys, can you please Help me out on this?