Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
akpaga
Constraint Violating Yak Guru
331 Posts |
 Posted - 2009-11-01 : 20:45:17
|
| hi i have a table called customersit has fields called customer id identity,customer name,customerdate.i want write a stored procedure where when user enters datefrom and datetoi want to insert records in the customer table in the following way say if datefrom is 10/25/2009 and dateto is 10/28/20091 record -1,customername,10/25/20092 record-2,customername,10/26/20093 record-3,customername,10/27/20094 record-4,customername,10/28/2009i.e 4 records since 10/25/2009 - 10/28/2009 is 4 dayshow can i achieve this .thanks in adavance.... |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-11-01 : 20:52:27
|
make use of the F_TABLE_DATE
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
insert multiple records based on date difference