CAST(REPLACE(qtyavail,',','') as numeric(9,2)) + CAST(REPLACE(qtyavail and qtyatbranchavail) as numeric(9,2))

Personally I would preprocess the data outside of sql then load.

But if you want to use sql

1. DTS the data into staging table (varchar columns as Mike suggested) including an...

SELECT table1.name,table2.name

FROM table1

INNER JOIN table2

ON CHARINDEX(table2.name,table1.name) > 0

I agree with Frank, use a single table with id, otherwise you will have to use dynamic sql.

The simple solution for copying data is

to create the table and insert

SELECT *

INTO newdatabase..newtable

FROM olddatabase..oldtable

WHERE ...

to insert into an existing table

INSERT

INTO newdatabase..newtable

(col1,col2,col3...)

SELECT col1,col2,col3......

"Btw, Access exposure can be treated, and maybe some day you will get your normal life back."

Yeh but I hated those padded cells.

How about this

SELECT TOP 24

i.codigoind,

i.mesind,

i.anoind,

i.numeroind,

(i.numeroind - m.numeroind) / m.numeroind AS 'varmesind',

(i.numeroind - y.numeroind) / y.numeroind AS 'varanoind',

(i.numeroind - a.numeroind) / a.numeroind AS 'vardozemesind',...

OK, OK, short reply just to keep you happy.  The only reason I did not respond before is that I am not well versed...

Dates cannot contain 'empty' string, as you found out sql will set id to '1900-01-01'. If your input is not datetime (eg varchar) then use NULLIF, eg

DECLARE @string varchar(10)

SET @string =...

Without structure can only guess. Assume that row contains a date and all months present then

SELECT TOP 24 a.[date],a.CPI,

(a.CPI / b.CPI,1) AS 'Increase'

FROM a

INNER JOIN ...

It is the drop statement not object_id that is the problem. You will have to use dynamic sql like

SET @sql='If Object_ID(''NBP'+@yearcount+''') is not NULL Drop View NBP'+@yearcount

EXEC(@SQL)

SET @sql='CREATE...

Having not used SQL2K (but will be soon), collation is more of a black art than a grey area for me. I thought that SQL2K allowed different collations for different...

My shortcut shows

Target

C:\WINNT\System32\hh.exe sql80en.col

Start In

"C:\Program Files\Microsoft SQL Server Books Online\1033\"

The Start In dir contains

123 File(s)     39,038,612 bytes

Have a look at the properties for the shortcut (if there is one) on the programs menu, it should tell you where the files are.

My link is

©1988-2002 Microsoft Corporation. All Rights Reserved.

and shows

Version: 8.00.002

Gonna try your url now