i misinterpreted it and thought he wanted the the current status and the prior status (which is a requirement we often have to meet with history tables).

Jeffrey Williams (12/3/2008)

---

Is this what you are looking for?

;With history (regid, status, history_date, rn)

As (Select reg_id

,status

...

i think something like this will do it.

select * from

( select t1.reg_id, t1.status, t2.status as prior_status, t2.history_date,

row_number() over (partition by t2.reg_id order by t2.history_date desc ) as seq

from table1...

Jason Akin (12/2/2008)

---

This doesn't work for a LIKE condition, but for equalities in a small number of fields, you can use

WHERE '411-555-1212' IN (HomePhone, WorkPhone, CellPhone, AltPhone)

I've found it...

is this a 2005 matrix or a 2008 tablix report?

if a 2005 matrix, your rectangle should fill the entire corner. then just size your heading boxes to your desired...

i don't quite follow you -- a screen shot would be helpful. in the meantime, you might want to try placing a rectangle in the corner. you can...

JKSQL (8/13/2008)

---

you have to think larger scale on this. This is one proc that you can send any table in a relational DB and it deletes all data pertaining...

a good data modelling tool can generate a cascade delete trigger for you. so that proc/table seems to be reinventing a wheel.

append to #2: dynamic SQL. can be hard to read and more difficult to maintain.

i meant no offense. i'm just saying that sometimes there are no shortcuts or tricks. sometimes you gotta code what you gotta code even if it is laborious.

Mark Eytcheson (8/12/2008)

---

Thanks Antonio,

But eliminating that scope gives me the percentage of "Met" or "Not Met" for each month per the year for each user.

Ex:

...

the report viewer inteface is more/less fixed. if you have a web app, you would have to create your own interface to collect the parameters and then send those...

i'm surprised that you're surprised by this. if you want to find people based on height, weight, age, gender, race, hair color, and eye color then you're going to...

here's faster alternative built on the attached function fListToVarchars(). (it has embedded less than characters and never displays properly.) put it in your common/global db:

USE [global]

GO

SET ANSI_NULLS ON

GO

SET...

move the table's sort expression(s) to the group's sort expression(s) then set the table's sort expression to properly sort the groups.

table sort: stateName

group sort: cityName, zipCode