SQL Query Syntax

October 12, 2008 08:39pm pdt

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	Calculating number of working days between two dates	SQL Syntax	1063
2	Get start Date and End Dates	SQL Syntax	912
3	Converting integer to string as expression for concatenation	SQL Syntax	838
4	SQL Query to display column names using lookup in table	SQL Syntax	590
5	Iff function	SQL Syntax	405
6	MS. Sql query to search all fields in a database.	SQL Syntax	377
7	How to create a composite key in SQL?	SQL Syntax	361
8	VBSCRIPT sql odbc login failure	SQL Syntax	340
9	Date count by month - Oracle SQL	SQL Syntax	324
10	SELECT, FROM, WHERE, REPLACE COMMANDS	SQL Syntax	308

	Title	Zone	Views
1	UPDATE with INNER JOIN SQL Server	SQL Syntax	2685
2	Nested CASE/IF statements in MS SQL Server 2000	SQL Syntax	1876
3	How to get row number in sql?	SQL Syntax	1408
4	VBA/Excel SQL Query	SQL Syntax	1381
5	SQL UPDATE statement for multiple rows, multiple columns	SQL Syntax	1370
6	Insert date into SQL Server 2005 Table	SQL Syntax	1163
7	Removing decimal places from a number SQL Server 2000	SQL Syntax	1065
8	Create Autonumber in QUERY not TABLE in Microsoft Access	SQL Syntax	1037
9	Calculating number of working days between two dates	SQL Syntax	984
10	Formatting Dates in SQL Server 2005	SQL Syntax	818

	Date	Points	Title	Comments
1	10/12/2008	500	SQL statement Count(destinct table_name) in MS Access	3
2	10/12/2008	500	type mismatch errror access database	3
3	10/12/2008	500	Handle substring length error in SQL function	2
4	10/12/2008	500	How do I segregate data in a SQL query?	6
5	10/12/2008	125	Select using multiple check text boxes	3
6	10/12/2008	500	3 Tables VS 1 Table	3
7	10/12/2008	500	Use results of query as input params for SP	5
8	10/12/2008	250	How to store a query result in a variable?	6
9	10/12/2008	500	Filter a subform from the main form	16
10	10/11/2008	500	MS access populating search result into listbox and transfer selected id to a text…	3