actually I was looking for

eg: when we search for books in amazon one drop box will ask for with24hrs, last week, last month, last year, I want the date...

thanks got the error. cheers..

one more question i want to select a record of 2012-05-20 date how to teh code for dateadd()

insert into fuel.dbo.Dispenser_pump_mapping (dispenser)

select Dispenser from Wetstock_Reporting.dbo.Dispenser_Pump_Mapping

from the above query how to put default value for simmons_id

ALRIGTH ,

actually first database I reduced the database tables size using ER now I want to insert that data into respective columns from that respective column tables

cheers

Dispenser_pump_mapping TABLE:

create table Dispenser_pump_mapping

(

dis_pump_map_id int IDENTITY,

simmons_id int not null,

dispenser int primary key ,

fp int not null,

nozzle int not null,

tank_id int foreign key (tank_id) references

Tank(tank_id)

)