SQL Query Syntax

October 7, 2008 10:40am 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	963
2	Get start Date and End Dates	SQL Syntax	829
3	Converting integer to string as expression for concatenation	SQL Syntax	727
4	SQL Query to display column names using lookup in table	SQL Syntax	528
5	Return Row Number	SQL Syntax	470
6	Syntax Error Msg 102, Level 15, State 1,	SQL Syntax	445
7	Remove non numeric characters	SQL Syntax	366
8	Iff function	SQL Syntax	353
9	MS. Sql query to search all fields in a database.	SQL Syntax	342
10	SQL Concat problem having one null value	SQL Syntax	333

	Title	Zone	Views
1	UPDATE with INNER JOIN SQL Server	SQL Syntax	2564
2	Nested CASE/IF statements in MS SQL Server 2000	SQL Syntax	1784
3	How to get row number in sql?	SQL Syntax	1382
4	SQL UPDATE statement for multiple rows, multiple columns	SQL Syntax	1338
5	VBA/Excel SQL Query	SQL Syntax	1306
6	Insert date into SQL Server 2005 Table	SQL Syntax	1137
7	Removing decimal places from a number SQL Server 2000	SQL Syntax	1044
8	Create Autonumber in QUERY not TABLE in Microsoft Access	SQL Syntax	1003
9	Calculating number of working days between two dates	SQL Syntax	908
10	Formatting Dates in SQL Server 2005	SQL Syntax	835

	Date	Points	Title	Comments
1	10/07/2008	250	SQL Query using result set for criteria	0
2	10/07/2008	500	Recursive Query Help	2
3	10/07/2008	250	T-SQL While Loop	2
4	10/07/2008	500	MSAccess Query Seems to be Inventing Values That Don't Exist	1
5	10/07/2008	250	Select a group of students from a list of IDs in ms access	4
6	10/07/2008	500	duplicate data in tables	3
7	10/07/2008	250	Quick Clearing of Access Data	3
8	10/07/2008	500	MSSQL 64bit connect to 32bit DSN.	0
9	10/07/2008	500	How to update a table with INSERT but lookup on another table during update.	9
10	10/07/2008	500	SQL Query in removing the some characters in the column	1