This appears to be a method by which we will be able to move the data but what about some way to keep it up to date?

This is what I ended up coming up with and it returns the correct data but I have been told that using "LIKE" is a "no-no".

SELECT iAvailable = CASE...

Thanks, you helped me come up with this:

CREATE VIEW dbo.fullSchedule

AS

SELECT i.name, i.Slot, s.customerID, i.aDate

FROM (SELECT ...

This is really close but it does not generate the dates for future jobs. I generated a dateTally table similar to what you did for the next 30 years. Would...

Installers Table

id name ...

Ok maybe I should go about this a different way, because I guess I am not clearly explaining what I need to get done.

An alternative to what I explained before...

I do apologize for my hasty post.

I am trying to find the #file_info.[fi_username] that caused the #file_modify.[ChangeType] from the data contained in the #file_info

It may be very general and...

Yeh, that only returns a single row

I came up with this but I am unsure if it is actually returning what I expect.

SELECT TOP 100 PERCENT towergrid_reference_natowers_1.origin_latitude, towergrid_reference_natowers_1.origin_longitude,

...

Thanks Lowell, you helped by helping me learn how to describe the problem as a "conditional count" thanks very much for that extra bit.

I didn't realize that it would act almost like a cursor processing through the records like that, I must rethink my whole sql knowledge now.

Very very nice, That's awesome. Not sure how I would ever come up with such a solution.

No it gives a total of the whole table with the < 1, I am looking for the result for each individual lat, lon combination.

Now, I am not necessarily looking for the solution but maybe to a site that might have the answer even with some reading. (Trying to learn this, not get someone...

Thanks alot for pointing me in the right direction.