asked
Deleting blank rows from sql server 2005 table.
I have a table named BatchHistory which has about 3500 entries. I could not sort it datewise although it has columns for start date and end date but still the "select" query for sort does not work for the latest 2013 entries. So, I have made another table named CHistory and manually copy pasted the 2013 entries in that table through ctrl+c and ctrl+v, but problem is that, it hasnt copied a lot of rows from BatchHistory through this method a red icon appears while pasting, and some blank rows are also copied which I am unable to delete, it gives error unable to delete. Please help as it does not read any data after a blank row in the CHistory table.
First off, stop using whatever GUI it is that you're using to manipulate the data. Go to T-SQL. That's the language you need to master to properly control SQL Server. When you say the sort doesn't work, you need to look at the statement ORDER BY and then provide the correct column. You can put it into an ascending or descending mode by adding ASC or DSC after the column name. That always works. If it's not working how you expect, you need to look to your data. To delete 'blank' rows, you can use a delete statement that looks for NULL values in a column. But, from the sounds of things, the values may not be NULL but might be empty strings. In this case you can try searching for values that equal ''. That's two single quote marks together, showing an empty string.
Are you trying to do all that in the SSMS GUI without issuing the appropriate T-SQL commands yourself? That's a sure-fire way to disaster. The GUI was not designed for this sort of activity. What are you using? How are you trying to do this? Tell us more, then we can tell you what's wrong and how to fix it.
13 People are following this question.
