Hi, a few questions 😉

How do you store your data in SQL database: do you use char or varchar data type in biggest fields? Do you use appropriate types for...

this is a pretty good way. maybe you should consider backup/restore route? this way you don't have to take db offline, though this probably does not matter too much.

you take result of inner replace and put it as first parameter to outer, and so on.

select replace(replace(REPLACE(CONVERT(varchar(30), GETDATE(), 120),'-',''), ' ', ''), ':', '')

Why do you need to insert into both tables in one query? All you end up with is a set of queries hidden in a trigger on this view. Isn't...

Before you run the query, click 'Include actual execution plan' and see how it looks like when the query is finished. look for table scans for example, try to eliminate...

Check for the MOVE option in the restore database statement. Also, to get list of files, read about restore filelistonly.

Piotr

just an idea, what would happen if you add an empty string before your number?

as in

Select '' + [Serial Number] as [Serial Number],

GM,

[From Date],

[To Date] from txtsrv2...test#csv

Read about linked servers in books on line. this is the way to go.

I assume you have odbc source registered on your system.

Piotr

no prob.

does it mean that collate database_default does not work either?

This is what I learned:

you can create temp tables and specify collation of character fields to current database collation.

collate database_default works nicely, for example

create table #temptable

(

field1 int,

field2 varchar(15)...

maybe you could set up a linked server instead of using openrowset? openrowset has to be enabled on server which is not what every DBA likes

and as far as the...

yes, it depends on your needs, but if you have foreign key I assume that you'd rather have inner join.

btw, syntax you use also represents inner join and

select t1.a,...

what do you mean by it doesn't work?

from what I see it should return...

You should not use * in queries, the order of columns in view and table may be physically different.

you must use

insert dest (col_a, col_b, unique_col) select cola, colb, null from...

That's what I meant Gail. Application should not rely on physical order of rows in a table. Sorry for the confusion 🙂