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.

You should know that wether you are using cursors or a while loop it is still RBAR (a Modenism for Row By Agonizing Row) processing. In almost all cases, converting...

You should know that wether you are using cursors or a while loop it is still RBAR (a Modenism for Row By Agonizing Row) processing. In almost all cases,...

rons-605185 (11/20/2009)

---

Per your post below, what is the advantage doing the inner joins versus the code I wrote? I have been only doing T-SQL for a short time and appreciate...

Alvin, I think it is time to go home, If not for you, it is for me! Have a good weekend! 😉