1) In my procedure i am passing table name (str_sourcetable ) as in parameter 2) Then i need to take the record count from that table (str_sourcetable ) 3) This record count should be the field value for another table (Cfstagedev.Table_Test_automation) which is having only one filed 4)I heard that we can not use select statement in dynamic SQL IS it correct , if so what should be the alternative I heard that alternative is Volatile tables. So what is a volatile table , how can I implement those inside my procedure 5) There may be other mistakes in my procedure .
As it is a urgent requirement for me , please provide me a correct procedure which will fullfill my requiement and syntatically correct. Help me out with correct solution
Procedure : -------------------------
Replace Procedure CFSysSPDev.AutomatedPassthruValidation(In str_sourcetable varchar(2000) ) BEGIN