November 8, 2013 at 8:53 am
I am looking to incorporate replace statements in a case statement. I have a view which produces the data that need and I have a query that updates fields in one table from another table. I would like to use this query in a CASE statement.
This is how I am updating wtih the query:
update Master_Hierarchy
set OrgID = REPLACE(a.OrgID,b.[OLD CC ID],b.[NEW CC ID]),
AccountID = REPLACE(a.AccountID,b.[closed SBU ID],b.[NEW SBU ID]),
Alias = REPLACE(a.Alias,b.[closed SBU ID],b.[NEW SBU ID])
from Master_Hierarchy a inner join CloseCons b
on a.OrgID = b.[OLD CC ID]
I am thinking something along the lines of:
SELECT CASE
WHEN a.client_sbu = b.[closed SBU ID] Then b.[NEW SBU ID]
else
END as 'client_sbu'
However I want to do this in a view. Is this even possible?
November 8, 2013 at 9:26 am
frank 36119 (11/8/2013)
I am looking to incorporate replace statements in a case statement. I have a view which produces the data that need and I have a query that updates fields in one table from another table. I would like to use this query in a CASE statement.This is how I am updating wtih the query:
update Master_Hierarchy
set OrgID = REPLACE(a.OrgID,b.[OLD CC ID],b.[NEW CC ID]),
AccountID = REPLACE(a.AccountID,b.[closed SBU ID],b.[NEW SBU ID]),
Alias = REPLACE(a.Alias,b.[closed SBU ID],b.[NEW SBU ID])
from Master_Hierarchy a inner join CloseCons b
on a.OrgID = b.[OLD CC ID]
I am thinking something along the lines of:
SELECT CASE
WHEN a.client_sbu = b.[closed SBU ID] Then b.[NEW SBU ID]
else
END as 'client_sbu'
However I want to do this in a view. Is this even possible?
Sure you can use a case expression in a view.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply