Thank you very much .......This is working fine

Thank you very much

Where this table came from dbo.Numbers

I need rest of the columsn too......which are not same ......so i cannot do group by on those coloumns.......

Thank you very much....for your help.......you almost solved my problem.......

I want the output in these 3 columns the clolumns for example columns BON as 456 which repeats 2 times so i want the output as

like

TXNCD TXNCD ...

Thank you very much lynn

THEY ARE FIXED

@Christoper

Its working when i use nvarchar(max)

when i use nvarchar......it is not executing the entire proc......

CREATE PROCEDURE [IDENTIFICATIONCLAIMS]

(

@UniTab varchar(max)

)

as

DECLARE @sSQL varchar(max)

SET @sSQL=

'SELECT [RID] , DIS =''P1'' FROM

( SELECT [RID]

FROM '+@UniTab+ ' R7

INNER JOIN [dbo].[TABA1]...

EXEC sp_executesql @sSQL

there is no front end people......i need to display the result set in reporting.....If i use varchar it is print the proc.......but when i execute its is giving an ERROR:Procedure...

so is there any solution for this......

thanks a lot man.....