Clearing Change Log Entries

Question

Post reply

Clearing Change Log Entries

Spectacle

Grasshopper

Points: 18
More actions
January 7, 2010 at 9:29 am

#214323

Comments posted to this topic are about the item Clearing Change Log Entries

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

antony-688446 Ten Centuries Points: 1221 More actions · Answer 1

Alternatively, replace all the date calc code with:

select @qdt=dateadd(m,-1,dateadd(d,datediff(d,'1 Jan 1900',getdate()),'1 Jan 1900')-datepart(d,getdate())+1)

This returns the first day of the previous month, 12:00 am, as does the given script.

An explanation of what the code was doing would have been nice, rather than having to work it out. However, the majority is not needed as SQL provides all the necessary functions for doing date calcs...