Here is my query below...I'm getting the following error when trying to execute:
Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.
Any hel...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20498616.html
Zones:
MS SQL ServerDate Answered: 08/11/2003 Rating: 8.6 Views: 0
I need to return a recordset which joins several tables. I'll explain by example.
I have 4 tables:
Users - the PK is UserID
Media - PK is MediaID contains foreign key UserID
Licenses - PK i...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20627709.html
Zones:
MS SQL ServerDate Answered: 05/27/2003 Rating: 9.6 Views: 0
i have a query for testing purposes
SELECT Parts.PartNumber, Parts.Description, Parts.DateModified FROM Parts;
I want to return all the records in Parts based on the values I type into anoth...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21741120.html
Zones:
MS AccessDate Answered: 02/17/2006 Rating: 9.4 Views: 0
very quick one people. I have written plenty similar queries, but obviously I am doing something wrong here. I have a feeling it is probably something silly... monday morning and all.
Anyway, ...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_22442975.html
Zones:
Oracle PL/SQLDate Answered: 03/12/2007 Rating: 8.0 Views: 0
I have a insert statement like this:
insert into Table
(
Id,
Field1,
Field2,
Field3,
Field4,
Field5
)
select
History.Id,
History.Field1,
History.Field2,
History.Field3,
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22612636.html
Zones:
MS SQL ServerDate Answered: 06/19/2007 Rating: 9.8 Views: 0
I'm trying to do a mass UPDATE using a correlated sub-query but I'm having difficulty because the value being passed to the inner query is a variable from the outer query.
To make this clear, I...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20208368.html
Zones:
MS SQL ServerDate Answered: 10/24/2001 Rating: 9.6 Views: 0
I have a form which previews a report of a park using a button. name of the park is being taken from the combo box. I wanted that if the report is empty then a dialog box should pop up stating the ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20679062.html
Zones:
MS AccessDate Answered: 07/16/2003 Rating: 5.8 Views: 0
Hi Friends
I Have a Table Named TEST_TABLE with two Fields FNO,SNO
The Data for the Fields arre
FNO-------SNO
1 -----------1
1------------2
1------------3
2------------1
2-----------...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20887641.html
Zones:
MS SQL ServerDate Answered: 02/17/2004 Rating: 8.8 Views: 0
Hi,
I have a subform named "FMLA subform2" which appears on several different main forms. FMLA subform2 in turn has a subform named "FMLA_Hours". I want to display the total number of hours fr...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21235487.html
Zones:
MS AccessDate Answered: 01/03/2005 Rating: 5.8 Views: 0
hello Experts,
I have following query
SELECT TOP 10 iid, items.my_id, items.my_start
FROM items
WHERE items.ad_status = 3
I want to update following update
update items
set my_id =...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21458334.html
Zones:
MS SQL ServerDate Answered: 06/14/2005 Rating: 6.6 Views: 0
