TEXT 22
Untitled Guest on 16th August 2025 11:13:07 AM
  1. USE [125WS]
  2. GO
  3. /****** Object:  StoredProcedure [dbo].[spGetUniqueIdByAgent]    Script Date: 8/16/2025 2:37:40 PM ******/
  4. SET ANSI_NULLS ON
  5. GO
  6. SET QUOTED_IDENTIFIER ON
  7. GO
  8.  
  9.  
  10. ALTER PROCEDURE [dbo].[spGetUniqueIdByAgent]
  11.     @Agent NVARCHAR(100),
  12.     @UniqueId int OUTPUT
  13. AS
  14. BEGIN
  15.     SET NOCOUNT ON;
  16.  
  17.     SELECT TOP 1 @UniqueId = UniqueId
  18.     FROM [dbo].[CallInfo]
  19.     WHERE AgentId = @Agent
  20.  
  21. END

Hightechrobo bin is for source code and general debugging text.

Login or Register to edit, delete and keep track of your pastes and more.

Raw Paste

Login or Register to edit or fork this paste. It's free.