Adding a column header on count function

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » Adding a column header on count function

Adding a column header on count function

Rate Topic

Display Mode

Topic Options

Author

Message

wdillon

Posted Wednesday, April 30, 2008 1:08 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, January 19, 2009 2:06 PM
Points: 24, Visits: 100

Hi All:

Is it possible to add a column header to a count?

i.e. select count(*) from foo as employeeCnt

Thanks,

Bill

Post #493217

Jason Selburg

Posted Wednesday, April 30, 2008 1:11 PM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 7:55 AM
Points: 2,582, Visits: 3,552

You're close ...

select count(*) as employeeCnt from foo

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg

Post #493219

wdillon

Posted Wednesday, April 30, 2008 1:38 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, January 19, 2009 2:06 PM
Points: 24, Visits: 100

Thanks Jason, that worked

Bill

Post #493241

« Prev Topic | Next Topic »

Permissions