PHWinfo - Afficher un message - Doing Summation on multiple criterias on the same column in a singlequery

24/03/2008, 19h39

> You put it the chart as free-form data and then you check his passport
> records. Hey, this is the usual missing/fuzzy data problem. What did
> you do when you never had a flag for that "bit" of data? What do you
> do when the important year was 1990? More bit flags? Have you ever
> considered what the triggers and constraints to keep the flags
> current?

The fact remains, some things are just that, flags... no further information
necessary, no updating required.

24/03/2008, 19h39	#7
Aaron Bertrand [SQL Server MVP] Messages: n/a Hébergeur:	Re: Doing Summation on multiple criterias on the same column in a single query > You put it the chart as free-form data and then you check his passport > records. Hey, this is the usual missing/fuzzy data problem. What did > you do when you never had a flag for that "bit" of data? What do you > do when the important year was 1990? More bit flags? Have you ever > considered what the triggers and constraints to keep the flags > current? The fact remains, some things are just that, flags... no further information necessary, no updating required.