select values from specific column in sql server?

Question

Stored Procedure:-

CREATE PROCEDURE [dbo].[RT_SelectAll_BatchHistory_By_SchedulerTime]
@Skip INT,
@Take INT,
@ResultCode AS INT = 0 OUTPUT,
@ResultText AS VARCHAR(50)=NULL OUTPUT
AS
BEGIN
SET NOCOUNT ON;
BEGIN TRY 
SELECT
       [SchedulerTime]
      ,[ExecutedOn]
      ,[FinishedOn]
FROM   [T_Scheduler] WITH(NOLOCK)
WHERE [IsActive] = 1 
ORDER BY [SchedulerID]
OFFSET @Skip ROWS
FETCH NEXT @Take ROWS ONLY
SET @ResultCode = 0
SET @ResultText='SUCCESS'
END TRY
BEGIN CATCH
SET @ResultCode = -1
SET @ResultText='ERROR'
END CATCH
END

In this Stored procedure want to select All rows from SchedulerTime column and Null values From executedOn and finishedOn.

how can achieve this condition?

RookieCoder · Accepted Answer · 2017-06-14 07:28:37Z

1

SELECT
       [SchedulerTime]
      ,[ExecutedOn]
      ,[FinishedOn]
FROM   [T_Scheduler] WITH(NOLOCK)
WHERE [IsActive] = 1 AND [ExecutedOn] IS NULL AND [FinishedOn] IS NULL

This Worked Fine for me

answered Jun 14, 2017 at 7:28

RookieCoder

1831 silver badge12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pரதீப் · Accepted Answer · 2017-06-14 07:05:51Z

0

Considering you are aware of the dirty reads in your code, you can try something like this..

SELECT
       [SchedulerTime]
      ,[ExecutedOn] = NULL
      ,[FinishedOn] = NULL
FROM   [T_Scheduler] WITH(NOLOCK)
WHERE [IsActive] = 1 
ORDER BY [SchedulerID]

answered Jun 14, 2017 at 7:05

Pரதீப்

94.1k21 gold badges144 silver badges179 bronze badges

Comments

score 0 · Accepted Answer · 2017-06-14 08:04:08Z

0

Use NULLIF in your SELECT Query

 SELECT
       [SchedulerTime]
      ,NULLIF([ExecutedOn],[ExecutedOn]) AS [ExecutedOn]
      ,NULLIF([FinishedOn],[FinishedOn]) AS [FinishedOn]
FROM   [T_Scheduler] WITH(NOLOCK)
WHERE [IsActive] = 1 
ORDER BY [SchedulerID]
-----------------------------------------------    
SELECT
       [SchedulerTime]
      ,NULL AS [ExecutedOn]
      ,NULL AS [FinishedOn]
FROM   [T_Scheduler] WITH(NOLOCK)
WHERE [IsActive] = 1 
ORDER BY [SchedulerID]

edited Jun 14, 2017 at 8:04

answered Jun 14, 2017 at 7:06

user7715598

Collectives™ on Stack Overflow

select values from specific column in sql server?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related