I will see what I can do. I think I might want to try a CLR proc on this one.....

What, no copy of SQL Server 2008?

Might as well get him started on the right early early......:D

Besides - he can always just chew on the box. High in fiber...

Jeff Moden (8/13/2008)

---

andrew gothard (8/13/2008)

---

But, there's even a way around that (and many similar problems not listed) without an explicit cursor or While loop OR UDF using a single...

David -

I just noticed your post. Here's the RegexMatch code:

Imports System

Imports System.Data

Imports System.Data.SqlClient

Imports System.Data.SqlTypes

Imports Microsoft.SqlServer.Server

Imports System.Text.RegularExpressions

Partial Public Class UserDefinedFunctions

Private Const optionS As RegexOptions...

Heather (8/8/2008)

---

So the values is to spread out the load across two server. The drawback would be the cost of joining data across servers would be slower, then joining across...

80 won't work. You need it @ 90 (or better).

I found this one ealier this week.

create myview as

select mycode as ID,

max(case when mycategory=1 then 1 else 0 end) as Code1,

max(case when...

You have to set the returms records to false, since your stored proc doesn't return anything. That's why the ODBC is timing out (it's expecting to get rows back,...

Wow - that one takes you back....:) That reminds me of having to...

TheSQLGuru (8/6/2008)

---

Yep. And then we have this situation:

Clustered index: order_id (assume int - 4 bytes), order_date (assume datetime - 8 bytes),...

meichner (8/6/2008)

---

I am in the manufactoring industry. We are more concerned with billing and inventory issues. Hopefully 5 places will be okay.

Thanks for the advice. It was...

Jeff Moden (8/1/2008)

---

Manie Verster (8/1/2008)

---

What is everybody's problem with cursors! How many articles do I still have to read where people talk about how bad cursors are! What is the...

You'd be well advised to check performance as well if you plan on starting to use windowed aggregates a lot, or on large sets. Sad to say, but they...

MichaelC (7/31/2008)

---

I have a CLR UDF that I created a while back and I could debug it locally and remotely. However, I can no longer debug, or step into,...

or...Utah....:w00t: