AD MANAGEMENT

Collapse

BEHOSTED

Collapse

Want multiple records instead of one for using when condition

Collapse

Collapse

Edit this module to specify a template to display.

X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    Want multiple records instead of one for using when condition

    ave data in DWH with only one row for one of the ID but when I am using the update statement for the COLUMN_1 like

    UPDATE [T_TABLE] SET COLUMN_1=case when ([Partner] = 'SAP' and ((Technology = 'SAP S/4HANA Cloud' or Technology = 'SAP S/4HANA Hosted' or Technology = 'SAP Cloud Platform' or Technology = 'SAP Business Technology Platform' ) and (Segment = 'Automotive'))) then 'SAP Auto Cloud' when ([Partner] = 'SAP' and ([Technology] = 'SAP S/4HANA ONPREM' or [Technology] = 'SAP S/4HANA Cloud'or [Technology] = 'SAP S/4HANA Hosted'or [Technology] = 'SAP Digital Manufacturing/Supply Chain' or [Technology] = 'SAP Integrated Business Planning (IBP)' or [Technology] = 'SAP Ariba' or [Technology] = 'SAP Concur' or [Technology] = 'SAP Fieldglass' or [Technology] = 'SAP SuccessFactors' or [Technology] = 'SAP Qualtrics')) then 'SAP Intelligent Suite & Industry Cloud' end
    So for Partner as 'SAP' and Technology as 'SAP S/4HANA Hosted' I want two rows for the single ID one will show me COLUMN_1 as 'SAP Intelligent Suite & Industry Cloud' and other row will show as 'SAP Auto Cloud'. Right now it is not happening because when first condition satisfies it keeps the COLUMN_1 as 'SAP Auto Cloud' and then moves to the end. So is there any other alternative of when condition that I can use here?
    Tags: sap online training
Previous template Next

TEXT

Collapse

160

Collapse

Unconfigured Ad Widget

Collapse

GOOGLE

Collapse

Announcement

Collapse
1 of 2 < >

FreeHostForum Rules and Guidelines

Webmaster forum - Web Hosting Forum,Domain Name Forum, Web Design Forum, Travel Forum,World Forum, VPS Forum, Reseller Hosting Forum, Free Hosting Forum

Signature

Board-wide Policies:

Do not post links (ads) in posts or threads in non advertising forums.

Forum Rules
Posts are to be made in the relevant forum. Users are asked to read the forum descriptions before posting.

Members should post in a way that is respectful of other users. Flaming or abusing users in any way will not be tolerated and will lead to a warning or will be banned.

Members are asked to respect the copyright of other users, sites, media, etc.

Spam is not tolerated here in most circumstances. Users posting spam will be banned. The words and links will be censored.

The moderating, support and other teams reserve the right to edit or remove any post at any time. The determination of what is construed as indecent, vulgar, spam, etc. as noted in these points is up to Team Members and not users.

Any text links or images contain popups will be removed or changed.

Signatures
Signatures may contain up to four lines

Text in signatures is subject to the same conditions as posts with respect decency, warez, emoticons, etc.

Font sizes above 3 are not allowed

Links are permitted in signatures. Such links may be made to non-Freehostforum material, commercial ventures, etc. Links are included within the text and image limits above. Links to offensive sites may be subject to removal.

You are allowed ONLY ONE picture(banner) upto 120 pixels in width and 60 pixels in height with a maximum 30kB filesize.

In combination with a banner/picture you can have ONLY ONE LINE text link.


Advertising
Webmaster related advertising is allowed in Webmaster Marketplace section only. Free of charge.

Shopping related (tangible goods) advertising is allowed in Buy Sell Trade section only. Free of charge.

No advertising allowed except paid stickies in other sections.

Please make sure that your post is relevant.


More to come soon....
2 of 2 < >

Advertise at FreeHostForum

We offer competitive rates and a many kinds of advertising opportunities for both small and large scale campaigns.More and more webmasters find advertising at FreeHostForum.com is a useful way to promote their sites and services. That is why we now have many long-term advertisers.

At here, we also want to thank you all for your support.

For more details:
http://www.freehostforum.com/threads...eHostForum-com

More ad spots:
http://www.freehostforum.com/forums/...-FreeHostForum
See more
See less
Working...
X