SQL and Bible Studies:- Books in each Genre

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

Sql Server Reporting Services – Does Date Cover Entire Day?

  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?

Using Unicode in Transact SQL / Management Studio

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

Microsoft – SQL Server – IsGuid

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

Microsoft – SQL Server – Error Message – The conversion of a varchar data type to a datetime data type resulted in an out -of-range value.

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.