I didn't get too far because the code block that loads the data generate a syntax error I can't seem to get past.

insert into Emp_Details (Emp_Name, Company, Join_Date, Resigned_Date)

values ('John',...

Actually, setting the null concat off was an obsolete fix for me anyway because I have since sanitized my data to eliminate nulls. There is no way on earth...

Matt,

Do you know how to imbed the connect string inside that pass-through query? I did one and every time I run it, I have to slog through the ODBC...

My use of "SET CONCAT_NULL_YIELDS_NULL OFF" cost me a WHOLE DAY yesterday!

The popular stored procedure for exporting a table using BCP, with a header row doesn't work if the CONCAT_NULL...

I found the SCRIPT - By Samardeep Khera, 2009/10/01

Thanks Samardeep for noodling that one out. I really appreciate the hints. It worked first time out!:-)

This looks like it might be really useful. Has anyone managed to get it to work? All it does for me is generate a list of errors when...

I figured out that I could "can" the views in advance, outside the stored procedure, but I'd still like to use BCP a lot better without so much hassle if...

Yeah, INSERT was the command I was searching for!

I'll have to keep in mind that holding onto my previous row-wise approach is a crutch, and one likely to handicap my ability to exploit SQL Server. I'll look...

So with four or more ways to do it, I found..... none of them! 🙂

Yeah, my head is still in row-wise manipulation but I'm trying. I've found...

Could you recommend a good T-SQL primer?

I have "Wrox Press Beginning T-SQL with Microsoft SQL Server 2005 and 2008"

I looked up "QUOTENAME" in that book, but when the brief description...

My apologies. The nugget I was missing was that the object in the QUOTENAME( was a column name and not a variable or literal.

This data sample loads...

Hey, know what I did there? I posted bad data BEFORE reading your post! 🙂

Here's table "1" -- the accumulator

USE [CPI]

GO

/****** Object: Table [dbo].[oc_daddr] Script...

Thanks for the quick response! I'll read and digest the link you posted, but also, here is a sample of what I've got, and what I'm trying to get:

in...

I'll try that! I think I read somewhere that I had to use Windows authentication to get the Browser to work with SQL server 2005. At this point,...