Can I retrieve values from other records to create a calculated field
in the current record?
In our data we have a record for each account for each month in a time
series consisting of Account Number, Current Balance, Current Rate,

I have a problem that I am hoping to get some help with. We had a propritary
database made for us (VB and SQL Server 2000).
There have been several times where the software has crashed and we have had
to uninstall it and reinstall it. We have also had to restore the backup.

We have written an application which splits up our customers data into
their individual databases.  The structure of the databases is the
same.  Is it better to create the same stored procedures in each
database or have them in one central location and use the sp_executesql

i have a table name:NAMES
Name                  Surname                      City                      
Country
------------            ----------------              --------------        

Can someone tell me how i can create an iif function to do the following?
I need to look a field that has an amount in it. if it is 90K or less make it
1 if its 180 to 90001 make it 2 etc...
So for every 90K in that amount add 1..

When logged in as a database owner, select user_name()  returns "dbo".  I am
logged in using NT Authentication so I have to think that I should be able
to grab my real user name from somewhere.  Is there another a way to find my
NT log in name in a query and stay logged in as a ...

I am upsizing my mdb to msde. (tables only).
Why does the tables keep going to the master database instead of the
database I want?
Thanks is advance

I have a cursor here that appears to never stop running even though the
record set that populates it is only 22 records
heres the code:
declare cursorfinal cursor for

My SQL Query Statement is as follows:
SELECT DISTINCT e.vchrFirst_Name, e.vchrSurname, ecc.vchrCost_Centre,
ac.vchrPersonal_Expenses
FROM         tblEmployees e INNER JOIN

How can i have Row number in my SELECT Statement ?
Thanks

I need to know exactly what VBA lines Create and Destroy SQL Server
Processes - i.e. those visible in Enterprise Manager under Management

Why?

I am a  dba for sql server recently we are facing problems with the no of
connections.
we have a database called ( x ) every day  almost million users is using that
databse after some time the cpu showing 100 percent utilization an error

I recently upsized a JET database to an ADP project and I would like to know
how I can re-run the query (without closing the form) to change the data that
I am viewing. For example: If I am viewing client A and want to switch to
Client B using the same form. Currentlyy,the form ...

i'm currently converting a MS Access application to MSSQL.
In Access, i have a primary HelpDesk database that use some linked tables
from another database.
I've created the two DBs on the SQL server (HelpDesk & Contract).

From SQL Server, how can I link to a table inside an ACCESS(mdb) file?