Database

@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