Peso (5/12/2008)

---

For a sample set of 1000 date pairs, my suggestion runs in 59 seconds and needs 1,119,549 reads.

Michaels suggestion runs in 334 seconds and needs 572,852 reads.

The SQL Server...

Theanks for the feedback, Ted... I'll add those to the list of reasons why I don't use DTS or SSIS 😀

born2bongo (5/12/2008)

---

It's an appealing idea, but I think it means either giving ODBC access to the user base, or someone opening the workbook and running the macro prior to delivering...

Kinda what I was getting at but couldn't do so in my coffee deprived state... thanks, Gus.

Peso (5/12/2008)

---

They were not using Windows, right?

I don't think : and ? are valid characters for a Windows filename.

HourCharASCII

--------------

0- 1048

1- 2159

2- 3250

3- 4351

4- 5452

5-...

It would appear that you're trying to write everything as a single line using SP_OA... instead of trying to jamb everything into a single line of text, why not continue...

Hi Karthik,

I could be wrong, but I'm pretty sure the answer is "No"....

GSquared (5/12/2008)

---

Jeff, there's a reference to the location table in the Where clause, "WHERE t2.Location='PRK'".

Sharul, the first thing I'd do for performance, is get rid of the conversion functions in...

Still haven't answered the question above...

I know it sounds strange, but the first thing I'd try is dropping and recreating the function.

Matt Miller (5/12/2008)

---

Jeff Moden (5/12/2008)

---

Instead of bailing from the company, you have a huge opportunity... set up a multi-million row test and show them why it's a bad idea. ...

RyanRandall (5/12/2008)

---

LOL - yes I know it's not your blog. I guess you missed...

ahsansharjeel (5/12/2008)

---

Your Solution is here, Please change the SELECT Queries with your Query

SELECT * , ROW_NUMBER() OVER(ORDER BY ID) AS MY_ROW_NUM FROM

(

SELECT ID, FirstName, LastName, JoinDate FROM Table1

UNION

SELECT ID, FirstName,...

Instead of bailing from the company, you have a huge opportunity... set up a multi-million row test and show them why it's a bad idea. Challenge those that support...

RyanRandall (5/12/2008)

---

😛

It sure is, but if it's the fastest method, who cares? 🙂

It's something else to try, anyway, and I'm...