i think my version is fast , so should i use my version. or is there any thing wrong , so that i use yours.

my question is ,

is my version is correct or is there any harm in it?

secondly removing loop with set base is good?

third is there any way to write, my version,...

i have taught my team to use set based operation strictly, but there are cases where ,we are forced.

so specific to loop: i wanted to know...

this one might be taking range lock, pls see follwing.

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/16/1345.aspx

( i have tried to add reply but it site was not adding it so you may see this post more...

that one might be taking range lock pls see this one,

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/16/1345.aspx

this is what i ment,

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/16/1345.aspx

well my third question is not answered and one more question is

would u like to use 1) or 2)?

1) Select

*

FROM abc where abc.abcid =(select top 1 xyz.abcid from...

this one has alias, so that u can find which col belongs to which table.

1) select * from abc where abc.abcid =(select top 1 xyz.abcid from xyz where xyzid...

1) select * from abc where abc.abcid =(select top 1 xyz.abcid from xyz where xyzid =@xyz order by xyz.abcid )

2) Select * from df where df.dfid in (select distinct uz.dfid...

"Under what circumstances will changes be made to the glues on the marbles and the sequencing?"

when ever i want to attach two marble we use same glueid.

ex if i want...

1)"Under what circumstances will changes be made to the glues on the marbles and the sequencing?"

Glueid in marble table is only changed, When we want two marbles be connected to...

following is the step:

initially some sequence is given to marble table, at that time glueid in marble table are kept null.

then one by one glue is attached to marble to...

--All the marbles should be in order, Relating to the new attached glues.

1)ok, that means both queries are correct any one can be used?

2) i have chainged the join a.aid=i.aid

select a.aid, isnull(i.spoint ,j.spoint)

from #a a

left join #i i on a.Aid...