Although there are a huge number of possible reasons for this behavior, in my experience it is almost always due to one of two probable influences:

1) Irregularities in the optimizer/statistics...

I did give a reply in another forum similar to your example, but that was for the general case of selective test criteria.

For the specific case of collapsing null values,...

Well you could use [font="Courier New"]xp_CmdShell[/font] to run [font="Courier New"]osql[/font] that could run your script, though frankly I wouldn't recommend it.

You really ought to be able to use a combination...

Carolyn Stern (3/7/2008)

---

Doing some googling around it seems that if I use the management studio GUI it creates a duplicate table, writes to it, deletes the old one, and renames...

Oh my, yes. Unrestricted ad-hoc query facility for all app users. :w00t:

It delivers in...

neat.

It is indeed a sad day.

I started playing D&D in 1978, was a charter member of the RPGA and actually met Gary a couple of times.

He will be missed.

Got me. "sys.default_constraints" is a standard Catalog View in SQL Server 2005.

You should be able to fix this with CAST() or CONVERT().

Good point. I had forgotten that.

tim del bosco (3/7/2008)

---

I'm just confused as I would think it would never process that line, the clause before that:

AA.CastValueAsType=...

Try...

UPDATE tax_group_hdr

Set tax_group_id = tax_group_description

Where tax_group_id LIKE 'VA%'

kunal (2/25/2008)

---

Here i had created one function for returning the value of the Name from ListOption table.

CREATE FUNCTION [dbo].[GetListOptionDetails]

(

@fListOptionID int

)

RETURNS nvarchar(255)

AS

BEGIN

RETURN (SELECT Name from ListOption where Id = @fListOptionID)

END...

View definitions support Case functions just fine.

The query designer may not, but then just don't use the query designer. (I would never use it anyway).