Use case statement with other databases

  • 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?

  • 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