i want to insert number into num_ber table from march_20121

linto series

like this

12671

12672

12673

12674

12675

12676

12677

12678

12679

12571

12572

12573

12574

12575

12576

12577

12578

12579

--pls help me now !!!

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[march_20121]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[march_2012]

GO

CREATE TABLE [dbo].[march_20121] (

...

i want to insert values in number tables from march_2012 from first in to last in in series

1

2

3

4

in march tables can have many first in and last in

help me if...

thx alot cheers!

thx alot it working on 2005

can you give me coords on sql server 2000.,,if you don't mind

sorry :

it's not working on sql server 2000

if you don't mind..can you tell me how it work!!

thx in advance

ok

is it will work on sql server

i want to pick values from database