Is the schedule of sessions relevant? If so, could you post the DDL for the create/insert statements?

You might want to search for Itzik Ben-Gan's "Gaps and Islands" solutions. (His book...

The most flexible way of doing this is to create a Calendar table in your database and populate it. Then you can join in...

Got part of the way there... must have done something silly, because the math looks backwards... I created some sample records to play with... hopefully it's enough.

SELECT EmpID, InOutDate

,MIN(InOutTimeStamp)...

I almost feel cheeky answering this - only because you are so close.

You can set the Visibility of a chart/tablix/control by setting the Visibility Property of the chart/tablix in question:

Choose...

Sounds like you need 3 tables:

Company (CompanyID INT IDENTITY(1,1) PRIMARY KEY...)

EconActivity(EconActivityID INT IDENTITY(100000,1) PRIMARY KEY...)

CREATE TABLE CompanyActivity(

CompanyID INT,

...

Google is your friend.

http://www.pcmag.com/article2/0,2817,2404258,00.asp

http://ocz.com/consumer/ssd-guide/ssd-vs-hdd

instead of starting there, why not find out what the exam covers and then do it the hard way: PRACTICE. Try to incorporate as many features of SQL Server...

How do you get from one dataset to the other? What transformations are you doing?

Either my psychic powers are failing or you have left out a significant part of...

Several options:

- add either a DISTINCT to your query, so that it returns one row for each unique set of values

- add a group to your report and put...

Change the format of the textbox from c2 (currency, two decimal places) to n2 (number, two decimal places)

This video shows you how to create subreports

https://www.youtube.com/watch?v=6S8Zzqthsbw

Given that what you're trying to do is conceptually very simple, you could do this really easily if you created a table in TempDB, indexed it and added your value...

Given that what you're trying to do is conceptually very simple, you could do this really easily if you created a table in TempDB, indexed it and added your value...

Please give an example of what "redundant" means to you based on the data you provided. Apologies, but "doesn't work" doesn't mean very much. In what context? ...

If you had the wizard configure SSRS for you, you're all set. Are you using thee installation to learn or to work? If it's for work, they may...