OK, "dbo.RegexReplace()" is your CLR function that works like the SQL Replace() function, but with...

Patience.

It's like the old joke:

Q: How many psychiatrists does it take to change a light bulb?

A: Only one. But it takes a very long time and the light bulb...

Can you show us some of the code? If we want to talk brass tacks, then it would be easier to explain it in context than trying to explain...

Remember that humor can be a difficult thing among people with different native languages. One thing...

Can there be multiple dates in one string and do you want to preserve them all?

If not, then don't mess around with substitutions, just set the string to be equal...

The Arithmetic Mean function is AVG().

Yes.

Smo is terribly slow, especially when browsing the higher level collections, especially if you 'load' all of the properties. The principal reason for this is that SMO almost never...

For most of them 80 to 200 would be fine with me. But "Posts Last Week" needs to be larger, at least 500 I would think.

Isn't this the web paging "Holy Grail" problem? We only need one page worth of results at a time, but we also need the total number of results to...

mitchell.small (3/23/2009)

I need to get up to speed on SSIS Asap. I've used DTS /SQL 2000 to move data around from text files, excel, access and have...

So what's Lynn really like in person? Can you actually see the halo?...

GSquared (3/23/2009)

On the completely non-sequitur side of things, thanks to your post, I now have the song, "Row, row, row your code, slowly onto...

Hmm, not sure that helps much...

I still have the strong suspicion that this is logon/security/permissions/authentication related somehow. Can you try to setup your ODBC connection to use a SQL...

Here's a previous SSC Thread that has some tips that may be relevant: http://www.sqlservercentral.com/Forums/Topic308383-5-1.aspx#bm308596.

Huh, well I'm stumped. Maybe it's something else entirely?