i have a SQL 2005 server and i only know my way around the SQL server management studio. i have a table in a database that i right click on and choose "open table" and then i can see the data in that table. my goal is that i need to remove data that was create today ( 3/31 ) , i think if i highlight the entire table, then right click and choose, pane, and criteria - it looks like i can choose how to sort the table. then in the sort type column i have to right click and choose, pane, and criteria - then i can choose ascending, the next column is sort order and i only have 1 or unsorted as choices - i assume i choose 1. then the next column is group by - and it has to be count or count_big - so i choose count ( ? don't know if that is right ) - then there is a filter column - so i thought this is where i could put the column header that i want to sort ( ascending ) by. the column header i want to sort by is called DateCreated, i tried this but i get an error when i click on execute sql - ( i'm assuming i click on execute sql because i don't see anything else to click on.
so - does the above look like how i would sort my table by ascending date? or am i way off.