Wow. It would have been way easier to do this in SSRS. Is there some reason why it has to be done in SQL?

Weeeellll... normally an EDW has a whole management process,...

I'd suggest you write a SQL Server Reporting Services report that does this (not at all hard) and then you can just dump the report results into Excel. Turn...

Well, kinda. It's more a handle to a result set (in...

SQL Server stored procedures can return result sets directly. Oracle stored procedures can...

I've run into similar issues using a file-based transfer. SQL Server produces a file of data, and we use SQL*Loader to get that up into Oracle.

To get around the...

Good advice, Craig. I hadn't thought about it from that point of view.

Aside from the 1NF violation, it introduces some additional potential issues.

For example, all of these are valid date formats:

mm/dd/yy

dd/mm/yy

yy/mm/dd

Now... if I have the following in my "character date field":

01/02/03

What...

See Craig's answer below (my brain just wasn't working on this one.)

You can do it a bunch of ways. Here's one done in my own code format. Note that I haven't included error handling, and for production quality code...

I suspect that's the problem right there. If you're trying to pull all...

David Lester (7/6/2011)

---

Bruce, that was what I was originally considering, a split across function area. I am concerned when such a split is done upon the same underlying hardware the...

Also I'm not sure the degree symbol fits into the 7-bit ASCII character set:

NLS_CHARACTERSET= US7ASCII

Yeah, sorry.

but you would have to prepare the XML by hand in the calling application which is probably even more work than calling separate...

opc.three (7/6/2011)The preferred way (in terms of performance) to do this now is to use Table-Valued Parameters (introduced in SQL 2008) to pass a set of data to a stored...