Hmmm, I don't think that most of us would call that "backwards"....

Grant Fritchey (6/12/2009)

---

Hey Barry, If you start working with spatial data in 2008, you...

dougznospam-mailbox (6/12/2009)

---

Hmmm, that sounds odd. I've been using this for years in multiple domain environments with no trouble. Additionally, it's just a straight ADO connection using integrated security,...

Glad I could help.

Nice writeup, Rick. You should consider submitting this as an article here.

Yeah, thats where I thought this was going too, Carl....

JKSQL (6/12/2009)

---

yes exactly.

there would be one on filter = 0 and then one on filter = 1

The table probably should have been split but there is already...

In SSMS, right-click on the database, select Tasks.. Generate Scripts..

In the...

???

At this point, I cannot honestly say that I understand what you are trying to do?

Are you trying to apply a Unique Constraint to only some of the...

Glad I could help.

Just to clarify: MAXDOP (maximum degree of parallelism) does NOT restrict how many CPU cores a SQL Server instance can use at one time. Rather it only restricts how...

Actually, MAXDOP = 1 is the Microsoft recommended setting for OLTP environments, especially heavily loaded ones.

Try it like this:

DECLARE @VAR1 CHAR(20), @VAR2 CHAR(20), @VAR3 CHAR(20)

SET @VAR1='Variable1'

SET @VAR2='Variable2'

SET @VAR3='Variable3'

Select Distinct

SYS.User_Name0,

SYS.User_Domain0,

@VAR1 As [Var1],

@VAR1 As [Var2],

@VAR1 As [Var3],

MAX( CASE WHEN ENV.Name0 = @VAR1

THEN ENV.VariableValue0

END ) As [Value1],

MAX( CASE...

Crystal should be OK with your SP, as long as you just put the SELECT... at the end.

Grant Fritchey (6/12/2009)

---

RBarryYoung (6/12/2009)

---

Good catch Bruce. I had suspect some sleight of hand from either the OP or the Client code, but I missed the codegen reference.

Does anyone know...