Ms sql sever using dynamic stored procedure.

chidurala anil

7y824

1st table i have created Employeetable with column Id,Name,Designation,Salary.

2nd table Keytemplate with column Keyname,Query.values Id_key,Name_key,Desig_key,Salary_key.It should search the key name and execute query.That keyname value print in another table.

3rd table documenttable.with column paragraph .

value "Dear [Name_key],you are doing well in your [Desig_key]" .

4th table documenttableoutput -it should reflect the message with data.

value "Dear Rama,you are doing well in your Developer" .

thanks

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
Hi,
Please refer the below link, it might helps you
http://www.sqlservertutorial.net/sql-server-stored-procedures/sql-server-dynamic-sql/
Sourav Mukherjee7y ago
This question appears v confusing. Can you please form a table with the columns and rewrite your question? Might be useful to answer
Laxmidhar Sahoo7y ago
hi chidurala anil

@Suraj is saying correct.Please clearify your question .Perhaps you need to creatre a stored procedure to take 4 tables and retrive some columns with joining.
for joining you have to take reference colums(forgein key) and primary key
Suraj Kumar7y ago
your query is not very clear can you edit your question for better understanding so someone can help you.

Regards
Suraj