Like this:

Replace(Replace(Replace(Replace(strCol, ',,,,,,,', ','), ',,,,,', ','), ',,,', ','), ',,', ',')

Oh, definitely a bad idea. I discovered that if you let it become a habit then the hallucinations start to...

Bruce W Cassidy (3/29/2009)

---

The issue is that I have been matching the logon to the logoff based on the employee number and the logon time/logoff time. I match the...

OK, in that case I would recommend two things: first when there are multiple values for the same potential ordering key, they should be combined. And secondly, when you...

Yes, that is OK.

torpkev (3/31/2009)

---

I'm sure this isn't the best way.. but you could build your sql into a string and pass the sort type (ASC or DESC) as a parameter and then...

Santiago E. Perez (3/31/2009)

---

I've been able to handle dynamic sorting with something similar to this in the past.

order by

Case when @SortBy = 'roadway' then roadtobeclosed_Name End,

CAse...

What you need to watch out for here are DB settings like TRUSTWORTHY and CROSS-CHAINING. These will allow (to some extenet) the database principals (users & schemas) to assume...

ExcelMonkey (3/31/2009)

---

Thanks for the response. When you say it would take weeks to do, why is this? Where is the time being consumed? Is this assuming many files...

Hmm, there should be more to that error message.

Have you disabled macros or javascript?

Looks good to me. I am using Firefox 3.0.8.

Second thoughts: I am not sure if the XL automation technique can extract the macros or not. I've never tried that.

If you can get the uncompressed XML format of the Excel file, then you can import and shred that.

Alternatively, you can use Excel automation outside of SQL Server to open...

Derek Dongray (3/31/2009)

---

RBarryYoung (3/30/2009)

---

Here's what I have so far that works:

[ code ] for SQL,

[ code="csharp" ] for C#

[ code="vb" ] for VB.net

[ code="xml" ] for XML

bit i still have...