Retrieve Space Used Details for Table
Every once in a while, you may have a need to determine how much space is being used by a...
2010-07-07
436 reads
Every once in a while, you may have a need to determine how much space is being used by a...
2010-07-07
436 reads
Sometimes you’ll want to manage reporting services functionality through SQL Server Management Studio (SSMS). This would be the case if...
2010-06-29
2,351 reads
I know, it is strange, but it is true...When you create Reporting Services reports that run off of an Analysis...
2010-06-17
1,005 reads
Every once in a while I come across a scenario where I really want to know how long it took...
2010-06-15
568 reads
In a recent article (Reporting Services Parameters Not Updating), I showed how report parameters are not automatically updated upon adding...
2010-06-12
2,920 reads
Using SQL Server Management Studio (SSMS), we have the capability of quickly looking at job related information to verify things...
2010-06-09
1,787 reads
We all know that indexes on tables help performance. However, sometimes too much indexing could affect performance as well. One...
2010-06-07
608 reads
SUNDAY 6/6/2010
While sitting in the conference center for Tech Ed 2010, I thought, why not blog about my trip. Even...
2010-06-07
500 reads
Sorting results in a tabular style report is a common request from business users. Sometimes, they want to see the...
2010-06-07
855 reads
Alternating Group Colors and Alternating Row Colors
After posting my recent blog about Alternating Group Colors, I’ve been asked several times...
2010-06-04
1,368 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