PHWinfo - Afficher un message - Re: Doing Summation on multiple criterias on the same column in asingle query

25/03/2008, 00h19

--CELKO-- (jcelko212@earthlink.net) writes:
> I define a flag as a binary value which is set by an event. Can you
> give me an example of a flag that is set without an event?

Can you give example on any database column that is not set as the
result of an event.

In our database, the accounts table has an istemplate column. It never
changes during the lifetime of an account, but obviously the fact
that the account was created is an event.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

25/03/2008, 00h19	#2
Erland Sommarskog Messages: n/a Hébergeur:	Re: Doing Summation on multiple criterias on the same column in a single query --CELKO-- (jcelko212@earthlink.net) writes: > I define a flag as a binary value which is set by an event. Can you > give me an example of a flag that is set without an event? Can you give example on any database column that is not set as the result of an event. In our database, the accounts table has an istemplate column. It never changes during the lifetime of an account, but obviously the fact that the account was created is an event. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx