How to delete the first 5900 NULL rows in SQL Server

Question

I imported and excel sheet in SQL Server named DimTime and the date is not in the proper order from 2005 to 2025. So I had to use

select * from dbo.DimTime 
order by Date.

The results present that the first 5900 rows are NULL and the following are in proper date order starting from 2005 to 2025.

But when I use this simple query, it doesnt work.

delete top (5900) from dbo.DimTime
order by Date

Thanks!

Beau

Answered already: http://stackoverflow.com/questions/8955897/how-to-delete-the-top-1000-rows-from-a-table-using-sql-server-2008 — so13eit, Oct 08 '13 at 13:54
What do you mean doesn't work. Do you get an error, or just no rows deleted? — Ben Drury, Oct 08 '13 at 14:11

score 2 · Accepted Answer · answered Oct 08 '13 at 13:54

2

You could use:

DELETE FROM dbo.DimTime
WHERE col IS NULL

Presuming all NULL rows need to go.

answered Oct 08 '13 at 13:54

Danny Beckett

1 Answers1