What version of SQL Server are you using? If you're using 2012, you could use something like this as the source for your dataset:

SELECT

custID

,OrderID

,OrderDate

,LAG(OrderDate) OVER (PARTITION BY custID ORDER...

If you use windowing functions, this isn't that hard. Since I didn't understand how the create table/insert statements were related to your question, this is a somewhat generic answer.

It...

Seems you would do that in Excel... nothing to do with SSRS.

You might be able to do this by using a Tally table. Jeff Moden has a great article on it.

http://www.sqlservercentral.com/articles/T-SQL/62867/

Itzik Ben-Gan's book on Window functions is good.

SELECT FORMAT(2504,'0000000');

Looks like this works:

SELECT EmployeeID

, MIN(CoverageCode1) AS CC1

, MIN(CoverageDate1) AS CD1

, MIN(CoverageCode2) AS CC2

, MIN(CoverageDate2) AS CD2

FROM vwCoverage

GROUP BY EmployeeID;

you would point to the calculated date if you wanted to do date calculations, comparisons etc. The 20040201 looks like a date (to you, not to SQL Server), so...

What are you trying to do with your SQL statement?

Definitely a case where some sample data would go a long way.

That said, I think you could use a UNION query to get what you want.

The great thing about it is that he walks you through all the gotchas and fixes them. I've been fighting with this stupid problem forever and finally found an...

This works, but I'm sure someone will correct it so it works better...

You would use your table name where I have "x" (just aliasing the select statement that contains the...

Finally got it sorted out... read this[/url] and followed the instructions (imagine that!). Figured Robert Pearl probably knows how to configure SSRS properly... not sure how I managed to...

In a query? Sure... it's a really old syntax, if that's what you're wondering. (I remember it from Oracle in 1999...)

thanks for the easily consumable data... (the only thing missing was the "extra" data so that you're sure it gets excluded).

Found this article discussing IN vs EXISTS, which was interesting......