Makes more sense now.  So you want columns returned for the 'Fed' values and columns returned for the 'state' if they exist.

You could set up multiple joins to...

Still not clear to me what you are after.

If this is a one to many:
INNER JOIN VisualCACTUS.ProviderLicenses AS l
  ON p.Provider_K = l.Provider_K


Not real sure what you are asking for.  Are ou wanting to set a field in your select statement for licensetype?  You could use a CASE statement for that.  Or...

Based on the assumption that the report_begin_date will always be the first date of the year, this logic will get the correct dates.  If you calc the 1 year back...

If you do an inner join to the BUD table you shouldn't need the EXISTS.
SELECT GLT.GLL_Account AS Account,
    GLT.Amount AS Current_Expenses,
    GLT.COP_Period AS Period,
    GLT.GLT_TransDate AS Trans_Date,

"I'd rather take lower pay and work 40 hours/week versus a higher pay and not have a life."  
I had this conversation in an interview.  A couple years ago I...

Here is some SQL I stole that will search across all databases on the server.

DECLARE @sql VARCHAR(8000);
DECLARE @SearchText NVARCHAR(255);

You will need to give more details for the best answer.  Look at what Indexes are on each table and provide that info.  Table definitions, and some sample data would...

I would use SSIS to bring in the CSV file into a SQL table, as mentioned earlier.  Then use SQL to compare the data. 

You could look at the...

A DBA walks into a restaurant, then runs screaming from the building.  Why?  All of the tables were empty.

What do you get when you cross a shark with a porcupine?  A SQL(sea quill).  Or SQL BITeS