Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-02 : 16:09:44
|
Jeff writes "I am trying to do several things. I need to write a dynamic sql statement that accepts an input during runtime from the keyboard, accepting say an ID. Then what needs to happen is a check to see if that ID exisits, then if so, retrieve a corresponding feild, say id_Name from the table.
The next step would be to see if that id_name feild matches a prime_id_name from another table. and if the answer is yes then get all the IDs from that table from a cost_period = 2000.
Does this make sense....I am in dire need of assistance. The Procedure has to be dynamic though....not a simple accept command with a prompt???
I am so so lost here...
Help me please....." |
|
|
|
|
|
Dynamic SQL