I have a select statement that has two nested select statements that compares a PK to a set of distinct values secondary field of type varchar. The pseudocode is:
select id
from atable
where c...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20377695.html
Zones:
DatabasesDate Answered: 01/01/2003 Grade: A Views: 0
Is it possible to do something like the following?
I have two tables.. [Account] which contains a list of Account names along with unique ids, and [AnnualData] which contains the columns: year, ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20641674.html
I have a table ( person ) with the following:
person_id head_of_house head_of_house_id house_id
3 f 1
5 ...
http://www.experts-exchange.com/Database/PostgreSQL/Q_20977639.html
Zones:
PostgreSQLDate Answered: 05/06/2004 Grade: A Views: 0
Hi
Here's part of my schema.
products(productID, productDimension1, productDimension2, productDimension1unitID, productDimension2unitID,...)
units(unitID, unitName)
Units table contains...
http://www.experts-exchange.com/Database/MySQL/Q_21265434.html
Zones:
MySQL ServerDate Answered: 01/07/2005 Grade: A Views: 0
Select id,
'MainImageURL' = CASE [Image]
WHEN '' THEN ''
ELSE (Select [Image Filename] from [myImageTable] where sku = convert(varchar(50),[Image]))
END
from myTable
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21414250.html
This is my first question so I'm hoping someone will be able to help me. I have a stored function that is to return a cursor. The cusor is opened for select. I'm getting an error regarding the i...
http://www.experts-exchange.com/Database/Oracle/Q_21454133.html
Zones:
OracleDate Answered: 06/10/2005 Grade: A Views: 0
MS SQL 2000
I am trying to run a nested select command where the nested part is a stored procedure:
SELECT * from table
WHERE ID in
(spSelectTest 'works')
and get the error message:
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21595891.html
I have a query on a single MEMORY table that is a bit tricky. The rows of the table represents contacts between users of type1 and type2. This query is performed quite frequently and must be effici...
http://www.experts-exchange.com/Database/MySQL/Q_21648725.html
Zones:
MySQL ServerDate Answered: 11/30/2005 Grade: A Views: 0
I have a basic understanding of Mysql and PHP. I have serverl simplie data logging apps.
I have a problem which i think is going to be easy to solve, but i just can't get my head around it.
I...
http://www.experts-exchange.com/Database/MySQL/Q_22875713.html
Zones:
MySQL ServerDate Answered: 10/05/2007 Grade: A Views: 4
Basically, I want to select all the unique records in a database based on a one or two columns. Let's stick with 1 column for now. Here is some sample date:
TABLE Computers:
ID | Computer Nam...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20869208.html
Zones:
DatabasesDate Answered: 01/31/2004 Grade: C Views: 0
