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'...

Sounds like you're using a tablix instead of a matrix, which it sounds like what you should be using. If you did this with a matrix, then the month...

Yes. Instead of just this:

;WITH CTE AS

(SELECT

row = ROW_NUMBER() OVER(PARTITION BY custID ORDER BY (Geography::Point(geo.latitude, geo.longitude, 4326).STDistance(geography::Point(prp.latitude,prp.longitude, 4326))/1609.34) asc),

ld.custID

prp.property_name,

distance_miles = Geography::Point(COALESCE(geo.latitude,0), COALESCE(geo.longitude,0), 4326).STDistance(Geography::Point(COALESCE(prp.latitude,0),COALESCE(prp.longitude,0), 4326))/1609.34

FROM

...

You add a parameter...

I think you have to do the TOP in the stored procedure, not in SSRS. If you can do it in SSRS, I have no idea how.

SELECT TOP (@NumRecords)...

Maybe like this?

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/5efe07a6-1ff3-4bfa-baf3-717f7f431c6f/open-url-in-a-new-window?forum=sqlreportingservices

If you had a column in a table for the Category that indicated if it were a debit or credit. then it would be really easy:

create a calculated column, I'll...

Can you explain what the trigger was supposed to accomplish? I didn't write your code, so I'm not sure what it's intended to do. If we had that,...

Exercise your GoogleFu skills...

Schedule a job in T-SQL

Even better answer...[/url]

Which was what? use an aggregate function in a control at the bottom of the report?

Must be the Alzheimers... I know I have read a few.

Yeah, answering based on flawed sample data will do that to you...

It looks like this works:

SELECT MedRecNum, VisitID, VisitDate, MAX(Answer) AS MaxAns

FROM

(SELECT 123 AS MedRecNum,7777 As VisitID,'03-14-14' AS VisitDate,1 As Answer

UNION ALL

SELECT 123,7777,'03-14-14',0

UNION ALL

SELECT 123,8888,'05-21-14',0

UNION ALL

SELECT 123,8888,'05-21-14',0

UNION ALL

SELECT 456,3333,'03-20-14',1

UNION...

Oh, I'm sure. Gail's was just the first I remembered. And if the boss can't take their word for it then all bets are off...

Not sure what to say. If you dig around here even a little, you'll find Gail Shaw's explanation of what NOLOCK really does. You might need to make...