Formatting an SQL select
Hi, I am trying to format the SQL query i have below in order to have the CoLocalCount show up with '# of Locals:' in front of the actual Count itself. I have changed to count to varchar in order for it to be able to read text but no matter where i put the actual 'quotes' it errors out. Any help would be appreciated.
SELECT 'Company Name : ' + JE.NAME AS CompanyName,
--CoJC.Code AS CoLocalCode,
CAST(COUNT (CoJC.Code) AS varchar(25)) AS CoLocalCount,
JWL.NAME AS WorklocationName,
--WLJC.Code AS WLLocalCode
CAST(COUNT(WLJC.Code) AS varchar(25)) AS WLLocalCount
FROM dbo.Job_Employer JE
Where is '# of Locals:' supposed to be in the query?
DatabaseJournal Recent Articles
Executing SSIS Packages Using DTExec
What Every DBA Ought to Know About SQL Ser...
Redmond exploits MySQL uncertainty
Oracle Launches Oracle Global Trade Manage...
SQL Server 2008 RTM Support Ends April 13,...