You can think of patitioning the table based on week/Month and drop the partition

PLEASE find the attached code here we are creating Columns on the basis of Third_Party_Code_PL column value (ie [CARE],[U007] ) and storing Paid_Amount_PL value in it

create table #temp

(

Patient_IDvarchar(500),

CH_Claim_Novarchar(500),

Third_Party_Code_CHvarchar(500),

Billed_CHvarchar(500),

Patient_ID_PLvarchar(500),

Third_Party_Code_PLvarchar(500),

Claim_No_PLvarchar(500),

Paid_Amount_PLvarchar(500)

)

insert into #temp

(

Patient_ID,CH_Claim_No,Third_Party_Code_CH,Billed_CH

,Patient_ID_PL,Third_Party_Code_PL,Claim_No_PL

,Paid_Amount_PL)

values

('1000'...

In the above query which kind of secoundary xml index will be good for extracting the data from xml if the xmls are sored in a table.

String1=Panadol

String2=XYZadol

String3=xyadolz

String4=xynadol

string5=lodanap (Same as panadol but in reverse)

In the above example "String 5"has less the 3 differences compared to "String 1" so it should be shown as failure right?

Instead of writing convert(float,column_name) use convert (numeric(X,Y),column_name) .this would solve your problem

Or

You can first cast it to Sql_variant and then to Varchar

Example

convert(varchar,Convert(Sql_variant,column_name))

You can use Label: and goto statement to redirect it to the end of the stored procedure