The Bellow statements used to access the CASE With IN Condtions for Selecting the city Names
DECLARE @City AS Varchar(30)
SELECT buildingid,(
CASE
WHEN buildingid IN (1,2,3)
THEN 'Chennai'
WHEN buildingid=6
THEN 'Madurai'
WHEN buildingid=7
THEN 'Thiruchy'
ELSE ''
END) AS 'City Name'
FROM tHMSFloor
4 comments:
Hi Siva,
Great post. Can’t get any more straight forward than this article. Thanks!
How is it possible to start cmd.exe in the application modeller?!
cmd.exe in application modeller?
Blue Prism acclaims a phased approach to getting started as the Operational Agility framework is very scalable. It is typical to target the configuration of between 1 and 10 processes initially with a rolling program of processes being introduced once the outline is established.
Excellent tutorials - very easy to understand with all the details. I hope you will continue to provide more such tutorials.
Ciao,
Ivan
Hello Siva,
Thank You so much for this blog. It helped me lot. I am a fresher and first time working on this technology was bit tough for me, this article really helped me a lot to understand the details to get started with.
I've been working with a robot for a while, and this is the second space where Blue Prism sends me the next error, but with different elements:
I've following page shows up tried to reidentify the elements some times, and the problem is the same... So, I don't think that's a solution:
Does someone know how to deal with or solve this "problem”? I don't know if I am doing something wrong, because I'm working with SAP, and identifying stuff with different modes (Accessibility, Win32, Region and SAP).
Unable to match any Active Accessibility elements to the supplied query terms while working in Object Studio?
Excellent tutorials - very easy to understand with all the details. I hope you will continue to provide more such tutorials.
Kind Regards,
Suman
Hey Brother,
Thanks so much for this article! I tried to follow some instructions from few other article and got in over my head. This worked so quickly and your instructions were very easy to follow. Really appreciate this.
Excellent tutorials - very easy to understand with all the details. I hope you will continue to provide more such tutorials.
Thank you,
Ajeeth Kapoor
Hi Sivakumar,
Thanks so much for this article! I tried to follow some instructions from few other article and got in over my head. This worked so quickly and your instructions were very easy to follow. Really appreciate this.
As we know, we can apply tag filter with work
queue items and retrieve only specific items based on tag filter But I have one query.
TAG Filter: "+TAG1; -TAG2; +TAG3; +TAG4"
With above tag filter we can retrieve items with specific tag(tag1) and (tag3) and (tag4) and not retrieve (Tag2) based items but can "UNTAG" items will also return or not?
Second Case: TAG filter:"-TAG1”, It will redrive all items without tag name (TAG1), Can untag items will also return or not??
TAG Filter on work queue?
Excellent tutorials - very easy to understand with all the details. I hope you will continue to provide more such tutorials.
Ciao,
Vanaja
Post a Comment