<div>
Try this: 

<pre><code class="code-10 nolinks" id="code-124480">SELECT 
	CASE 
		WHEN servicename servicename LIKE 'SCSCXEPLUS%' THEN 'SCSCXEPLUS'
		WHEN servicename servicename LIKE 'SSE%' THEN 'SSE'
	END			AS ServiceNameGroup,
	count(*)	AS Number
FROM 
	tbl_Data 
WHERE 
	servicename LIKE 'SCSCXEPLUS%' 
	OR servicename LIKE 'SSE%'
GROUP BY 
	CASE 
		WHEN servicename servicename LIKE 'SCSCXEPLUS%' THEN 'SCSCXEPLUS'
		WHEN servicename servicename LIKE 'SSE%' THEN 'SSE'
	END 
</code></pre>
</div>

<div>
while executing the above query i a, getting error msg like this: 
 
Msg 4145, Level 15, State 1, Line 3 
An expression of non-boolean type specified in a context where a condition is expected, near 'ServiceName'. 

</div>

<div>
Sorry i typed servicename twice in the case statements, try this: 

<pre><code class="code-10 nolinks" id="code-124542">SELECT 
	CASE 
		WHEN servicename LIKE 'SCSCXEPLUS%' THEN 'SCSCXEPLUS'
		WHEN servicename LIKE 'SSE%' THEN 'SSE'
	END			AS ServiceNameGroup,
	count(*)	AS Number
FROM 
	tbl_Data 
WHERE 
	servicename LIKE 'SCSCXEPLUS%' 
	OR servicename LIKE 'SSE%'
GROUP BY 
	CASE 
		WHEN servicename LIKE 'SCSCXEPLUS%' THEN 'SCSCXEPLUS'
		WHEN servicename LIKE 'SSE%' THEN 'SSE'
	END 
</code></pre>
</div>

<div>
i executed this query it is only returning SCSCXEPLUS data not 'SSE , so can it possible to use the cursor to find the solution.
</div>

<div>
<div class="content wysiwyg-content">
i have table named table tbl_Data.In it there is a column name servicename .This column has number of records like SCXE1023PLUS,SCSCXE10234PLUS,SSE1024,SSE10245.So i need a stored procedure that will first fetch the number of records like SCSCXEPLUS and &nbsp;SSE. I need help on it.
</div>
</div>

i have table named table tbl_Data.In it there is a column name servicename .This column has number of records like SCXE1023PLUS,SCSCXE10234PLUS,SSE1024,SSE10245.So i need a stored procedure that will first fetch the number of records like SCSCXEPLUS and  SSE. I need help on it.

how to  use substring function in sql server 2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.