Declare @MEMO
SET @memo = {{User Picks What Memo they want}}
SELECT c.CustId, c.displayname,
CASE 
WHEN @Memo = 22 THEN cd.NextdueDate
WHEN @Memo = 88 THEN cm.DateValue
END
AS Memo
FROM Cust c
INNER JOIN custdues cd ON c.custid = cd.custid AND cd.memoid = 22
INNER JOIN custmemos cm ON c.custid = cm.custid  

Declare @MEMO
SET @memo = {{User Picks What Memo they want}}
SELECT c.CustId, c.displayname,
r.DateVal AS Memo
FROM Cust c
CROSS APPLY
(SELECT Nextduedate AS DateVal
 FROM custdues
 WHERE custid = c.custid 
 AND @Memo=22

 UNION ALL

 SELECT DateValue
 FROM custmemos
 WHERE custid = c.custid 
 AND @Memo=88
)r

Declare @MEMO
SET @memo = {{User Picks What Memo they want}}

Case 
WHEN Memo = 22 then 
**Do A select statement**
WHEN Memo = 88 Then
**Do A Different Select Statement**

DECLARE @TEST INT

SET @TEST = 1

IF @TEST = 1

SELECT
'1 SELECTED'

ELSE IF @TEST = 0

SELECT 
'SOME OTHER VALUE'

quote:

---

Originally posted by IanKM

Hi visakh16

Many thanks for your responce i must say Cross Apply looks a bit complicated and after reading about it im not sure that i understand it enough to use.

Is it possible to do something like this

Declare @MEMO
SET @memo = {{User Picks What Memo they want}}

Case 
WHEN Memo = 22 then 
**Do A select statement**
WHEN Memo = 88 Then
**Do A Different Select Statement**

Sadly Im not an SQL expert but to be able to do this would seem logical

---