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...

It's not just cursors... single row process loops are the real culprit.  Cursors inherently are single row and they use loops.  The real rule is that RBAR (pronounced "ree-bar" and...

Faster than COUNT(*)?

And, here's a simple script for calculating the number of Weekdays between two given dates.  Does not include exclusions for holidays... you would need a holiday table for that.

http://www.sqlservercentral.com/columnists/jmoden/calculatingworkdays.asp

Why do you have the pipe [|] character as the terminator?  You don't have that in the sample data.

Also, are you intending that...