well, this could be an option in the case the functions adds up a simple counter

but it isnt the case since the new id i am calculating is done as...

great, feels good to learn!

now i faced smthg else! in the new table i'm filling, i have a field that should get incremented each time i insert. (i have a...

ok great!

one more question:

what if i need to add another table in the join, smthg like:

FROM Table1 AS t1

INNER JOIN Table2 AS t2

INNER JOIN newtable ???

and why do I...

maybe i wasn't clear, i don't want to CREATE table3, i just want to INSERT INTO it..

OK tx! this seems to be a good idea, but there is still smthg wrong in the syntax, i can't figure it out (the object Table3 already exists in the...

tx! i'll try although am not that strong in sql (dunno what CTE is )

and maybe someone can help in this:

the person who is passing me the text file is using some php thing,

fwrite($file,$res[0]."\n");

what i see is that he is using \n,...

yeah it works only when i paste the character, but it doesnt convince me much!

There must be a way to express the equivalent of the ascii!!

ok i found out that it is a line feed, not a carriage return

it is a char(10)

can i write smthg like:

BULK INSERT OrdersBulk 

    FROM 'c:\file.csv' 

    WITH 

   ...

i want to replace but i dunno what it is!

i thought it was a carriage return, but no...

well am using a qynamic query coz i need to do a try catch. I'm trying to know if the file exists, and i can't use xp_fileexist not xp_cmdshell because...

table variable?

can't i just define it as a varchar, and select just one field? or count(1)?

anyone? any clue??

ok great! tx a lot!