Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Monday, August 3, 2020 
 
View User Profile  

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

fjrigjwwe9r1SiteUser:UserBio
fiogf49gjkf0d


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
fiogf49gjkf0d

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


mark


 


 


 



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 © 2020 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): 8/3/2020 1:33:17 PM