Or to use BULK INSERT in T-SQL. If the file is a CSV this should be relatively easy to accomplish.

I do have one request, please put together a small dataseet for each of your tables along with expected results based on the sample data so that when I put...

I don't have time right now, as I am at work, but if others will let me I'll take what you have given here and work up a set-based solution...

Well, I do need to ask a question. Why are using a cursor? Depending on what you are doing, it is probably 99.9% possible to replace your cursor...

This one makes you wonder about some people.

I guess we all forgot The Thread's birthday. Think It will hold that against us?? 😉

It isn't a VIEW, it is a FUNCTION....

You are probably looking in the wrong place. It isn't a system view, it is a system TVF.

There is this function, YEAR().

SELECT YEAR(GETDATE())

Don't have anything for you with regard to SSIS, but I do have a suggestion regarding the query you posted:

SELECT

InteractionID,

StartRecord,

...

And? A question you may have?

As you are creating a CSV file on a daily basis, this sounds like a job for an SSIS package. I'd like to recommend that you look into that...

And it also depends on how the query is written as well. A straight SELECT query from a Tally table for instance all the values were the same for...

Actually, Jeff, in a query such as this:

select getdate(), getdate();

the getdate() function is actually called twice. Found this out during...

Unfortunately, you really didn't answer Seth's question. But regardless, please check out my blog post here.