Execute stored proc question!

• Mh-397891

  SSCertifiable

  Points: 6704

  More actions

  August 14, 2008 at 2:44 pm

  #71805

  I have a simple question, I am trying to execute a storedproc the following way which has about 5 input parameters.

  SQL:

  Execute storedproc

  Select col1,col2,col3,col4,col5 from #Temp

  I am passing in col1,col2,col3,col4,col5 as parameters. I am getting the follow error:

  Msg 201, Level 16, State 4, Procedure storedproc, Line 0

  Procedure 'storedproc' expects parameter '@param1', which was not supplied.

  Thanks for your responses!!

• Lester Policarpio

  SSCertifiable

  Points: 7109

  More actions

  August 14, 2008 at 7:34 pm

  #858512

  Mh (8/14/2008)

  ---

  I have a simple question, I am trying to execute a storedproc the following way which has about 5 input parameters.

  SQL:

  Execute storedproc

  Select col1,col2,col3,col4,col5 from #Temp

  I am passing in col1,col2,col3,col4,col5 as parameters. I am getting the follow error:

  Msg 201, Level 16, State 4, Procedure storedproc, Line 0

  Procedure 'storedproc' expects parameter '@param1', which was not supplied.

  Thanks for your responses!!

  How many variables are declared in your store procedure? did you try using this ...

  EXECUTE storedproc col1,col2,col3,col4,col5

  "-=Still Learning=-"

  Lester Policarpio

• Sergiy

  SSC Guru

  Points: 110206

  More actions

  August 14, 2008 at 8:01 pm

  #858516

  Select @col1 = col1, @col2 = col2, @col3 = col3, @col4 = col4, @col5 = col5

  from #Temp

  Execute storedproc @col1, @col2, @col3, @col4, @col5

  But why not just use #Temp inside if that procedure?

  Use whole # table as a table-parameter.

  Whatever you insert into #Table before calling SP will be accessible from inside SP.

  _____________
  Code for TallyGenerator