No data was returned with the first query.

Seems to prefer this, but I'm not sure how spaces consistently ended up in the data:
SELECT   ProjectNumber, ProductName
FROM    JobDetail
WHERE   (ProjectNumber LIKE '%16-2506%')

I...

Chris:

This last post works great!  I just would not mind having a textbook that goes into these things a little deeper.  Do you know if one exists?

Chris:

Much thanks for your patience.  I have read a few books and just do not see this.  Can you tell me a good reference to purchase for the...

Hello:

My dilemma with this is that the last solution is no different than my first, except that it returns more data.  My goal is to return less data here.  I'm...

sgmunson:

Thank you so much for the help on this.  Here is the solution:

WITH P AS (SELECT DISTINCT F.DocumentID, F.[Filename], F.LatestRevisionNo, V.ValueText, V.VariableID
...

It seems to work, except for RV.Revision No. 
Don't I need to somehow include this.  You have a column called recentness with a descending value for RevisionNo, so it seems.

In my...

Good call, table fields.

When I do the alias, I need to add ON, such as ON V3.DocumentID = V.DocumentID.
DocumentID seems to be the only field available to...

Okay, I figured the table thing out, but how does this help me?  How to I harvest that data.  

I realize this is confusing, or at least I...

Can you tell me what variables to do this on?  This format loses the Pivot Table, and VariableID is not available.

Thanks!

SELECT DISTINCT F.DocumentID, F.[Filename],...

Hello:

So this seems to have addressed my issue with the PIVOT portion of this query.  Can you tell me, what is wring here?  It dows not seem to...

Hello:

Thanks for your reply.

I created the table, but I do not see it anywhere?  Can you guide me to where it put it, or how to...