Sean,

I had to cheat and add an extra record, because I needed to check the grouping... (should have mentioned that).

To the OP...

If you're asking for help, please help...

Sean,

I had to cheat and add an extra record, because I needed to check the grouping... (should have mentioned that).

To the OP...

If you're asking for help, please help...

Good to hear!

You're welcome =)

In a SSRS 2008 report, I will have between 1 to 30 different small ssrs reports that will be executed in a specific order. All the reports will pass the...

What's the rule about the 52 weeks? Do they start at the first of the year, or is there some other rule for that?

I figured that since he was new, I would be nice and show him how to set up the problem so that people could help...

to the OP - if ...

Turns out I did that same thing when I first tried it... You have to wrap the units in double quotes, because this is .NET, not SQL (so the rules...

If I use the same column names in my underlying database tables, is it possible to use them in an existing report to refresh data for new quarter without wiping...

I would like to call other reports based upon selections that users make and/or possibly calling the other reports based on values stored in a table in sql server 2008...

Does this work for you? (Seems not).

Set up some tables/data for folks to use...

USE TempDB;

GO

CREATE TABLE #WorkHours (

ID int

, PersonnelNo int

, WeekEnding date

, WorkedHours decimal(4,2)

, ContractHours decimal(4,2)

);

Insert some...

Thanks, Sean... that's what I was thinking!

Okay, you can filter your dataset so that you can only see the current year.

SELECT <column list>

FROM <table>

WHERE YEAR([SomeDate])=YEAR(GetDate())

(Not sure that's going to perform well, but one problem at a...

I would think you could use this article[/url] and use a job to write daily to a table... You could just need to grab the date the records were...

I must be getting better at this! <g>

I don't think you need most of this in your query:

SELECT d.name, a.dealer_code, b.last_name, b.city, b.state, b.phone

, COUNT(CASE WHEN MONTH(c.Funded_date) = 1 THEN...

If you're using SQL 2012, you can use LAG:

SELECT Category

, Code AS CurrCode

, LAG(Code) OVER (ORDER BY Category, StartDate) PrevCode

, CASE WHEN LAG(Code) OVER (ORDER BY Category, StartDate)<>Code THEN 'Changed'...