....You're lucky if...

Todd Carrier (11/27/2007)

---

One question I have, that I haven't been able to figure out... how do you post your code in the little blue box? When I copy and...

Don't get me wrong Lynn, I agree with you. I just know how some people will take what you say literally and when it's not in context, it's easy to...

Watch it Lynn, this one might come back and bite you.... 😉

Loner (11/27/2007)

---

Actually I tried to answer that question, it was quite a challenge !!!

Sometimes it is hard to write a question, I read a question that is a page long...

My fingers are crossed that people actually read this article!

Maybe get Steve to include something like this in the new user sign-up... 😀

You probably want to use NOT IN rather than NOT EXISTS

And you can only return ONE field in the subquery for the NOT IN statement.

Or you could download a smaller file from a faster source with fewer traffic from a system using a faster connection on the second Monday of the month. :w00t:

Well, you never mentioned that it has to work on 2000 and 2005.

There may be a better way, but this works, as any database that isn't available will return a...

select * from sys.databases where [state] = 0

ehlinger,

Sorry but I'm going to be off of here until next Monday. It's a holiday weekend here in the US so I'm "checking out" for a few days of...

I learned it from watching these forums.

It's actually the keyword to parse out object names, and just happens to work with IP addresses.

How about ...

DECLARE @ipList TABLE (ipAddress VARCHAR(15))

INSERT @ipList

SELECT '68.251.41.3' UNION SELECT '10.0.5.112' UNION SELECT '192.168.7.1' UNION SELECT '127.0.0.1'

SELECT

PARSENAME(ipAddress,4) AS firstOctet,

...

Try this using the sample data you posted.

WITH raw_data

AS (

-- first we wrap a query to return the progressive totals in a...

OK, the code below should get you what you've described.

First we use a correlated sub query to get the cumulative (progress) values and I put that into a CTE (common...