Salakhetdinov Shamil
mcp2004 at mail.ru
Tue Dec 4 08:26:53 CST 2012
Hi John -- Sorry, I should have written: Try SUM(ISNULL([YourColumnName],0) Thank you. -- Shamil Вторник, 4 декабря 2012, 18:24 от Salakhetdinov Shamil <mcp2004 at mail.ru>: > > > > >Hi John -- > > Try > > Count(ISNULL([YourColumnName],0) > > Thank you. > > -- Shamil > > > Вторник, 4 декабря 2012, 9:09 от jwcolby <jwcolby at colbyconsulting.com>: > > > > > > > > > > > > > > >I am doing counts for a set of columns. The values in the column are either 1 or 0 signifying true > > > or false. If I just do a count() as xyz all the columns give a count equal to the total number of > > > records. I need to do a count of a value of 1. > > > > > > I discovered that if I change one of the 0 values to a NULL then the record with Null does not get > > > counted. Thus I could go through the table updating each field which uses this method = null where > > > '0'. > > > > > > Obviously this is a lot of work I would like to avoid. However it might be faster(?) to do the count? > > > > > > My preference however is to somehow tell the count() of each column to only count values of '1'. > > > > > > Is this possible in TSQL? > > > > > > -- > > > John W. Colby > > > Colby Consulting > > > > > > Reality is what refuses to go away > > > when you do not believe in it > > > > > > -- > > > AccessD mailing list > > > >AccessD at databaseadvisors.com > > > >http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > > > > > > > > > -- > AccessD mailing list > >AccessD at databaseadvisors.com > >http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > >