Creating a stored procedure with infinite variable

• Jaw1977

  SSC Enthusiast

  Points: 166

  More actions

  November 20, 2001 at 3:31 pm

  #77812

  hi

  can anyone help.

  I am new to the SQL Server.

  I need to input data into a column with the PK (Primary Column) From other 2 tables

  I am using a stored procedure to store the data.

  Table1

  NameIDFirstName LastName

  1SamSmallwood

  Table2

  IDNamesofCD

  1CD1

  2CD2

  Table3

  NameIDID

  12

  11

  In Real time the Person Sam Smallwood will have more than 2 CD.

  In order to create the stored procedure i dont know how many variables to declare in the stored procedure.

  I like to know where there is a array datatype in SQL or tell me how to a create a stored procedure with infinite variables

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738347

  More actions

  November 20, 2001 at 7:19 pm

  #420256

  see other post

  Steve Jones

  steve@dkranch.net