array in sql server

• shobhitmishra

  Grasshopper

  Points: 13

  More actions

  September 24, 2008 at 12:39 am

  #194051

  hello sir,

  I want to use array in sql server 2000 but i don't know how tio impliment it.pls help me.

  thanks

  Shobhit Mishra

• Madhivanan-208264

  SSCertifiable

  Points: 7516

  More actions

  September 24, 2008 at 1:24 am

  #876151

  shobhitmishra (9/24/2008)

  ---

  hello sir,

  I want to use array in sql server 2000 but i don't know how tio impliment it.pls help me.

  thanks

  Shobhit Mishra

  Search for Array+SQL Server in google

  ---

  Madhivanan

  Failing to plan is Planning to fail

• Jeff Moden

  SSC Guru

  Points: 1004441

  More actions

  September 28, 2008 at 6:45 pm

  #878223

  Not sure what you mean, but if you want to pass an array to SQL, then the following article will help... covers passing of 1, 2, and 3 dimensional arrays...

  http://www.sqlservercentral.com/articles/T-SQL/63003/

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)