if statement???

Question

Post reply

if statement???

jbalbo

SSCertifiable

Points: 7583
More actions
March 8, 2012 at 4:11 pm

#257200

Hi,
I have the following in SP
INSERT INTO @TEMPTABLE(TAG_NAME,TAG_DATA)
SELECT TAG_NAME = 'CUST_CLIENTNAME', TAG_DATA = (SELECT C.FNAME + CASE WHEN C.MNAME IS NULL THEN '' ELSE ' ' + C.MNAME END + ' ' + C.LNAME
FROM CLIENT C (NOLOCK)
WHERE C.OID = @CLIENT_OID);
I want to add an if statement where the tagdata would be
TAG_DATA = (SELECT A.FNAME + CASE WHEN A.MNAME IS NULL THEN '' ELSE ' ' + A.MNAME END + ' ' + A.LNAME FROM ALIAS A (NOLOCK)
INNER JOIN CLIENT_TO_ALIAS_COLLECTION AC (NOLOCK) ON AC.OID_LINK = A.OID
INNER JOIN ALIAS_TYPE AT (NOLOCK) ON AT.OID = A.ALIAS_TYPE_MONIKER
WHERE AT.ABBRNAME = 'Secure Client'
And AC.OID=@CLIENT_OID
AND A.EXPDATE IS NULL);
IF AT.ABBRNAME = 'Secure Client'

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Lynn Pettis

SSC Guru

Points: 442467

March 8, 2012 at 4:21 pm

#1456872

Confused I am what you are asking.

jbalbo SSCertifiable Points: 7583 More actions · Answer 2

sorry....

So I have the following to add client name

with tage_name = 'CUST_CLIENTNAME'

INSERT INTO @TEMPTABLE(TAG_NAME,TAG_DATA)

SELECT TAG_NAME = 'CUST_CLIENTNAME', TAG_DATA = (SELECT C.FNAME + CASE WHEN C.MNAME IS NULL THEN '' ELSE ' ' + C.MNAME END + ' ' + C.LNAME

FROM CLIENT C (NOLOCK)

WHERE C.OID = @CLIENT_OID);

if AT.ABBRNAME = 'Secure Client'

then I Want TAG-DATA for TAG_NAME 'CUST_CLIENTNAME" to do the following

TAG_DATA = (SELECT A.FNAME + CASE WHEN A.MNAME IS NULL THEN '' ELSE ' ' + A.MNAME END + ' ' + A.LNAME FROM ALIAS A (NOLOCK)

INNER JOIN CLIENT_TO_ALIAS_COLLECTION AC (NOLOCK) ON AC.OID_LINK = A.OID

INNER JOIN ALIAS_TYPE AT (NOLOCK) ON AT.OID = A.ALIAS_TYPE_MONIKER

WHERE AT.ABBRNAME = 'Secure Client'

And AC.OID=@CLIENT_OID

AND A.EXPDATE IS NULL);

PLease let me know if this is better?

Thanks

Joe

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Still confused. I don't see any tables in the first query using the AT alias. I only see that in the subquery you are using the code snippit you show after the INSERT statement.

jbalbo SSCertifiable Points: 7583 More actions · Answer 4

Sorry Im fairly new and as u can tell didnt write what I showed..

Im trying to incorporate the second snippet into the first..

so if the person has an alias of "secure client" then do the alias code(Second part) if then don't

then just get the client name(First part)

Thanks

Joe

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

Read the first article I reference below in my signature block. Follow the instructions on what you need to post. Also, post the expected results based on your sample data. The more information you provide the better help you will get.