Maintaining a Date/Time Last Updated Value

Using SQL Server 2000...
In support of a Web site's product catalogs; we will have at least two
tables [Products] and [ProductCatalogs].
The application needs to show the Date/Time any given product catalog was
last updated. For purposes of this "last updated date/time" value, we
consider the catalog as having been updated when [anything about the
catalog, itself] has been updated OR [any items presented in the catalog]
have been updated. This means one Date/Time value when either (1) the given
catalog's row in [ProductCatalogs] or (2) any associated rows in [Products]
have been updated. We do not need a complete update history - we only want
to know the last date/time an update happened to either the given catalog or
to any of the items presented in the catalog (and not any "per item" update
date/time).
One solution would be to have a column in [ProductCatalogs] of the DateTime
data type. The value in this column gets maintained by triggers on both
[Products] and [ProductCatalogs].
While that solution would work, I'd appreciate your perspective, opinions,
and alternatives - if any - before I go off and implement this.
Thanks!As far as I can see, you only need one datetime field on the table
ProductCatalogs. If you have only one way of updating your data (through
stored procedure) I would recommend implementing this logic in the stored
procedure. If not (or you think that someone could change data without using
sp) you would need to implement triggers.
MC
"Jeff" <Jeff@.NoSpam.com> wrote in message
news:u87GGjH9FHA.3020@.TK2MSFTNGP09.phx.gbl...
> Using SQL Server 2000...
> In support of a Web site's product catalogs; we will have at least two
> tables [Products] and [ProductCatalogs].
> The application needs to show the Date/Time any given product catalog was
> last updated. For purposes of this "last updated date/time" value, we
> consider the catalog as having been updated when [anything about the
> catalog, itself] has been updated OR [any items presented in the catalog]
> have been updated. This means one Date/Time value when either (1) the
> given catalog's row in [ProductCatalogs] or (2) any associated rows in
> [Products] have been updated. We do not need a complete update history -
> we only want to know the last date/time an update happened to either the
> given catalog or to any of the items presented in the catalog (and not any
> "per item" update date/time).
> One solution would be to have a column in [ProductCatalogs] of the
> DateTime data type. The value in this column gets maintained by triggers
> on both [Products] and [ProductCatalogs].
> While that solution would work, I'd appreciate your perspective, opinions,
> and alternatives - if any - before I go off and implement this.
> Thanks!
>

Maintain Report State

I have a matrix report where the user can drill down into a hierarchy to view
data for a particular product. The report also includes a parameter list
allowing the user to change the selected product.
The problem with this approach is that the user may drill to a specific
branch and then decide to switch products. At that point the report refreshes
and collapses back to the root node, because I have defined the report to
hide all groups on first entry.
Given that I am using Report Manager with no custom front end, does anyone
know of a good strategy to maintain state so that I can retain which groups
are expanded and collapsed for a particular user between instances of the
report?Modifying the Report Parameter causes the query to be executed. When this
happens the report is rendered from scratch. Hence you will not be able to
maintain the state of how the groups are displayed.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dave Morrow" <DaveMorrow@.discussions.microsoft.com> wrote in message
news:413E2C03-1362-4130-A16B-F7E371D2E0F3@.microsoft.com...
>I have a matrix report where the user can drill down into a hierarchy to
>view
> data for a particular product. The report also includes a parameter list
> allowing the user to change the selected product.
> The problem with this approach is that the user may drill to a specific
> branch and then decide to switch products. At that point the report
> refreshes
> and collapses back to the root node, because I have defined the report to
> hide all groups on first entry.
> Given that I am using Report Manager with no custom front end, does anyone
> know of a good strategy to maintain state so that I can retain which
> groups
> are expanded and collapsed for a particular user between instances of the
> report?

Lumigent Entegra

Hi there I was looking for people who use this product or something
similiar.
I'm doing an evaluation for a project where we need a strong
monitoring of DB activities on SQL 2000. After some research I saw the
Entegra, however the process to get price information already turns me
a bit away from the company.
So my question would be, how is the peoples experience with this
product, and second what alternatives are available ?
best regards
Andreas Palm
HP C&I .NET Development
8902 Urdorf, SwitzerlandIn my opinion it is worth every penny if you need that sort of information.
The UI is very good and the details you get are unmatched. If you really
need that type of a toll then they should be your first choice and in some
cases they are your only choice. Don't know what troubles your having with
the pricing but you really should give them a call or at least an email.
--
Andrew J. Kelly
SQL Server MVP
"Andreas Palm" <apa57@.hotmail.com> wrote in message
news:d0e0a20b.0307110312.45aa89a4@.posting.google.com...
> Hi there I was looking for people who use this product or something
> similiar.
> I'm doing an evaluation for a project where we need a strong
> monitoring of DB activities on SQL 2000. After some research I saw the
> Entegra, however the process to get price information already turns me
> a bit away from the company.
> So my question would be, how is the peoples experience with this
> product, and second what alternatives are available ?
>
> best regards
> Andreas Palm
> HP C&I .NET Development
> 8902 Urdorf, Switzerland