I’m a…
...freelance technologist providing programming and consulting services. How may I be of service to you?
You may e-mail me at llc@bengribaudo.com.
Links
Categories
- Photography (2)
- Programming (32)
- Uncategorized (1)
Tags
.Net Auto-Generation Book Review Bug C# Canon EOS Configuration Container Field Coupon Code Duck FileMaker Pro Garbage Collection goto IList Magento Master-Detail Form Object Scope/Context Oklahoma City Operator Payment Processing PDF PHP Rake Ruby SQL SSRS switch Unit Testing User Interface Visual Studio Water Wildlife Windows Forms WPF Zend FrameworkArchives
- January 2012 (3)
- December 2011 (1)
- November 2011 (1)
- October 2011 (1)
- September 2011 (1)
- August 2011 (1)
- July 2011 (1)
- June 2011 (1)
- May 2011 (3)
- April 2011 (3)
- March 2011 (3)
- February 2011 (2)
- January 2011 (2)
- December 2010 (2)
- November 2010 (2)
- October 2010 (2)
- September 2010 (2)
- August 2010 (2)
- July 2010 (2)
Tag Archives: SQL
Storing Incomplete (Partial) Dates in SQL Databases
Complete (full) dates and unknown dates can easily be stored in a database table via a nullable date column. What about storing incomplete (partial) dates—where the month, day and/or year is unknown? How do we record July 10 (unknown year) … Continue reading
SET FMTONLY ON Changes SQL Control-of-Flow Statement Processing
The other day, my friend Jonathan (of Camenisch Creative) surprised me by pointing out that SET FMTONLY ON changes the way Microsoft SQL Server processes control-of-flow statements (IF…ELSE…END, GOTO, RETURN, etc.) When SET FMTONLY is OFF (the default), SQL Server … Continue reading
SSRS: Dataset Field List Is Empty Even After Refresh Fields
Problem: Microsoft SQL Server Reporting Services won’t populate the data set’s field list. Clicking Refresh Fields does nothing—the field list remains empty. Is something wrong with the query? Is there a database permissions issue? Let’s check. Click the Query Designer … Continue reading
SSRS Date/Time Parameter Disabled When Default Value Expression Is Used
After inserting a date/time parameter with an expression as its default value into a Microsoft SQL Server Reporting Services (SSRS) 2008 R2 report, I noticed that the date/time control would be disabled when I’d preview the report. Strange.
SET_ANSI_NULLS Does Not Affect Column-to-Column Comparisons
I learned this fact the hard way the other day! A MERGE statement would not update null values in the destination table with the appropriate non-null data from the source table. My AND clause looked something like “Source.Name != Destination.Name”. … Continue reading