Truncate Question

Good day everyone

I have two SQL tables. One is a "Data" table in it with the days in the
dd/mm/yyy format.

Another "Time" table has the
dd/mm/yyy , Month, Quarter , Year in it.

I want to truncate the "Data" table but only where the Month is equal to
current month.
Rather than putting in a string "manually" I want the truncate statement to
pick up today’s date, look in the "Time" table, pick up the month that
current day belongs to and truncate all those days out of the "Data" table.

I've not even started so any ideas will be welcomed?

Thanks

Granville

Delete from SomeTable
Where
MONTH(Datecol) = MONTH(Getdate()) AND
YEAR(Datecol) = YEAR(Getdate())

??

--
HTH, Jens Suessmeyer.

---
<a rel="nofollow" style='text-decoration: none;' href="http://www.sqlserver2005.de" target="_blank">http://www.sqlserver2005.de</a>
---
"Granville" schrieb im Newsbeitrag

 > Good day everyone
 >
 > I have two SQL tables. One is a "Data" table in it with the days in the
 > dd/mm/yyy format.
 >
 > Another "Time" table has the
 > dd/mm/yyy , Month, Quarter , Year in it.
 >
 > I want to truncate the "Data" table but only where the Month is equal to
 > current month.
 > Rather than putting in a string "manually" I want the truncate statement
 > to
 > pick up today's date, look in the "Time" table, pick up the month that
 > current day belongs to and truncate all those days out of the "Data"
 > table.
 >
 > I've not even started so any ideas will be welcomed?
 >
 > Thanks
 >
 > Granville
 >