Hi,
I have two tables and I want to update a field of want table based on the presence of the ID's in the other table.
For example:
Table A has the following records:
col1 col2
ID1 some...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20166545.html
Zones:
DatabasesDate Answered: 09/07/2001 Grade: A Views: 8
Hi folks,
Can anyone explain the output obtained by the following code? Is there a trick or something, specified by -FIGURE? ?? Or is it merely calculation and some form of decoding?
#includ...
http://www.experts-exchange.com/Programming/Languages/C/Q_20920117.html
Zones:
CDate Answered: 03/16/2004 Grade: A Views: 0
Hi,
I have a table name tblParts with the following data.
partNo Name Category
P101 ... ...
P102 ... ...
P103 ... ...
P104 ... ...
P104 ... ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21441845.html
I have just installed SLQ 2005 on my PC. I have some data on my Access file (DMBS). How can SLQ read from Access? Or How can I transfer my Access file to SLQ?
http://www.experts-exchange.com/Programming/Misc/Q_21630149.html
Hi All,
I need you r assistance once again. I have about 30 SQL Server queries that I execute in SQL Server Query Analyser and then copy the results of each query to Excel at a time.
I execut...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 12/21/2006 Grade: A Views: 0
Hi,
I have a table listing_info and within that list_show_price i need to set every field in that to 1 what sql do i run?
http://www.experts-exchange.com/Programming/Misc/Q_22136525.html
Zones:
ProgrammingDate Answered: 01/25/2007 Grade: A Views: 0
Hello Experts,
When my DATE formats were mm/dd/yy all was going fine, but later on we come to know that since we are making this project for some UK company we have to go by British format not a...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20246126.html
hi
im trying to query database with date , but im not getting any results .. how do i pass the date?
datatype of date column is datetime..
select col1,col2,col3 from x where update...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20718247.html
Hi!
I'm using Access as frontend and SQLServer as backend. I allow the users to create their own views so they don't bother me with their everchanging needs. That implies a GRANT CREATE VIEW. In...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20911567.html
Hi:
I would like the results of my Select DISTINCT to show two fields.
The first field is the column with the distinct elements, the second column
is to contain the associated value with the...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22019440.html
Zones:
MS AccessDate Answered: 10/11/2006 Grade: A Views: 0
