SQL Query Syntax

August 21, 2008 01:35pm pdt

250 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	Need help with syntax for T-SQL date conversion to string format	SQL Syntax	740
2	Writing VBA code to run SQL query with ADODB connection and getting Run-ti…	SQL Syntax	599
3	transposing multiple rows into multiple columns of single row	SQL Syntax	552
4	TSQL - Select multiple rows into single row. (Master / detail tables)	SQL Syntax	495
5	Execute SQL Stored Procedure using VBScript	SQL Syntax	438
6	Find duplicate records on Multiple fields	SQL Syntax	412
7	Generating Output Text File From SQL Server Stored Procedure	SQL Syntax	380
8	MS-ACCESS-2003 VBA: Make-Table-Query: How can I code the Q…	SQL Syntax	380
9	Problem creating Oracle materialized view (snapshot).	SQL Syntax	357
10	SQL While Loop to concatenate fields of two different records	SQL Syntax	346

	Title	Zone	Views
1	UPDATE with INNER JOIN SQL Server	SQL Syntax	2302
2	Nested CASE/IF statements in MS SQL Server 2000	SQL Syntax	1847
3	How to get row number in sql?	SQL Syntax	1295
4	SQL UPDATE statement for multiple rows, multiple columns	SQL Syntax	1147
5	VBA/Excel SQL Query	SQL Syntax	1118
6	Removing decimal places from a number SQL Server 2000	SQL Syntax	1087
7	Formatting Dates in SQL Server 2005	SQL Syntax	1033
8	Insert date into SQL Server 2005 Table	SQL Syntax	985
9	Create Autonumber in QUERY not TABLE in Microsoft Access	SQL Syntax	975
10	SQL / TSQL - DATETIME - To The Nearest Half Hour, Hour, 2nd Hour, M…	SQL Syntax	722

	Date	Points	Title	Comments
0	08/21/2008	250	grouping issues null values should be only one line not 6	0
1	08/21/2008	500	using a sql string as anest query	4
2	08/21/2008	500	MySQL and SQL Syntax error checking	2
3	08/21/2008	250	Unbound field not getting refreshed	11
4	08/21/2008	500	UPDATE statement with an AGGREGATE.	3
5	08/21/2008	500	How to convert rows column into rows based on one value in table	0
6	08/21/2008	250	Access 2003 PivotTable Query	1
7	08/21/2008	125	SQL Help Needed: date grouping, matching and counting	1
8	08/21/2008	500	Shortcut SQL If Statement	2
9	08/21/2008	500	Ms Access - Passing dates into queries from forms	7