<div>
declare @tmp datetime<br />
<br />
set @tmp = '02/12/2009'<br />
<br />
while @tmp &lt;= '01/01/2010'<br />
begin<br />
&nbsp; &nbsp;insert into yourTable(DateFund, MaxValue)<br />
&nbsp; &nbsp;values &nbsp;(@tmp, 0)<br />
&nbsp; &nbsp;<br />
&nbsp; &nbsp;set @tmp = dateadd(day, @tmp, 1)<br />
end<br />
<br />

</div>


declare @tmp datetime

set @tmp = '02/12/2009'

while @tmp <= '01/01/2010'
begin
   insert into yourTable(DateFund, MaxValue)
   values  (@tmp, 0)
   
   set @tmp = dateadd(day, @tmp, 1)
end



<div>
<div class="content wysiwyg-content">
What is the best way to do this?<br />
<br />
Have a table tblMax &nbsp;with DateFund and Maxvalue fields.<br />
<br />
Need to fill that table with range of dates from 02/12/2009 - 01/01/2010<br />
<br />
DateFund &nbsp; &nbsp; &nbsp; &nbsp;MaxValue<br />
02/12/2009 &nbsp; &nbsp; 0<br />
02/13/2009 &nbsp; &nbsp; 0<br />
etc<br />
<br />
I guess it would be some For Loop in SQL Analizer or Stored Procedure.<br />
<br />
Can anyone write me a quick simple code for it?<br />
<br />
Thanks
</div>
</div>


What is the best way to do this?

Have a table tblMax  with DateFund and Maxvalue fields.

Need to fill that table with range of dates from 02/12/2009 - 01/01/2010

DateFund        MaxValue
02/12/2009     0
02/13/2009     0
etc

I guess it would be some For Loop in SQL Analizer or Stored Procedure.

Can anyone write me a quick simple code for it?

Thanks

SQL 2000 - for Loop to insert a range of dates and values at once

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.