Thanks a lot guys, it worked perfectly.

Only one question after the deleting the reserved space did not go down, it was the same as before any reason for that?

New data will inserted every day so, we would want to keep only 2 weeks worth of data. Hence we would want to implement something recursive which will delete on...

Yes a delete would fill up the logs.

Right now the older data is deleted but going further we would to put in a practice which will delete data which gets...

There are 2.2 billion records in the table and we want to only keep 2 weeks data, as of now we are lagging behind so we want to delete data...

The log file fills up if i am using the query. (Database is in Simple Recovery). Any ideas?