Do they provide the same heading name every time they send you the file?

What kind of format do they send you the file ? ',' delimited or fixed length?

If you want all columns of your query into a temp table

select colA, colB, colC

INTO #Temp

FROM XX

WHERE tff_id = '108' and tap_from_dt > '07/01/2006'

I agreed there are a lot of web site developers not knowing SQL, maybe they know the basic 'SELECT * FROM Table', 'INSERT TABLEA...', 'UPDATE TABLE A...', 'DELETE TABLEA...'.

The DBA...

cliffb,

I could use checksum, I was just in a hurry so I wrote it in using 'OR' especially there were only two values to check.  However I would not use surrograte key...

If I rated my previous employer as -1000 (from a scale of 1 to 10), and they found out it was me, then I would be doomed.

The surrograte key is an identity field, how can it have zero in it?

What I usually do is loading all the data in a staging table.  Then using left join...

Because I did not want to work with the offshore "developer", I asked my manager why we could not go to a local university to hire an intern, at least...

Dell was famous for their customer service.  As a matter of fact, the reason I bought a Dell PC  and a laptop was because of the customer service.  They moved...

Since there are so many companies outsourced to India, I think the government should limit the H1 visa (working visa) for Indian people coming to work in US.

BTW, most of...

I totally diagreed with Mr. Gates comments.  The education in Asia is not better than US.  I am from HK.  I agreed when I was 12th grade, I studied all...

I am just a SQL Server developer.  I have no power to choose products for my company so even I go to SQL Server Central everyday, I totally ignore the...

Most of the jobs I applied did not require any certificate.  However most big company requires a degree though.   Also the salary is  based on the level of position not...

Sorry.  I meant MCSE.

I never took Microsoft exam but I took a lot of brainbrench exams. 

All the microsoft certs, cisco certs, oracle certs were hot a few years ago but not anymore. ...

When I worked for the marketing researching company,  one of my project was changing a lot of main fields (name, address, ...) to unicode because they wanted to expand the...