Background The Bible is a collection of books. One can categorize the books in so many different ways. In this post, we will use someone else work. He has categorized bible books into genres. SQL The work avails a couple of database platforms. In this post, we will provide working samples for Transact SQL … Continue reading SQL and Bible Studies:- Books in each Genre
Background One of our users pleasantly gave me a list of things she will like to change in our Reports. The list includes whether we can assume entire day, when she presents us with a day. Report Designer Here is our Report's parameter panel: Quick Explanation: So for Date Start, she wants to … Continue reading Sql Server Reporting Services – Does Date Cover Entire Day?
Background Admittedly, I was trying to be a bit fanciful in showing differences between two columns. For example, I wanted to artfully show differences when a pair of columns are not the same. Code Using ≠ Sign And, so I tried But, got back: As I do not like 5?10, took to … Continue reading Using Unicode in Transact SQL / Management Studio
Background One of my first programming languages is C; mostly on IBM OS/2. Transact SQL Because of that puppy love, I am always tempted to try use some of the old functions such as sprintf in Transact SQL. To me it is just a bit elegant to try working it in whenever I need to … Continue reading sprintf in Transact SQL
Background Talking about unfinished assignment, 2 1/2 years ago I posted about my joy that Microsoft now has "exception safe functions" for converting data between different data types. That post is here: Microsoft – SQL Server – IsGuid Function https://danieladeniji.wordpress.com/2012/06/23/microsoft-sql-server-isguid-function/ But, now that I need that sample code, I can not find it. So let … Continue reading Microsoft – SQL Server – IsGuid
Background Needing to move data among systems using BCP, but it is failing. Error Message Msg 242, Level 16, State 3, Server DEV, Procedure usp_Pull_Wrong, Line 17 The conversion of a varchar data type to a datetime data type resulted in an out -of-range value. To correct To correct, verify data is really a … Continue reading Microsoft – SQL Server – Error Message – The conversion of a varchar data type to a datetime data type resulted in an out -of-range value.