Home | Forums | Contact | Search | Syndication  
 [login] [create account]   Sunday, June 26, 2022 
View User Profile  

 User Profile - Mark Hallberg  
Mark Hallberg
(SalesLogix Business Partner)


Log in to send this member a message!

 Mark Hallberg's Contributions
Mark Hallberg has contributed 1 comments and 0 articles.
Select to view:    
Comment: Re: Generating Table IDs in T-SQL - Version 2

hello Jason, 

thanks for the great article.  I think I have the code and the SP working ok , but how can I capture the output?  When calling 

declare @NEXTID varchar(10)

exec Saleslogix_demo.dbo.usp_GetNextSLX_ID 'Salesorder', @NextID OUTPUT

I do get the next id to the console but I want to use that id in something like 

declare @NEXTID varchar(10)

exec Saleslogix_demo.dbo.usp_GetNextSLX_ID 'Salesorder', @NextID OUTPUT

insert into Saleslogix_demo.sysdba.SALESORDER 

           (salesorderid,ACCOUNTID,..yada yada )

SELECT    @NEXTID,...ect

from salesales order 


thanks much





Author: Mark Hallberg - 2/28/2012


 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2022 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
page cache (param): 6/26/2022 4:09:45 AM