How can I extract all numbers between two limits using a query

• sanuj

  SSC-Addicted

  Points: 438

  More actions

  May 28, 2008 at 5:10 am

  #186152

  Need Help !!!!!!!

  How can I extract all numbers between two limits using a query

  eg :

  my table HouseDetails

  AgentID FromNumber ToNumber

  1 11 16

  2 20 24

  1 20 22

  For AgentID 1, It should return 11,12,13,14,15,16,20,21,22

  AgentID 2, It should return 20,21,22,23,24

  Is it possible ? Anybody ...!!!

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  May 28, 2008 at 6:08 am

  #821119

  Please don't cross-post.

• SwePeso

  SSC-Dedicated

  Points: 39757

  More actions

  May 28, 2008 at 6:45 am

  #821134

  http://www.sqlservercentral.com/Forums/Topic507555-145-1.aspx

  ---

  N 56°04'39.16"
  E 12°55'05.25"