I have read you requirements - and I deeply apologize. What I submitted was clearly not useable. Thanks for your patience and for pointing me in the right direction.

I am getting duplicate output whenever an AgencyID meets more than one condition. How can I stop this?

Code is here:

SELECT AgencyId, AgencyName,

...

Here is the updated code: Is there something wrong on the EXIST

clause?

SELECT AgencyId, AgencyName,

(

...

Here is my initial problem:

I need to pull info as follows:

I have a single table called Agencies and I am trying to pull these columns from it:

Select AgencyID, AgencyName,AgencyType, Count...

Here is my code, but i get an error that says:

Server: Msg 156, Level 15, State 1, Line 13

Incorrect syntax near the keyword 'FROM'.

SELECT AgencyId, AgencyName, AgencyType,

...

By docs, I mean documents. There is only one table containing all my data.

I do wish to post sample data, but, however, my employer has very private info and this would stir trouble. Can we please take this one step at a time?

The...