I only had the chance to work with 2k5 once, so far, but I did notice other strange (different) default settings... for example, "Concatenate Null Yields Null" was turned off...

The object of the FROM clause may not be a variable.  You'll need to use dynamic SQL to do this.

You sure it was 2,147,483,647 MB?  That's two billion mega bytes... no wonder the server was having a hard time swallowing that

East Indian, American, or other, I'd really like to see 3rd party vendors adopt the strategy of doing things right.  Not just software, either... call centers of all sorts should...

With the PARSENAME function, there's no need even for that.  PARSENAME (see Books Online) was developed almost soley for the purpose of interogating IP Addresses provided that the dots are...

Since I can't even spell "Matrix Control", I kinda figured someone else would take a shot at it   I'm definitely NOT a GUI...

Heh... just seeing if you're awake, David

Ah... old habits are hard to break

No explanation except for maybe parallelism, different stats, different number of processors, different section of harddisk, different memory, etc, etc. 

It's just not a good idea to update a view...

That's cool... Thanks Micheal...

I know, I know... and even though he was way out of line, you felt you had to follow suit...  and go one better.  Just wanted...

What do you get when you run the following?

SELECT '|'+IP+'|', 'A' AS Ind FROM MyTable WHERE IP = '1821682521'

UNION ALL

SELECT '|'+IP+'|', 'B' AS Ind FROM MyTable2 WHERE IP = '1821682521'

Also, why did...

Not surprised... just thought REPLACE would be closer.

Where's the performance hit taking place?  On SELECT's???

Just remember there, "new poster".... no one called you a "Douche Bag" or "Jive Turkey"... you did.  Suggest you make a little bit of a change, yourself.... even in the...