Hi,

i need urgent can you please tell me

how can i separate with "," for two columns

in while loop i used

select @blnostr = @blnostr + substring(blno,0,len(blno)+1)+' , ', @bltypestr...

Dear All,

I have some doubts please clarify,

I have used two variable to divide by using "," in while loop .

how to implement in your query

------

while loop query

Declare @blno varchar(20)...

Dear All,

Kindly advise me is it correct ,1st part while used data , Part 2 newly i created

if it is anything wrong in my coding please advise ...

Thanks for...

Hi,

i dont know what is this line can u explain

FOR XML PATH('')) iTVF (dgclass)

Hi ,

first many thanks for ur reply !!!

I tried but i can't do ,

can u please post again your code for my updated code ???

i...

Hi ,

I applied ur suggestion it's nice

can u please check below one and advise me

how to avoid while loop in this below case :

SP:

-----------------------

Declare @BLconc varchar(20) ...