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 |
|
sross81
Posting Yak Master
228 Posts |
 Posted - 2009-05-29 : 11:11:03
|
| Hello,I want to run this procedure but instead of passing in a the unique identifier for the 3rd parameters of provider id I want to be able to pull all providers. I tried passing in an '*' but that didn't work. Can you put a select provider_id from provider_mstr into an execute statment so that I can run it for all providers??EXEC ng_provider_approval_queue '00001', '0001', 'E66781E4-8EEC-49BA-AE05-010F2769D75E', 'P', 1, 1, 1, 1, 1, 'O'[ng_provider_approval_queue]( @pi_enterprise_id char(5), -- Enterprise ID @pi_practice_id char(4), -- Practice ID @pi_provider_id uniqueidentifier, -- Provider ID @pi_signoff_status char(1), -- 'P'ending / 'R'ejected @pi_use_documents_flag int, -- Use Documents: 1/0 (bit) @pi_use_notes_flag int, -- Use Notes: 1/0 (bit) @pi_use_images_flag int, -- Use Images: 1/0 (bit) @pi_use_ics_flag int, -- Use ICS: 1/0 (bit) @pi_use_labs_flag int, -- Use Labs: 1/0 (bit) @pi_provider_type char(1) -- 'E'ncounter / 'O'rThanks in Advance!Sherri |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-05-29 : 12:27:26
|
That needs to change the code of the SELECT that we cannot see.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
sross81
Posting Yak Master
228 Posts |
Posted - 2009-05-29 : 12:57:46
|
I am sorry I am confused as to what your asking me for. I believe that I need to write something that says:select provider_idfrom provider_mstr and then I could have like a list of the provider_id's and then I want to be able to pass this into the exec statement for the stored procedure instead of just passing one provider_id.quote:
Originally posted by webfred
That needs to change the code of the SELECT that we cannot see.
No, you're never too old to Yak'n'Roll if you're too young to die.
Thanks in Advance!Sherri |
|
|
|
sross81
Posting Yak Master
228 Posts |
Posted - 2009-05-29 : 13:07:04
|
Nevermind I figured out another way to do it. Thanks anyways. :)quote:
Originally posted by sross81
I am sorry I am confused as to what your asking me for. I believe that I need to write something that says:select provider_idfrom provider_mstr and then I could have like a list of the provider_id's and then I want to be able to pass this into the exec statement for the stored procedure instead of just passing one provider_id.quote:
Originally posted by webfred
That needs to change the code of the SELECT that we cannot see.
No, you're never too old to Yak'n'Roll if you're too young to die.
Thanks in Advance!Sherri
Thanks in Advance!Sherri |
|
|
|
|
|
|
|
|
Exec SP passing parameters