Model Database

Technical Article

RE: Delete from Where - Older than 60 days...

  • Reply

If you don't have to worry about the time when the statement is ran (if this is run at 11:20am, it will delete everything older than 60 days ago at 11:20am) you can use:delete from TABLE where DATEFIELD < getdate() - 60However, if you want to delete everything before the start of the day (60 days […]

You rated this post out of 5. Change rating

2004-07-09

2 reads

Technical Article

RE: Vertical data to Horizontal

  • Reply

When you are stuck in a situation like that, choose to do the simplest stored procedure you can, returning the data to ASP, then using procedural code to format it. It will give you the most flexibility in the case where you need to make changes to the display of the report later (and they […]

You rated this post out of 5. Change rating

2003-07-25

Blogs

SQL Saturday Boston 2024 Slides

By

Thanks to everyone that came to my talks. Slides are below. Best Practices for...

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers