SQL Query Syntax

January 8, 2009 02:08pm pst

900 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 date format in DB2 SQL	SQL Syntax	592
2	copy data from one column to another column of table, pl/sql	SQL Syntax	543
3	how to alter column name in access 2000 table using sql and vb6.0	SQL Syntax	471
4	Remove first 5 and last 6 characters of string	SQL Syntax	414
5	Concatenate multiple rows	SQL Syntax	293
6	SQL: Delete query using a join	SQL Syntax	277
7	Nested Select, Union or Join??? SQL Help!	SQL Syntax	244
8	How to check if a column exists in a tablle	SQL Syntax	236
9	how to convert textbox input to double type in c#	SQL Syntax	227
10	select top 1 count(*) returning count of more than one record?	SQL Syntax	223

	Title	Zone	Views
1	UPDATE with INNER JOIN SQL Server	SQL Syntax	3008
2	Nested CASE/IF statements in MS SQL Server 2000	SQL Syntax	1689
3	VBA/Excel SQL Query	SQL Syntax	1377
4	How to get row number in sql?	SQL Syntax	1313
5	Insert date into SQL Server 2005 Table	SQL Syntax	1183
6	SQL UPDATE statement for multiple rows, multiple columns	SQL Syntax	1097
7	Calculating number of working days between two dates	SQL Syntax	960
8	Create Autonumber in QUERY not TABLE in Microsoft Access	SQL Syntax	954
9	Removing decimal places from a number SQL Server 2000	SQL Syntax	834
10	Case Statement for MS Access Query	SQL Syntax	775

	Date	Points	Title	Comments
1	01/08/2009	500	Date criteria on Access 2008 reports	2
2	01/08/2009	500	How to increase registry QueryTimeOut programatically using VBA	0
3	01/08/2009	500	ACCESS Sql query	5
4	01/08/2009	500	UPDATE an Entire Record	2
5	01/08/2009	500	Syntax for Obtaining Percentage Value from Another Table	5
6	01/08/2009	500	Data reader cant see SPROPCs/ functions?	3
7	01/08/2009	500	update a main access form when you click on a record in a subform	8
8	01/08/2009	500	Translate LAG / LEAD from Oracle to MSSQL	5
9	01/08/2009	250	How can I setup my report subscription in sql server reporting services 2000…	0
10	01/08/2009	500	T-SQL Split row on delimiter	10