Store Procedure OutPut Column name

• GUID

  SSC Veteran

  Points: 277

  More actions

  May 15, 2011 at 3:57 pm

  #389530

  Hi Everyone,

  This is my first time posting on this forum.

  DECLARE @LoginG as uniqueidentifier = (select l.LoginGUID from login l inner join EmailQueue eq on eqo.OriginatingColumnValue = l.LoginID and eqo.EmailQueue = 100228 ) , @QuickLinkTypeG as uniqueidentifier = '55B6CC66-D43B-4D0E-BA1B-FA167CBC7D86', @LGUID as uniqueidentifier = NULL, @QuickLink as varchar(max)

  EXEC [dbo].[usp_QuickLink_Basic] @LoginG,@QuickLinkTypeGUID,@LGUID, @QuickLink OUTPUT

  I would like to return the data from the store procedure with different column name. Currently it returned as below

  QuickLinkURL

  http://www.test-dev.lan/?qL=6657280A-B968-4A4C-A66FBC-C9AB09BB14

  I wanted to populated as bellow without updating the store procedure.

  Results

  http://www.test-dev.lan/?qL=6657280A-B968-4A4C-A66FBC-C9AB09BB14

  Thank you,

• Jeff Moden

  SSC Guru

  Points: 1004340

  More actions

  May 15, 2011 at 4:50 pm

  #1324807

  the_hichamus (5/15/2011)

  ---

  Hi Everyone,

  This is my first time posting on this forum.

  DECLARE @LoginG as uniqueidentifier = (select l.LoginGUID from login l inner join EmailQueue eq on eqo.OriginatingColumnValue = l.LoginID and eqo.EmailQueue = 100228 ) , @QuickLinkTypeG as uniqueidentifier = '55B6CC66-D43B-4D0E-BA1B-FA167CBC7D86', @LGUID as uniqueidentifier = NULL, @QuickLink as varchar(max)

  EXEC [dbo].[usp_QuickLink_Basic] @LoginG,@QuickLinkTypeGUID,@LGUID, @QuickLink OUTPUT

  I would like to return the data from the store procedure with different column name. Currently it returned as below

  QuickLinkURL

  http://www.test-dev.lan/?qL=6657280A-B968-4A4C-A66FBC-C9AB09BB14

  I wanted to populated as bellow without updating the store procedure.

  Results

  http://www.test-dev.lan/?qL=6657280A-B968-4A4C-A66FBC-C9AB09BB14

  Thank you,

  You'll find that a lot of people don't cotton to visiting URL's because of SPAM, lost leads, etc, etc. My recommendation is that if you need help, you either post it or attach it to a post.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• GUID

  SSC Veteran

  Points: 277

  More actions

  May 15, 2011 at 4:56 pm

  #1324809

  Thanks Jeff,

  I will repost it and remove the links.

  Thanks again.