select

CASE

WHEN (h.source_channel = '3') and (h.primary_cust_ref like '%C%') THEN 'Guest'

WHEN (h.source_channel = '3')...

I think you want WRITETEXT instead of UPDATETEXT since you are replacing all of the ntext data

I've only tried this in a small test but this worked for me.

create table...

You can create format files for bcp as well but I think it will still have issues with your varied number of fields.

take a look here for the schema.ini info

http://msdn2.microsoft.com/en-us/library/ms709353.aspx

You can use

Format=Delimited(*)

You can use sp_addlinkedserver with a schema.ini file. Check out BOL sp_addlinkedserver and example H. You may also have to research building a schema.ini file to deal with...

As Andras stated SOUNDEX and DIFFERNCE do that based the relation of consonents in the 2 words. Is this what you are looking for or do you have another...

What do you want to know about them? How alike they are or how different? Are you looking for words that start the same, end the same, have...

Do you need the first record to contaian the field names or does it automatically use col001, col002 ...

No worky too good for me.

It added ok but when I select from the file all the fields fall under one field with the field name being the first record....

If there is a link between the tables have your trigger insert where the key does not exist, then it can fire every time but will only insert a new...

Maybe I'm being thick but doesn;t that say a schema.ini file must be in the same directory as the file being imported?

This may be easier to work with

select

j.job,

j.rtc,

min(date_of_work) start_date,

sum(case when c.date_of_work <= isnull(j.rtc,getdate()) then db_footage end) Early_DB_Ftg,

sum(case when c.date_of_work <= isnull(j.rtc,getdate()) then pc_footage end) Early_PC_Ftg

from #jobs j left join...

Jeff Moden (3/20/2008)

---

Yes there is... look up "sp_AddLinkedServer" in Books Online and refer to example "H. Use the Microsoft OLE DB Provider for Jet to access a text file"

You can...

You can bcp your whole file into a staging/temp table and then use an insert statement to append the specific fields you want into your main table. Not...

I don't know how well this plays with the indexes but I think it is easier to read

where

case

when monthid in (1,2,3) then 1

when monthid in (4,5,6) then 2...