I had a solution I was going to post but Jeff's was faster by magnitudes. I'd go with his solution.

ckmoied (10/8/2007)

---

Thank you ALZDBA

Actually your solution is similar to

select Facility1 as [Facility 1]

,(select count(*) FROM MyTable WHERE Cond1) as [First Condition]

,(select count(*) FROM MyTable WHERE Cond2) as [Second...

SQL Server Express does not allow remote connections by default and when you connect using ServerName\InstanceName it assumes you are attempting to connect remotely. If you use localhost\InstanceName you...

James,

This question should really be posted in the Development Forum, not in the discussion forum for an article about nulls. You will likely get more responses there.

As far as...

Jereme,

I am pretty sure using Case or Coalesce in the select list will not change the indexes used by the Optimizer, but using a case or function against a column...

sjwegg (10/5/2007)

---

Thanks for the info - some of the NULL fog is beginning to lift. Any hints as how to concatenate (MS SQL) a string that has some null...

When you are using Integrated Security from an ASP.NET Web application the application connects to the SQL Server using the IIS App Pool user (WEBGROUP), the SQL Server has no...

I can say that I have merge replication setup between 2005 and 2000. This was done at home for personal reasons, not in a "must work" production environment. ...

What edition of SQL Server 2005 are you running (Enterprise, Standard, Workgroup, Express)?

What is the specific error you are getting?

Steve is correct in saying that backing up to a network drive is very fussy. I was doing this in my last job and found that once a backup...

Frances L (10/4/2007)

---

select [ALName] +'--' +[AFName] +'--' +[APhone] +'--' +[***] +'--' +[AAddress] as [Name] ,[***] from UserDataEntry.GeneralInfo where UserDataEntry.GeneralInfo.[Name] like '%abc%' ORDER BY ALName

Invalid column name.

and I...

Tim Chapman (10/2/2007)

---

Hi Scott

Thanks for the reply.

And thanks for the last advice Michael.

I believe I have resolved the issue, in theory at least as it hasn't been tested yet.

The main...

Ninja's_RGR'us (10/1/2007)

---

In this case : Where MyCol < 'whatever' OR MyCol = 0

One implies a range seek and the other one an index seek (rid lookup). I don't see...

Nilssond (9/27/2007)

---

I have a table (MyTable) with multiple eligibility segments for members. Typical data looks like this:

MemberNumber StartDate ...