This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_000_01C06B76.81FFE54E
Content-Type: text/plain;
	charset="iso-8859-1"

Here it is
Thanks,
Lindy


-----Original Message-----
From: Kim, Cardyin [mailto:CKim@s...]
Sent: Thursday, December 21, 2000 12:23 PM
To: professional vb
Subject: [pro_vb] RE: Parameter for MSSQL70


Lindbergh,

Can you send a copy of the
stored procedure definition on your
SQL server?  Just the top part of
it should be fine

EX:
CREATE PROCEDURE SP_SELECT
@Id VARCHAR(40)

--------------------------------------
Cardyin Kim
System Analyst - Information Services
San Antonio Community Hospital
ckim@s...     (xxx)xxx-xxxx     
--------------------------------------


To unsubscribe send a blank email to leave-pro_vb-$subst('Recip.MemberIDChar')@p2p.wrox.com


------_=_NextPart_000_01C06B76.81FFE54E
Content-Type: text/plain;
	name="Adrecord.txt"
Content-Disposition: attachment;
	filename="Adrecord.txt"


/********* Lindbergh Cupello - 12/21/2000 ********/

CREATE PROCEDURE LC_Save_PO_Message 
			(
				@PO_Number VARCHAR(18),
			 	@OrderXML TEXT,
			 	@Param_For_Tries SMALLINT,
			 	@Param_For_Timeout SMALLINT,
				@MessageID SMALLINT OUTPUT
			)

 AS

INSERT INTO dbo.ExRRMain
				(
					PO_Number,
					OrderXML,
					Time_Stamp,
					Counter_Of_Tries,
					Param_For_Tries,
					Param_For_TimeOut
				)

VALUES			(
					@PO_Number,
					@OrderXML,
					GETDATE(),
					0,
					@Param_For_Tries,
					@Param_For_TimeOut
				)

/* Move the IDENTITY value from the newly inserted record into our OUTPUT parameter*/
SELECT @MessageID = @@IDENTITY


------_=_NextPart_000_01C06B76.81FFE54E
Content-Type: text/plain; charset="us-ascii"
Content-description: footer

---
You are currently subscribed to pro_vb as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-pro_vb-$subst('Recip.MemberIDChar')@p2p.wrox.com


------_=_NextPart_000_01C06B76.81FFE54E--