No I have about 10 departments

OK will try as you have suggested and give you a feed back,

but it is 2005 I am using so what do you suggest

Thanks

Hi Thanks,

Can I please send you the query so you modify it for me?

Thanks

The query is as follows

USE [HQRMS]

GO

CREATE PROCEDURE [dbo].[sp_getSummarySalesReport_By_DeptTest]

(@DATEFROM AS DATETIME,@DATETO AS DATETIME,@DEPARTMENT AS NVARCHAR(50))

AS

SELECT DEPARTMENT.NAME AS...

Hi could you please explain the last part of your answer about the delimited list as a string

Thanks