Is this a one time action or would you need to do it many times?  Personally, I would use REPLACE on the text string to create a more standard formant...

Your issue is unclear to me.  The next version of SQL Server 2000 will be 2005, not 2003, but Access has a version 2003. 

SQL Server 2005 can run any...

This is not a complex or difficult thing to do, however, you can only accomplish it for the future.  Creating an identify key will fill every row with an identity...

There is nothing like the UPSERT or MERGE command in SQL Server 2000 T-SQL.  You might like to know that it is in SQL Server 2005.

Thanks!  I knew when the PRINT and RETURN statements both returned different values it was something simple but it never occurred to me that the options menu allowed me to...

I see that some would fall into the same situation I was in.  My original post indicated I had problems because I couldn't seem to weed out the NULL value...

Thanks.  I found another solution using ISDATE which will return a 0 for NULLs and 1 for valid dates.  Then, I also discovered that unless I CAST the date variable...

The procedure below will add the ID column if it doesn't exist in the Mcrl table.  You could easily substitute parameters for the table name and column name. 

IF NOT EXISTS (SELECT...

This error can happen for many reasons.  Generally though we need to be able to see the code that is causing the error.  Have you set up error trapping on each...

Yes there is.  I had the opportunity to acquire this script from sqlservercentral last year.  Hope you too can benefit by it.

ALTER procedure sp_FindText @SearchText varchar(100) 

Or, depending on how separate the databases are and what type, you could simply build a view, combining data from the different databases.  In Excel use Data\Import External Data\Import Data. ...

I believe you missed the point I was trying to make.  Your (num.number + 1)/@NumPayments) statement only fires when @NumPayment = 12.  That's why I suggested posting the code; so we could...

You might want to post a little of your code.  If you really have some type of 'IF' clause like that shown below it won't divide until you @NumPayments =...

A Primary Key is required to UPDATE data.  So, unless you don't wish to ever update the detail you will need a primary key.  I frequently create an ID field...

Having worked in Access for years before branching to SQL Server I have run across these type errors previously.  No guarantee but the parameters you use in our embedded SQL;...