Hi , Thanks for you update.

I am looking for like a function to insert data like below instead of creating insert statement in your query.

select Name,Value1,Value2,Value3 from functionSplitter(@var,...

Hi ,

Thanks for your reply 🙂

Now I have small issue , I have same subject with different marks (English subject ).

How do I concatenate distinct subjects with sum of all...

Hi parulprabu ,

Thanks for reply again ,

Actually in month column does not has in order 1,2,3,4...

It may be some time month column M1,M2,M3,M4 .etc

so case condition not suitable...

HI parulprabu ,

Thanks for your reply .

Almost correct output

nameMarksMonthsubject

Kumar801~0maths

Guna301~2science

Kumar502~0physics

Guna-302~1science

BUT, Is possible to show the actual month 1~2 instead of 1~0

I have to validate with Month column after...

Hi pietlinden ,

I need to find the variance between month 1 and 2

For Name Guna in month 1 70 marks in science subject...

Hi Sir,

Now i have another issue in relating with CTE

Kindly refer the attachment and advise me .

I have to add another table with left join , This is...

Yes 🙂 , I fixed . before i just assigned 0 instead of '0' for Groupcallid.So its considered as Integer . now i changed ,its working fine . Thanks.

Thanks for your response.

Hi Team,

Now I have issue in with CTE ,

Msg 245, Level 16, State 1, Procedure usp_utilservice, Line 885

Conversion failed when converting the varchar value 'GrpCall-399900' to data type int.

Kindly...

Really awesome ! you are a genius !!!

Its working ....Thanks a looooooooooooot

Kindly refer the attachment ,

Id will not coming with order .

Note : Combination of each row is ID and previousrowid

Thanks For your Reply🙂

But Still Value1 shows 0 , It should be show previous row total .

And one more important thing,

inner join CTE1 b ON a.Id = b.Id+1

id+1...

com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 112) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

2010-11-09 04:00:05,849 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)

2010-11-09 04:00:05,849...

i dont have a any same column like id..

two table column's are fully different...

Kindly advise me how to add two temp-table columns

Dear All,

Thanks a lot Alvin Ramard.............:-)