John and Eirikur

Could I also have an issue in the syntax because I have

CASE

when

...

Legis_Districts.Zip4 is a good column. I think I see where it might get confused though. The top 1 I need is where the zip5 field is equal to...

Yes when I run the query against the table [TimCIS].[dbo].[Legis_Districts] I get 2,552,381 records.

I renamed it for the purpose of the question. I have two databases on the same server. One is the main production database holding all of our transactional data...

I am trying to insert the current date using getdate() into a field in the table that is datetime.

I am not aware of how I would have to change the...

Here is the error I get. I also max out on errors and it fails at that point.

Bulk load data conversion error (type mismatch or invalid character for the...