Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Deleting Oldest Date

Author  Topic 

wsilage
Yak Posting Veteran

82 Posts

Posted - 2014-09-17 : 14:11:45
I have a table that I need to delete the oldest date. I thought I could just do an update statement saying...

Delete T_BreakDown
where Date = MIN(Date)

But that doesn't work.

Any suggestion, would be great!

Thanks

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2014-09-17 : 14:18:23
[code];WITH cte AS
( SELECT TOP (1) * FROM T_BreakDown ORDER BY Date)
DELETE cte;[/code]
Go to Top of Page

wsilage
Yak Posting Veteran

82 Posts

Posted - 2014-09-17 : 14:55:15
When I did this



;WITH cte AS
( SELECT TOP (2) * FROM T_AXA_BreakDown_Claims_2 ORDER BY [Todays Date])
DELETE T_AXA_BreakDown_Claims_2;


It deleted everything in my test file (which is okay), but how do I do it so it only take my earliest date?

Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2014-09-17 : 16:12:43
quote:
Originally posted by wsilage

When I did this



;WITH cte AS
( SELECT TOP (2) * FROM T_AXA_BreakDown_Claims_2 ORDER BY [Todays Date])
DELETE T_AXA_BreakDown_Claims_2 cte;


It deleted everything in my test file (which is okay), but how do I do it so it only take my earliest date?



Go to Top of Page

wsilage
Yak Posting Veteran

82 Posts

Posted - 2014-09-18 : 09:36:11
Thank you so much this helped me out a lot!
Go to Top of Page
   

- Advertisement -