|
|
Browse by Tags
- 10g
- 2000
- 2003
- 2005
- 2008
- access
- AS400
- asp
- backup
- between
- C#
- case
- change
- column
- command
- connect
- connection
- convert
- count
- create
- crystal
- data
- database
- date
- datetime
- db2
- delete
- dts
- dynamic
- error
- excel
- export
- express
- field
- file
- format
- from
- function
- get
- group
- how
- import
- insert
- job
- join
- loader
- log
- Microsoft
- ms
- MS Access
- mssql
- multiple
- mysql
- null
- number
- odbc
- oracle
- parameter
- php
- PL/SQL
- procedure
- query
- RDBMS
- record
- records
- report
- reporting
- restore
- row
- rows
- script
- select
- server
- services
- sharepoint
- SQL Query
- SQL Server
- SQL Server 2005
- SSIS
- ssrs
- statement
- stored
- string
- sum
- sybase
- syntax
- table
- tables
- text
- time
- trigger
- T-SQL
- two
- update
- user
- value
- variable
- VBA
- view
- windows
-
How to use Filter out decimal using a query in access
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 -
Delete a list of IDs in access table
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... -
Calculate Average in SQL statement
I need to calculate a players batting average based on a couple of columns in a SQL 2005 database table. I need to be able to do this calculation in a SQL statement because I am populating a grid with the results of the avg and the other columns in the table. For the sake of this example I need to do... -
*** Querying for MONTH to DATE in SQL ***
Hello Experts, This is probably an easy one for you all... I'd like to add code to my SQL that, when executed, the results will always be from MONTH to DATE... that is, only pull data from the beginning of the current month going forward. something like this... SELECT current_month, count(orders... -
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Microsoft OLE DB Provider for SQL Server error '80004005'
Hi All, The database in SQL Server2000 is working on IIS6.0 in Windows Serverin Production. My development machine has Windows XP/IIS 5.0 and is using the same SQL server Database. I have to transfer 6000 records from one table to another.I am adding these records into new table and updating 2 columns... -
sql Invalid precision value
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... -
SQL Insert using both select statements and parameters
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... -
How to identify inactive SQL Databases
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... -
Sub Query in Select Statement
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... -
Convert MySQL Timestamp to Date
I have a column which currently has a date column that has a data type of TIMESTAMP. I need to convert this to a DATE data type. I have tried this: 1: SELECT UNIX_TIMESTAMP(DATE_FORMAT(_created,'%Y-%m-%d %T')) FROM table LIMIT 1; But the returned row is just 0.