<p>Yes, thanks a lot :-)</p>...

I've a xml document as below In above document, there few empty node like(notes,page_hotspots). How do i remove those empty nodes from xml document. Please help. ...

<p> <p>I've a xml document as below</p> <p><userdata pageid="page9" annotationSetId="80"><br />    <notes /></p> <p>    <notes><br />      <note id="332E7A17-3E57-3540-CC28-DFA1C68A7...

<p><b>Madhivanan, </b></p> <p>This data has to be presented in HTML format, Is there a way of generating the output from sql server? Then it would be easy to Bind it in HTML format with out any modification to the presentation code.</p>...

Help me to generate the values as below declare @temp table ( id int, value int, product_name varchar(100) ) insert into @temp values(1,100,'product1') insert into @temp values(1,100,'product2') insert into @temp values(1,100,'product3') i...

<p>Help me to generate the values as below</p> <p>declare @temp table </p> <p>(</p> <p>id int,</p> <p>value int,</p> <p>product_name varchar(100)</p> <p>)</p> <p> </p> <p>insert into @temp values(1,100,'product1')</p> <p>insert into @tem...

<p>Try This</p> <p> <p>SET ANSI_NULLS ON</p> <p>GO</p> <p>SET QUOTED_IDENTIFIER ON</p> <p>GO</p> <p> </p> <p> </p> <p>ALTER PROCEDURE [dbo].[ConsumerInsert]</p> <p>        @vchConsumerName varchar(50)</p> <p>...

<p>Thanks a lot Madhivanan. We had a dirty logic which took more than 20 seconds. Now from your solution its almost like a 2-3 seconds. </p>...

A table has a values as below, same number can be repeated in any order. 100,102,101 are repeated value, for these value i need to generate a same number only if they are consecutive values. 100 101 102 100 100 103 104 102 102 105...

<p>A table has a values as below,  same number can be repeated in any order. 100,102,101 are repeated value, for these value i need to generate a same number only if they are consecutive values.</p> <p> <table> <tbody> <tr> <td>100</td> </tr> <...