I got the solution.

Create proc P1_Show_EmpDetails

(

@EmpCode varchar(10) -- User may give more than one value as COMMA SEPERATED value

)

AS

BEGIN

Declare @_EmpCode varchar(10)

Select @_EmpCode = ','+ @EmpCode +','

Select Eno

from Emp

where patindex('%,' +...

Chris,

Thanks a lot. I appreciate your timely help !

what is the rowcount of import_cc_payments table ?

it is comment section, User will enter like this only, based on the comment i have split.

I reached some point, But i am unable to do it successfully.

Declare @holdingAndWeightAndComments varchar(255)

Select...

So the sequence which i said was correct according to Inside SQL Server 2005: T-SQL Querying

Try out this one.

sp_depends yourprocname

or

use sysdepends table.

Peso,

Can you help me to convert the below formula's also ?

http://www.styleadvisor.com/support/statistics/standard_deviation.html

http://www.styleadvisor.com/support/statistics/cumulative_return.html

http://www.styleadvisor.com/support/statistics/mean.html

http://www.styleadvisor.com/support/statistics/variance.html

Peso,

Thanks ! Sorry I don't have the test data. I will ask my manager and get back to you.

rbarryyoung,

Thanks a lot ! I really appreciate your timely help !:)

I have checked the procedure and fixed the issue sucessfully. Also i got the appreciation mail from my manager. Because...

rbarryyoung,

I got the above error message. Please check it.

Truncation error occured.

Command has been aborted.

I got it...:) Yes,Just i turn off the below one.

set arithabort off

is it a wise decision ?

I got the result now. It is matching with the excel report. so...

Can you attach the output get from the query ?

rbarryyoung,

Though i changed the table structure, I am getting the same error message.

create table PROD_issue

(

MID varchar(15),

Dt1 decimal(5,3),

Dt2 decimal(5,3),

Dt3 decimal(5,3),

Dt4 decimal(5,3),

Dt5 decimal(5,3),

Dt6 decimal(5,3),

Dt7 decimal(5,3),

Dt8 decimal(5,3),

Dt9 decimal(5,3),

Dt10 decimal(5,3),

Dt11 decimal(5,3),

Dt12 decimal(5,3)

)

go

rbarryyoung,

I am getting 'TRUNCATION ERROR OCCURED' message when i execute the code.

I think somewhere else data lenght is crossing the maximum limit. Please correct me if i am wrong.

Carl,

Joe's code...