Dear Mr. Happy,

As u know that each keyword that is reserved shows with blue color

and LOOP also shows with Blue color within query analyzer..that's why i am

asking..but u do not...

Loop Keyword Not Found in the given link..

there is no reserved kyword like LOOP...

THEN WHAT IS ROLE OF LOOP KEYWORD IN SQL...

Hi friend,

I think you are right...

please send how to perform mirring or replication processs..

plz send some helpful link..of vedio link to batter understand

whole process..

thanks for your reply..

Hi Friend,

You Are Great you completely understand my problem

and you have fully solved the issue.

I am so much thankful to you to spent your valuable time to solve my query.

...

update statements are just like

set @sqlstatement=@sqlstatement+' '+'update TB_Class_result set ['+@subjectName+'_Class Test I]'+'=ts.[CL I] from TB_Class_result t join TB_RESULT_TERMI ts on ts.stu_id=t.stu_id and ts.subject_id='''+@subjectid+''' and ts.session='''+@session+''''

set @sqlstatement=@sqlstatement+' '+'update TB_Class_result set...

what is PIVOT Approch..

plz describe it by an example plz plz help me..

i have never use this approch ..plz send some documentation related to PIVOT approch..

Thanks!!

Hi Friend,

i am having a table named "Tb_studentDetails"

the create syntax is as follows

CREATE TABLE [dbo].[tb_studentDetails](

[Adm_no] [varchar](50) NULL,

[first_name] [varchar](50) NULL,

[mid_name] [varchar](50) NULL,

[last_name] [varchar](50) NULL,

[father_name] [varchar](500) NULL,

[session] [varchar](50) NULL,

[class] [varchar](50) NULL

)...

ok sorry friends,

now i am sending script of table definition with data

CREATE TABLE [dbo].[tb_studentDetails](

[Adm_no] [varchar](50) NULL,

[first_name] [varchar](50) NULL,

[mid_name] [varchar](50) NULL,

[last_name] [varchar](50) NULL,

[father_name] [varchar](500) NULL,

[session] [varchar](50) NULL,

[class] [varchar](50) NULL

) ON...

Thanks Your solution is best for me...:-)

Thanks Friend!!

You have solved my problem i am vary thankful to u.

Thank u again!!

Thanks for your suggestion....

I am currently working on a inventory software and this will store all record of inventory but the client wants to hide(because of excise checking by...