Frankly it's a good sign you're interviewing with the CTO. Most places wouldn't waste the CTO's time unless a. you're a valued candidate and b. they might need to...

Pretty sure you have to be on 2008 R2 or later in order to be on a supported version.

The link below seems to be functional (assuming you sign in):

http://www.microsoft.com/en-us/download/details.aspx?id=11093

by the way - you will want to incorporate the event_date into the ORDER BY, otherwise the row_number() will essentially assign numbers within a group ad-hoc (i.e. not exactly "at...

I'd say - not nearly enough info to answer.

What would you do with the data from those unknown sources? Is the handling generic in some way?

Mike Osborne (1/11/2014)

---

I am using SQL server 2005, 2008 and 2012 so CTE's are OK

Thanks for your solution, but it looks a little messy as a view definition.

I was thinking...

Since you're in SQL Server 2000, we can't use any CTE for this. That said - you should be able to use a temp table to get the ordering...

If you're starting from scratch as your post implies, you might consider at least starting from any of a number of industry "standard" models, modifying them to fit your goals...

assuming you reuse you definitions of new and old (recommend you turn these into temp tables), then you could use something ilke the following:

with new as ( etc...),

old as (...

Is it fair to say that the providerID would NOT change? In order to compare an item in one of the buckets to an item in the other bucket...

Your table has an issue in that you are attempting to put both columns in using the same element and value, which SQLXML is not going to like.

That...

Short answer is - you can't get an XML tag called "str val", since XML does not allow for spaces in its tag names.

If you were to take...

Microsoft has a tool specifically designed for such a purpose, called the Microsoft Assessment and Planning (MAP) toolkit. It scans and detects all installs it can see (i.e. if...

The left join is odd indeed. Without allowing for NULLs in the join criteria, I'd imagine that the LEFT join behavior is being overridden to INNER join.(edit: removed the...

As long as you're only dealing with one ID at a time, you can use this syntax:

declare @id int

set @id = null

SELECT

CASE WHEN @id is null

THEN null

ELSE 'Forehead...

Sowbhari's solution is likely the most straightforward, but does have the (perhaps) nasty side-effect of forcing everything to lower case (i.e. data AND element names). If you absolutely must...