Limit Results Based on Aggregated Threshold
Problem
A post was recently added to one of the forums that I monitor so that I can help users in...
2011-04-11
1,721 reads
Problem
A post was recently added to one of the forums that I monitor so that I can help users in...
2011-04-11
1,721 reads
SQL Saturday #70 (Twitter: #SQLSat70) was another successful event! And...I had yet another full house (some even left due to...
2011-03-19
438 reads
If you are anywhere within driving distance to Columbia, South Carolina, register NOW and then hop in your car Friday...
2011-03-18
442 reads
This site really is about business intelligence, but it is good to mix things up a bit every now and...
2011-03-15
723 reads
In a previous blogs, I discussed what shared schedules were and walked you through step by step instructions on how...
2011-03-08
2,217 reads
In my two previous blogs in this series, I discussed shared schedules and walked you through step by step instructions...
2011-03-03
978 reads
I can’t tell you that all of your dreams will come true. I won’t tell you that you will make...
2011-03-02
540 reads
In my previous post, I discussed what shared schedules were and how you could use them. With that knowledge under...
2011-03-02
1,937 reads
As you will see by the dates in my screenshots, I wrote them quite a while back while touring the...
2011-02-28
2,396 reads
Most of my examples utilize either adhoc type of data samples or one of the versions of AdventureWorks. I do...
2011-02-27
2,974 reads
The first version of my accounting assistant could not find a single purchase of...
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
WhatsApp:0817819444 Jl. Jend. Sudirman No.6, Mulyoharjo, Kec. Pemalang, Kabupaten Pemalang, Jawa Tengah 52313
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers