Nor with certifications. You just have to get experience building databases and dealing with problems that come up.

Since nobody else has ventured an answer, I guess I'll try it...

Importing the HTML text shouldn't be a big deal, because it's just ASCII text. If you declare...

Cant read it - maybe because I only have Excel 2010. Another reason to post table definitions and inserts for sample data.

If you really need help, read this article...

Can't help thinking this would be a whole lot easier if you had a date field in the EmployeeRoles table...

Then you could just get the EmployeeID and Role With the...

The union query was just to create records I could manipulate based on the data you provided. I added the identity column because I needed a way to connect...

How do you know which values go together? Is there a primary key for the table that matches the records?

DOB LNAMEFNAMEMNAME

20140109 NULLNULL NULL

NULL NULLNULL JACK

NULL NULLJOHN NULL

NULL SMITHNULL NULL

End...

No idea what's going on. Any chance you can upload a copy of the report with some fake data embedded? The data source would be a union query, e.g.

SELECT...

Here's how to post data so people can mock up your data:

SELECT '3-31-2013' AS EOM_Date

, 'RA' AS Logs

, 'Valid' AS Reason

, 5 AS Units

UNION ALL

SELECT '3-31-2013'

, 'MA'

, 'Need to Complete'

,...

Right-click on the dataset, choose Add Calculated Field, and then add the calculated expression to your dataset. Then you can filter/sort on that column.

Welcome aboard, young Jedi.

Any chance you could post some sample data? I'm not sure if I understand what you mean or are trying to achieve. (So a simple example...

Got one to work... The part that tripped me up is that the gauge is expecting a numeric value for the state, so if you pass a string/text to it,...

Is there an index on the column "ID"? If not, there's your problem. Check the execution plan for the query - that will show you what's going on...

or maybe (From a database I had handy)

SELECT p.ProtocolNo

FROM Protocol p

WHERE NOT EXISTS (SELECT 1 FROM Enroll e WHERE e.ProtocolNo = p.ProtocolNo);

ProtocolNo is the primary key of Protocol, so that's...

Might have to go get his book... I'd love one that's actually easy to read. Lachev's book is pretty good, but a rough read.

Not sure you can do what you want (basically like the data in the margins in a phone book), but this is as close as I could find:

http://blogs.msdn.com/b/robertbruckner/archive/2008/10/26/fields-in-page-header.aspx

After further research...