hi adi,

Tks for your reply.

But how can i do that inside this condition?

a.dta_alteracao>b.dta_alteracao

tks,

Pedro

No, order is not important.

I just need something, that i send a value and then , this something (maybe a sp) populates some fileds (not all the column) of a...

I now, executed only the folowing comand:

execute ('BULK INSERT bulk_1

FROM '''.....1.txt''

WITH

(

FIRSTROW =2,

...

Hi,

I have tried to do the dinamyc SQL Statement, like this:

Create proc BULK_INSERT_DATA(@PATH varchar(500))

as

declare @SQLStatement as varchar(200)

set nocount on

truncate table bulk_1

SET @SQLStatement = 'BULK INSERT...

Thank you very mutch for all your help.

I undestud every thing, but i have some doughts in some words that you used (the meaning)

What is a staging table?

What is wipe?...

Why is truncate better than delete?

Is it faster? why?

This table is just for temporary use.

I delete de data first and then insert the data trought the bulk insert. Then i...

Yes, tks very mutch.

I only have one dought about this post.

If i make a:

delete from BULK_table

BULK INSERT BULK_table

FROM 'C:\..........'

WITH

...

The situation was resolved, saving the txt file to unicode.

Tks for your help.

Other question:

What about tablock? i have been reading about this option, but i don't undestand it very well.

My...

Hi , tks for reply.

I can not change the file to uni-code., because i receive the txt file from other persons.

Isn't there any other work around?

I really need to import...

tks once again for help.

But in this case i think you did not understud my question , i don't need to always start from 3.

I need to start from the...

tks old hand for reply so quick.

i will trie and will report to you the result

will this code start the counter from number 3? since number 1 and number 2...

Forgot to tell.

My user database is in simple recovery model (i know the risk of having that way). so in this case will the databse be havy?

ok.

But i would like to create the tables directly in my database, so this can not be #tables (this tables are created in tempdb), that's why i asked if there...

Thank you very mutch for reply master Paul Randal.

I'm sorry , about talking about a program to fix this problem.

This is because i have not mutch time, and i fill...

Thank you very mutch for all your help.

I'm sorry the post was not in the right place.

I read the link of master Paul Randal.