SQL Query Syntax

November 19, 2008 03:01am pst

635 organizations, including eBay, Ericsson and Lockheed Martin, now work smarter with Corporate Accounts. Save up to 42%

Welcome! If you have any general questions about Experts Exchange, feel free to ask me.

Loading Advertisement...

	[x] Neglected Question
	Neglected questions are any questions that either have not yet been addressed by an expert, or a solution has not been awarded, and may be eligible for bonus points (see your profile page for details).

	Title	Zone	Views
1	Convert datetime field to a long date string	SQL Syntax	600
2	bit Column - Default Value of ((0))	SQL Syntax	465
3	Need help joining two columns from two tables, union query?	SQL Syntax	465
4	PHP MYSQL LOAD DATA INFILE	SQL Syntax	448
5	TSQL difficulties IIF in SELECT clause if DateDiff	SQL Syntax	383
6	SQL query: Remove Leading zeroes from field	SQL Syntax	339
7	sql server stored procedure while loop	SQL Syntax	302
8	Help with Building Query (MS Access 2007 / SQL)	SQL Syntax	295
9	Calculating Working Days - Oracle Sql	SQL Syntax	291
10	Add and subtract years from DATETIME	SQL Syntax	289

	Title	Zone	Views
1	UPDATE with INNER JOIN SQL Server	SQL Syntax	3013
2	Nested CASE/IF statements in MS SQL Server 2000	SQL Syntax	2116
3	VBA/Excel SQL Query	SQL Syntax	1541
4	SQL UPDATE statement for multiple rows, multiple columns	SQL Syntax	1482
5	How to get row number in sql?	SQL Syntax	1455
6	Calculating number of working days between two dates	SQL Syntax	1240
7	Insert date into SQL Server 2005 Table	SQL Syntax	1165
8	Create Autonumber in QUERY not TABLE in Microsoft Access	SQL Syntax	1146
9	Removing decimal places from a number SQL Server 2000	SQL Syntax	1082
10	Converting integer to string as expression for concatenation	SQL Syntax	842

	Date	Points	Title	Comments
1	11/19/2008	500	Simple Gridview Update query on accessdatasource not working	0
2	11/19/2008	500	How to execute a stored sql-command in VBA	0
3	11/19/2008	500	How to create a query to include a "X" in the expression field when a field in t…	2
4	11/18/2008	500	Querying dynamic file name base on field content.	1
5	11/18/2008	250	SQL Statement for checking items in field with many IDs (seperated by comma)	2
6	11/18/2008	250	Replicate a field based on unjoined tables	1
7	11/18/2008	500	5 table join returns way too many rows, DISTINCT not working either and DISTI…	2
8	11/18/2008	250	Using Like to Filter Postcodes from a Seperate Table of Partial Postcodes	2
9	11/18/2008	500	sql transaction not catching truncating error	6
10	11/18/2008	125	How can I pivot a table without using an aggregate function	3