You'll have to inventory your licenses (invoices, install media) and compare that to an inventory of installed instances.

Cross apply does the same thing.

And, actually, that'll give you possible row-multiplication if someone has, for example, twin boys on one of those dates and thus has two child rows that qualify.

This might be better:

SELECT

...

You need to join twice:

SELECT

r.FirstName,

r.Surname

FROM

dbo.tblRespondents AS r

INNER JOIN dbo.tblRespondentsChildren AS rc_1

...

If you insert 1 row into AddressInfo and then use scope_identity(), it will give you the ID number you just inserted.

If you're worried about it, start small and add counters as you need them.

You could do something like this:

WITH CTE

AS (SELECT

...

jcrawf02 (12/8/2010)

Grant Fritchey (12/8/2010)

Yeah, I'm looking forward...

Can you post the view you're trying to query this from?

I'd suggest submitting it to Steve (the site's editor) by using the Write for Us link (to the left), for the scripts section, or the articles section. In either...

select vendorname, vendoremail

from dbo.MyView

where priority between 1 and 3;

Won't do it?

The problem with views is that devs will want to build "one view to rule them all, one view to bind them, one view to bring them and in the...

I'm not clear on what you're starting with and what you want to end up with.

As in, it's meant to return 31 with that input? (Assuming it uses standard arithmetic priorities.)

You're welcome.