To get the linked server to work correctly, I made the following changes.

Under Server Objects, Linked Servers, Providers, MSDAORA

Right click MSDAORA

Properties

"uncheck" "allow inprocess

Restart Server

I enabled the ad hoc remote queries, restarted the server, tried to connect to Oracle tables and received the below error

Cannot initialize the data source object of ole db provider...

I have uninstalled and restored all db's.  However on the Master db, I receive 1 error that has been skipped due to a version problem.  I am running sqlserver 2000...

I can't open EM so I am trying a restore of sqlserver, then restore.  Thank you

That is exactly what I needed. Thank you so much!!!

Thank you

This is something what I was trying to do.  Again, the sum(transactions) is where I'm confused.  Am I on the right track?

DECLARE @dt DATETIME

DECLARE @dt2 VARCHAR(10)

declare...

Thank you

Thank you all so much.  I love using CASE.  I can't believe I forgot about that. 

could I get a copy of the project plan?  sra98a@acu.edu

Thank you,

Thank you so much, that worked perfectly.

No, I don't need unicode.  When the .txt file is written to the mssql\log\.txt file it automatically saves as UNICODE.  I want it to automatically write to the file and...

I ran sp_helpsort and received the below information.  Thought it might help.

Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode...

Ok, the script was modified once again and the time is 14 seconds.  AMAZING.  Here is what I did in case this helps anyone else out.

Created Function

CREATE FUNCTION calc_score

(@key1...

First I created this function:

CREATE FUNCTION calc_score (@acctnumber varchar(20))

   Returns numeric

AS

BEGIN

DECLARE @totalscore numeric(4)

SELECT @totalscore =

    CASE

     WHEN key1 IN('APP', 'ADM', 'CNF', 'DNY', 'ENR') THEN 100 --Add 100 points...