I have a column in MS access that contains whole numbers and decimals. How do I filter out the rows that cotain decimals and just keep the entries with just whole numbers. RawData 1 2.5 5 6.5 1.3 7 I want the query output to show: 1 5 7

Hi EE, I have a product inventory database built in Access 2007. It consists of a single table with a barcode, destination and a date sent. I scan barcodes into a continuous form and execute a SQL query that populates the inventory list with a destination I enter in a text box and the current date where...

We recently (days) migrated from dev servers to new production servers. Everything is supposed to be duplicated. I am getting errors that I was not getting on the dev servers. on the following query I am getting "invalid precision value"; result="query"> SELECT * FROM CallData...

Hi all, I suspect the following sproc could be cleaned up a lot but I just don't see it right now. My main area I wish to clean up is in the various select statements as each of them uses the same From... inner join... Where clauses. thx in advance. Code Snippet: 1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11...

Hi all, I suspect the following sproc could be cleaned up a lot but I just don't see it right now. My main area I wish to clean up is in the various select statements as each of them uses the same From... inner join... Where clauses. thx in advance. Code Snippet: 1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11...

Hi all, I suspect the following sproc could be cleaned up a lot but I just don't see it right now. My main area I wish to clean up is in the various select statements as each of them uses the same From... inner join... Where clauses. thx in advance. Code Snippet: 1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11...

I require a SQL Script or some other method for finding out which databases in a SQL Server are the "least" active (or completley dormant). I.e. my problem is that I have a number of databases left over after a few SharePoint installs (which are now long gone) all with cryptic serialized database...

In my illustration you'll see I have a table and the expect query results. In order to accomplish this in not one query, as opposed to writing two or three queries to get the expect result, I expect I probably need to utilize the MIN and MAX functions and write a sub query in the select statement...

I'm trying to figure out ASP.NET. Using IIS6 and SQL 2000 database (not MSDE). I have the following web.config file in the root of the web site, 1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: yet I'm continually presented with the error: Server Error in '/' Application. -------------------------...

as the title says reason for asking this comment below accepted answer http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_26228454.html