Database

Parent     Id     Name
-----------------------
0          1       Root
0          2       Root 2
1          3       Child 1
1          4       Child 2
3          5       Child 3
4          6       Child 4
9          7       Child 5

<NodeCollection>
   <Node rId=1 Parent=0 Name='Root'>
      <Node rId=3 Parent=1 Name='Child 1'>
          <Node rId=5 Parent=3 Name='Child 3' />
      </Node>
      <Node rId=4 Parent=1 Name='Child 2'>
          <Node rId=6 Parent=4 Name='Child 4' />
      </Node>
   </Node>
   <Node rId=2 Parent=0 Name='Root 2' />
   <Node rId=7 Parent=9 Name='Child 5' />
</NodeCollection>

@iParam varchar(100)  AS 
SELECT 
ipkClientsID AS [ID], 
tblClients.sClientName AS [Client: Client Name], 
(SELECT CONVERT(varchar(8000), sTextValue) FROM tblReportSummary WHERE       ifkID = tblClients.ipkClientsID AND       iParam = @iParam AND       sFieldName = 'Client: Postal Address Group (R)')  AS [Client: Postal Address Group (R)] FROM tblClients 

WHERE ipkClientsID IN (SELECT ifkSelectedItemsID from tblSelectedItems where sID = @iParam)

---------------------------
SQL Query Analyzer
---------------------------
[SQL-DMO]Object 'dbo.sp_retrieve_ageinginward_details' was not scripted. It is possible that the information in system table 'syscomments' about the object was corrupt or missing.
---------------------------
OK   
---------------------------

Server: Msg 3624, Level 20, State 1, Line 1
 
Location:	 recbase.cpp:1371
Expression:	 m_nVars > 0
SPID:		 57
Process ID:	 556

Connection Broken

CREATE TABLE UpdateInfo
(ID				int			primary key,
new				int,
click			int)

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER OFF



IF NOT EXISTS (select * from sysobjects where id = object_id(N'[dbo].[TransCheckifCurrentExists]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE PROCEDURE [dbo].[TransCheckifCurrentExists]

as 
declare @SQLstr nvarchar(1000)
declare @value int;



set @SQLstr = ''select  @value=count(*) from Trans where TransState = 1 and TransType = "SI"  ''


exec sp_executesql @SQLstr, N''@value int out'', @value out
return


'
END