I suppose that you're searching for something different than the Microsoft course 2778

http://www.microsoft.com/learning/en/us/course.aspx?ID=2778A#fbid=EN0FHZ0dEvf

An error I made when copying and pasting on the last line.

Change it like this

GROUP BY a.hostname) AS l ON i.ip < INET_ATON( l.hostname )

That's because you're making a CROSS JOIN instead of an INNER JOIN.

To give te correct output for a single IP address you need to chage the query.

At least, that's what...

There are a few issues here and I will try to help you as much as I can, but I'm not sure that I can give you a final solution.

First...

I used a similar code at work a few weeks ago and I just adapted to your problem, so if someone has something better it will be benefitial for both...

Something like this?

;WITH Ordered AS(

SELECTDISTINCT

CASE WHEN l.Col1 <= l.Col2 THEN l.Col1 ELSE l.Col2 END AS Col1,

CASE WHEN l.Col1 <= l.Col2 THEN l.Col2 ELSE l.Col1 END AS Col2

FROM Links l

),

rCTE AS(

SELECT...

I'm sorry, I edited my response because I saw a rule when I was checking my post.

I'm sure you don't need an extra case, just the correct set of conditions....

Sean,

there's no need for the ISNULL as NULL > '' won't return true. 🙂

where firstname >...

Would this help you?

SELECT CASE WHEN DateEnd = MAX(DateEnd) OVER( PARTITION BY ID)

AND DateStart > DateEnd

THEN DATEADD( dd, DATEDIFF( dd, 0,DateEnd),0)

ELSE DateStart END,

CASE WHEN...

DiverKas (6/21/2013)

GilaMonster (6/19/2013)

Will the users be happy if the data that the queries return...

I'm glad you could solved, I was working on a possible solution but I'm not sure that it will work for you. I'll share it anyway.

;with Vol_Factdata as

(

Select CASE WHEN...

Unfortunately, there's not much we can do without more details, DDL, sample data and expected results based on that sample data. These things will allow us to give you a...

Does this help you?

http://msdn.microsoft.com/en-us/library/cc645993.aspx#Reporting

Would this give you a clue?

SELECT CONVERT( date, CONVERT( char(8), NULLIF( Someintdate, 0)))

FROM (VALUES(20130601), (0), (20130515))x(Someintdate)

Is not easy to answer as they're not equivalent and can't be measured against each other.