Handling Flat File Headers and Errors in SSIS
Using SSIS to load a flat file into a database is a common use of the tool. This works great...
2011-09-12
4,069 reads
Using SSIS to load a flat file into a database is a common use of the tool. This works great...
2011-09-12
4,069 reads
We have a report in SSRS 2008 which calls multiple sub-reports. One of the sub-reports contains a data region (tablix) in...
2011-09-10
2,684 reads
Couple of months back, one of our SSRS 2005 staging server became inaccessible. When we opened the report manager, it...
2011-09-10
4,071 reads
I was having a problem getting the display folder to work for a calculation in SSAS. Turns out, it will...
2011-09-09
1,396 reads
I had an issue this week in Report Manager. I was generating a report (we’ll call it General Widgets Report),...
2011-09-09
881 reads
One of our report server which is SSRS 2008 R2 (10.50.1720.0) started to crash intermittently. The IE failed with Internet...
2011-09-09
3,899 reads
Read on to register for cool events, win an iPad2, be inspired, participate in t-sql tuesday, and more!
It's been an...
2011-09-09
1,610 reads
Are you In Portland, Oregon?
Do you plan to be in Portland on Saturday, October 8th?
Can you be in Portland on...
2011-09-09
514 reads
I survived 24 Hours of PASS! Just wrapped up delivering my presentation for the 24 Hours of PASS (24HOP) on...
2011-09-09
663 reads
The schedule for SQL Saturday 97 has been posted and I was selected to give my “It’s TempDB, Why Should...
2011-09-08
475 reads
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. Mangunsarkoro No.24, Pamoyanan, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat 43211
WhatsApp:0817819444 Jl. HOS Cokro Aminoto No.56-58, Muka, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat 43215
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