Thanks all for the tips.

I finally got the collation from the client.

My DB has "SQL_Latin1_General_CP1_CI_AS"

Server (TempDB) has "Latin1_General_CI_AS"

Seems they are not compatible. Ideas why? Anyone got a chart of compatible...

Cool. Question though.

What table did you use? Variable or TempDB.

Did you try both and compare?

Just curious.

Cheers,

Crispin

Why don't you try practicing random acts of intelligence and senseless acts of self-control?

Intriguing question.

Sorry though, no help. Will try find a way though.

Crispin

Why don't you try practicing random acts of intelligence and senseless acts of self-control?

SQL actually changes them for you. eg: < becomes "$lt;" etc.

No matter what, it creates well-formed xml.

Crispin

Why don't you try practicing random acts of intelligence and senseless acts of self-control?

Have a look about midway down this forum.

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=10401

Crispin

Why don't you try practicing random acts of intelligence and senseless acts of self-control?

Not the problem. The script used was created by me a while ago. The same script has been used for a while now. No collation info in the script. It...

no, they created the DB, tables and procs using a setup script which used to be used on the old server.

This script has also been used in the past without...

You can use @@RowCount

This'll tell you number of rows affected by the last transaction.

OR

Select Count(ColName) From TableName.

This'll tell you number of rows in the table (Matching the where clause if...

Maybe I misunderstand you but -

Solution 1)

Dump the contents of the csv file into a temp table.

You not gonna get around that.

Could you not do something alone these lines.

Insert...

One more hint though. This can cause problems with variable tables.

SQL does not have statistics on the, You cannot add an index to it.

If you gonna have large tables where...

You can do it one of two ways. Noth require a temp table.

I prefer using a table variable instead of a normal table in TempDB

-----------------------------------------------

SET NOCOUNT ON

--Declare you temp table...

ahh yes. Should have mentioned that. It bit me once....

Crispin

There is.

Server Properties > Connections > Check No Count.

This sets it for all DB's on that server/instance.

Crispin

yup, Col1 + Col2 would give you one column with the summed values.

SUM() added the values of rows, not columns.

Cheers,

Crispin

Yes.

Even Col1 + col2 + etc is fast.

Which one do you want?

SUM(COl1 + Col2 + etc) will return the sum off all columns + all rows.

This could be a large...