I never said that you are my servant ,i just simply asked you .let me ask you a question you are a nice guy who helps every one but why...

are you online can you guide me what to do with this issue which i am facing

CAN SOMEBODY GUIDE ME ON THAT

i know how to avoid the duplicates which vasc told me but wht should i do for the sort order in the table ClaimCounts_Test

CREATE PROCEDURE GE_Claim_Record_CountsTest

       @Month_of_file_filter datetime

AS

if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ClaimCounts_Test]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

CREATE TABLE [dbo].[ClaimCounts_Test] (

       [Month_of_file] [datetime] NULL ,

       [CalcAction] [varchar] (100)...

yes ,see when i run this in analyzer it works

SELECT CalcAction FROM ClaimCounts_Test

WHERE CalcAction='Total Record Count'OR CalcAction='Record Count of Unique Claims '

ORDER BY CASE

WHEN CalcAction='Total Record...

Thanks for the help but when i execute the proc

it still does not give my sort order which you created in

dbo.SpDemo

Hi Vasc,

Thanks for the reply but my question is that how do i incorpoarte that logic in my stored procedure.IF I RUN IN ANALYZER IT GIVES ME THE RIGHT RESULTS...

see you did not understood my question.Regarding my experience yes iam new that is the reason i am asking questions otherwise i would be like you answering questions.Second if you...

so can you help me on this becz when i run my logic in the query analyzer it works fine but how can i incorporate in the proc

ok

yes you did but i am not cleared yet so thats why iam asking again

i need to sort the order in my store procedure for this field

wht i do after i execute this proc i get a table which i link to access and generate a  report in excel.The format OF REPORT  is as below. IWANT...

thanks for the help