Home Forums SQL Server 7,2000 General Adress interval into multiple records RE: Adress interval into multiple records

  • December 21, 2004 at 7:24 am

    #534608

    create your new table (I'm assuming you know how to do that).

    insert into tNewTableName

    (ID, roadname, house_number)

    select ID, roadname, house_number_start

    union

    select ID, roadname, house_number_end

     

    If the phone doesn't ring...It's me.