table_size

• mvssrikanth1

  SSC-Addicted

  Points: 463

  More actions

  May 9, 2008 at 7:01 am

  #123896

  hai!

  I have to create a table with a fixed number of rows i.e. a table with n number of rows.how to do it?

  thanks in advance,

  srikanth

• RyanRandall

  SSChampion

  Points: 13623

  More actions

  May 9, 2008 at 7:08 am

  #813011

  Looks like another use for the 'tally' table...

  http://www.sqlservercentral.com/articles/TSQL/62867/

  Ryan Randall

  Solutions are easy. Understanding the problem, now, that's the hard part.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736494

  More actions

  May 9, 2008 at 9:40 am

  #813165

  Maybe you could give us more details about what this is?

• Jeff Moden

  SSC Guru

  Points: 1004414

  More actions

  May 9, 2008 at 6:19 pm

  #813415

  RyanRandall (5/9/2008)

  ---

  Looks like another use for the 'tally' table...

  http://www.sqlservercentral.com/articles/TSQL/62867/

  Spot on... 😛

  --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)