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...

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...

my question was some thing else , that is with out N it is working.

now u have written N which is also good , but i am trying to understand...

hi,

thank u,

i know about capital N , but i wanted to understand , if i have not used any char of Unicode in my xml, then why

capital...

yes i think this was the reason

well some body said DBCC UPDATEUSAGE (0); is also needed, is it correct?