Update Query
Sat, 29 Apr 2006 11:23:01 -0700
How does one update an Microsoft Access table from within Sql server. For
example:
If the sql table has three fields, field1, field2 and field3 and the access
table has three fields, Afield1, Afield2 and Afield3.
So if field1=1 and field2 =Afield2 update Afield3 with the value in field3.
Do In need to ...
|
Combining result sets
Wed, 26 Apr 2006 12:28:02 -0700
Hi there,
In an effort to give you a clear idea of what I'm doing, I'm going to give
you as much info as possible. Hopefully, this isn't overkill...
Background: I have 2 select statements which both count the number of units
of products ordered and I'm trying to combine them into one list with similar ...
|
SQL Server Client Query from One Server to Another
Fri, 21 Apr 2006 10:47:03 -0700
How can a user use SQL Query while connected to one server and execute a
query that pulls data from a database on another server. When we attempt
that from a client pc, we get an SA authentication error. If we run the same
query from the first server itself, the query completes. ...
|
How to allow normal user (not Administrator) deployment of SSAS Cube?
Fri, 21 Apr 2006 14:01:07 +0200
Hello,
how to allow normal user (not Administrator) deployment of SSAS Cube? It
says always that normal user cannot create new objects.
Andrey.
...
|
Mob-ocracy and the Fall of the Republic
Mon, 17 Apr 2006 23:17:37 +0100
Are we fools? Or are we slaves? As in the film Gladiator, are we as a nation
going from free men to slaves? Would we restore the Republic? Are we even still
living in a Republic? Or a mob-ocracy? And where is our representation in
government? Frank concludes that We have gone from civilized law to "jungle law"
...
|
for sale: internetDotComs.com
Sun, 16 Apr 2006 15:40:31 +0200
domain for sale: internetdotcoms.com
http://www.afternic.com/name.php?id=11866440
...
|
change all the letters to small cap
Wed, 12 Apr 2006 00:02:01 -0700
Hi,
Can anyone tell me how to change the names in a column to small cap.
e.g.
Name
Jane
Michael
Ronald
Eliza
to
Name
jane
michael
ronald
eliza
Your help will be greatly appreciated.
Thank you
Tiffany
...
|
|
|
Activex component can't create object
Tue, 11 Apr 2006 11:55:01 -0700
I am a newbie to SQL server. I am trying to using SQLXMLBulkLoad. All I am
trying is to insert a record into the PUB db.
The following is the error msg
Error Source: Microsoft Data Transformation Services(DTS) Package
Error Description : Error Code: 0
Error Source= Microsoft VBScript runtime error
Error ...
|
Join on IP Addresses
Mon, 10 Apr 2006 11:06:02 -0700
If this has been answered already, or is better answered somewhere else, then
please let me know.
I need help with a query. I have a table with many fields of information
about servers and network equipment. IP address is the Primary Key. I am
attempting join this table to another table that includes MAC ...
|
Server: Msg 170, Level 15, State 1
Fri, 7 Apr 2006 12:31:02 -0700
Server: Msg 170, Level 15, State 1, Procedure SWR_Save_Work_Orde, Line 10
Line 10: Incorrect syntax near 'SWR_Save_Work_Orde'.
[Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error
Code:
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[SWR_Save_Work_Orde]') and OBJEC ...
|
