Thanks for those links.

I've had a bookmark for some time to Ben-Gan's original write-up, which you might want to add to your list of median computation web pages:

http://www.sqlmag.com/article/tsql3/calculating-the-median-gets-simpler-in-sql-server-2005

That article explains...

If you define a column as a VARCHAR type without specifying the length, it defaults to a length of 1.

BOL: http://msdn.microsoft.com/en-us/library/ms176089.aspx

Rich

sqldba_icon (5/9/2011)

---

rmechaber (5/6/2011)

---

Have you worked with SSIS before? You can execute as many tasks in parallel as you like in SSIS, which is one of the very nice things...

Have you worked with SSIS before? You can execute as many tasks in parallel as you like in SSIS, which is one of the very nice things about it....

Elliott Whitlow (4/29/2011)

---

Oh well.. I released a SQL CLR file function library on codeplex in march 2011. It is at:

http://nclsqlclrfile.codeplex.com/[/url]

Let me know what you think, what is wrong with...

Wow, what a difference 2 years makes:

Jeff Moden, February 2009, http://www.sqlservercentral.com/Forums/FindPost652105.aspx:

Jeff Moden,...

Jeff Moden (5/2/2011)

---

I kind of blew it on the CLR function. I asked someone to write it for me and then he came down with a really nasty flu...

Jeff, your exposition of how you mentally wrestle with a problem was exceptional. That alone made your article worth reading! You've got a rare combination of technical skill,...

Odd, I have no entries in SSMS Tools, Options, Text Editor, File Extension and .sql files open fine....

XP SP 3 on the workstation, with SQL 2005 Enterprise server.

Rich

This will find all log entries from April 20, 2011, which I think is what you're trying to do here?

SELECT FirstName, LastName, LogDate

FROM Employee

WHERE LogDate >= '2011-04-20' AND LogDate <...

This is an annoying problem. I've simply given up, dealing with the issue this way:

- For every Excel file I will need to repeatedly generate, I...

If your app. uses IE, might it be possible to use Kerberos to pass user credentials along from the workstation to your application?

Just a thought...

Rich

Funny, I just read that whitepaper, researching the same issue for PDF storage.

I ultimately decided on file storage, not DB, for a reason that has nothing to do with speed...

To add to the points raised above, I would add that you would need to start an explicit transaction to wrap the INSERT and UPDATE. Otherwise, if the INSERT...

Steve, this is a fantastic opportunity, thank you!

Rich