Your column names seem to be confused, but this may be what you want:

-- *********************

-- Test Data

DECLARE @tblCurrentWinTrainingLog TABLE

(

 EmpNo CHAR(6) COLLATE DATABASE_DEFAULT NOT NULL

 ,tdate SMALLDATETIME NOT NULL

 ,trainingname VARCHAR(30) COLLATE DATABASE_DEFAULT...

Probably best done on the front end, but the following should work:

SELECT userid

 ,[name]

 ,address

 ,CASE

 WHEN columnA IS NULL AND columnB is NULL

 THEN 'None'

 WHEN columnA IS NULL

 THEN columnB

 WHEN columnB IS NULL

 THEN columnA

 ELSE columnA...

That sounds like caching. Run them both a couple of times and then compare performance.

How long did the select statement take and how long did the SP take?

OK. Does running the following SP run like

EXEC dbo.Test @pShipmentStatus = 'Live'

still take 22 secs?

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

CREATE PROCEDURE dbo.Test

 @pOrderStatus VARCHAR(10) = ''

 ,@pShipmentStatus VARCHAR(10) = ''

AS

SET NOCOUNT...

In QA, if

select * from v_ORder where ShipmentStatus = 'Live'

takes 2 secs to run, how long does:

DECLARE @test-2 varchar(10)

SET @test-2 = 'Live'

SELECT *

FROM v_ORder

WHERE ShipmentStatus = @test-2

take to run?

SELECT DATENAME(dw, GETDATE())

You will get a quicker response in the T-Sql forum.

This should work but probably can be optimized.

I do not have time to look at it further.

-- Test Data

DECLARE @Rate TABLE

(

 DialCode...

Sreejith is pointing out that DATETIME is just a number and how you see it formatted depends on a number of settings.

To explicitly format the DATETIME in US format, you...

You keep posting this code, which does not make much sense. Try starting with something like:

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

CREATE PROCEDURE dbo.TestProc

 @quiz NVARCHAR(25)

AS

SET NOCOUNT ON

CREATE TABLE #tmpTrained

 (EmplID CHAR(30)...

Following David’s suggestion, which will require your TEXT column to always be <= 8000 characters and to be converted to VARCHAR, try this:

-- Test Data

DECLARE @t TABLE

(

 TID INT not null

 ,TText...

Sergiy was asking for the datatypes, and lengths, of the ShipmentStatus and OrderStatus columns in the table/tables that lie beneath the view.

I missed one of your dates in my previous post. Now corrected:

-- Test Data

DECLARE @t TABLE

(

 TID INT not null

 ,TText TEXT null

)

INSERT @t

SELECT 1, 'Rental No. 00088 Items: GIZMO (CW105715) Rental...

If the date you are looking for always terminates with 'PATIENT NAME:', why bother with a function? eg:

-- Test Data

DECLARE @t TABLE

(

 TID INT not null

 ,TText TEXT null

)

INSERT @t

SELECT 1, 'Rental...

With the =* and *= notation, I find it best to think of the * being against the table where every row is displayed.

eg. Assuming AID does not allow nulls:

SELECT col1...