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

I think he's talking about something more like this, but this is PowerView in Excel 2013...

http://office.microsoft.com/en-us/excel-help/maps-in-power-view-HA103005792.aspx

Luis,

Outer apply... I should have figured. Still trying to get my head around that one... I mean, I know what it does, but remembering to use it... I...

That's what I was thinking at first, but the two values are not in the same record. That's why there's all the weird coding...

This seems to work... If you post consumable data (create table scripts, and inserts), it's a lot easier for people to help you - since you've set up the...

DECLARE @InputString VARCHAR(15) = '1.234;0;0;0;0;0;0;0';

PRINT LEFT(@InputString,(CHARINDEX(';',@InputString,1)-1));

Not much to go on here, but there are two parts to filtering a dataset if you are using report-level parameters that you define yourself (as opposed to inheriting them...

What type is the parameter? Should be an integer. then you can do something like

=Parameters!EndWeekNo.Value + 1