Can anyone help me translate this from access so that it can work in mssql
(i need to get next value, but cannot use identity as if row is deleted,
another must get new next column number which would be same as deleted one)
Access;

I currently have 2 tables.  Both have ssn's of an employee.  I'm trying to
pull 2 fields, de_code and amount, from one of the tables based on the ssn
and the de_code like EIC (which is just a value in de_code).  I'm having
trouble merging those 2 fields into the other table.  ...

I am thinking of opening a case with Microsoft unless someone else has
seen this bug before (or knows a quick fix, BESIDES using a temporary
table).
DECLARE @T TABLE (CHECKDATE VARCHAR(50))

I am looking into pulling Exchange Mailbox data directly in SQL.  Currently,
we export the data from Outlook manually and then import into the data into
SQL.
We would like to bypass the import/export to a text file piece.  Could

Hi all, I'm wanting to change all of these Update queries into a single
view.  Pretty new at this and would appreciated the help. Cheers, Job
Update Tbl_Txn_Line_CHS
Set LP_AdjandPay_Not_0 =

1- Which better data types for money fields, float or decimal? Which i use?
    (... my money type requires 6 decimal point  ...x.123456)
2- I m using User Defined Data Types.  Is the UDDT supported Alter with
data? When i think change in future.

Two Servers,
        1st                                      2nd
database     a      -------> after replication         a'
            b'    <------- after replication          b

I can't get SQL Server to install and I can't figure out why.
All I am doing is trying to install SQL Server 2000 on my Windows XP
Pro (SP2) dev machine.
But it just hangs - the processes SETUPSQL.EXE and SQLSTP.exe load and

Newby question but can't find it myself.
How can I get a file-description from a file / table ?
eg. the decription must deliver the following info:
Record nr.

I am creating a drill through that will go out and find the correc
report out of 27 that equal my 2 parameters NAME_ID and DETAIL_ID.
Does anyone out there have any ideas for me? I can make it conect to
report. I do not know how to make it search for the correct repor

We have a transaction record that, for the sake of brevity, I will us
a simple paradigm to convey my need:
A sales clerk sells several pairs of shoes over the period of a day
each & every day the clerk works. Each transaction is recorded i

MSDE2000 has been installed on my computer. In the Data Link Properties
window, item 1 is "local" and item 3 is "contactsSQL" and "C:\Microsoft
Press\Access 2003 Inside Out\SQL\ContactsSQL.mdf". I get "Login failed for
user" when I select "Use Windows NT integrated security" for ...

I have a database that I am currently performing backup and incremental
backups.
If I were to add an extra table to the database or modify an existing table
with a few columns, would that imply that I would need to perform a full

Will someone give me an example of creating a 'Non-Clustered Index on a
Clustered Table', so that I can avoid inadvertently creating one?

Does anyone know of a good book to use for a 16-week introductory
course to SQL (using SQL server as the platform preferably)?  If not,
I can use two books: one for a quick "how-to" on SQL server, and then
one on SQL itself.