SQL Query Syntax

August 28, 2008 06:06am 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	transposing multiple rows into multiple columns of single row	SQL Syntax	612
2	TSQL - Select multiple rows into single row. (Master / detail tables)	SQL Syntax	529
3	Execute SQL Stored Procedure using VBScript	SQL Syntax	493
4	Find duplicate records on Multiple fields	SQL Syntax	470
5	Generating Output Text File From SQL Server Stored Procedure	SQL Syntax	427
6	MS-ACCESS-2003 VBA: Make-Table-Query: How can I code the Q…	SQL Syntax	426
7	Problem creating Oracle materialized view (snapshot).	SQL Syntax	399
8	SQL While Loop to concatenate fields of two different records	SQL Syntax	382
9	SQL Server Syntax For DOS Commands	SQL Syntax	271
10	Get start Date and End Dates	SQL Syntax	249

	Title	Zone	Views
1	UPDATE with INNER JOIN SQL Server	SQL Syntax	2269
2	Nested CASE/IF statements in MS SQL Server 2000	SQL Syntax	1808
3	How to get row number in sql?	SQL Syntax	1273
4	SQL UPDATE statement for multiple rows, multiple columns	SQL Syntax	1160
5	VBA/Excel SQL Query	SQL Syntax	1099
6	Removing decimal places from a number SQL Server 2000	SQL Syntax	1055
7	Formatting Dates in SQL Server 2005	SQL Syntax	993
8	Insert date into SQL Server 2005 Table	SQL Syntax	983
9	Create Autonumber in QUERY not TABLE in Microsoft Access	SQL Syntax	924
10	SQL / TSQL - DATETIME - To The Nearest Half Hour, Hour, 2nd Hour, M…	SQL Syntax	707

	Date	Points	Title	Comments
0	08/28/2008	500	Checking multiple values of subject - Oracle Sql	1
1	08/28/2008	500	altering definition of table on a mdf sql database	3
2	08/28/2008	401	How do you build a query with two fields that each link to different results from another ta…	1
3	08/28/2008	500	Give result if statement is true	1
4	08/27/2008	500	Really complex query based on one table	2
5	08/27/2008	500	SQL Archiving	4
6	08/27/2008	125	Query to Determine Order with X amount of items	2
7	08/27/2008	500	update sql query for a retrieveing records matching particular pattern and date range	6
8	08/27/2008	400	Date range not showing in report - Access 2000	4
9	08/27/2008	250	Link Query string thorugh multiple tables	3