Truncate Statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Granville - 13 Jun 2005 15:00 GMT

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

Reply to this Message

Michael C# - 13 Jun 2005 19:19 GMT

... WHERE DatePart(month, [date_column]) = DatePart(month, GetDate())
or
... WHERE DatePart(month, [date_column]) = DatePart(month,
Current_Timestamp)

> Good day everyone
>
[quoted text clipped - 17 lines]
>
> Granville

Reply to this Message

Michael C# - 13 Jun 2005 19:23 GMT

FYI, it will be a little more complex than this since you want to reference
the dates from another column in another table, but the general idea is use
the DatePart(month, ...) to get the month out of a date. Thanks.

> ... WHERE DatePart(month, [date_column]) = DatePart(month, GetDate())
> or
[quoted text clipped - 22 lines]
>>
>> Granville

Reply to this Message