On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.
When I compare the Month and year in DateColumn1 against DateColumn2, it should tell me that DateColumn1 is less (i.e, earlier) than DateColumn2, even though the Month October in DateColumn1 is a later month compare to Jan, theDatColumn1 is in the past year and DateColumn2 is in the current year.
Case 1: For Eg DateColumn1 = '01-OCT-2013' DateColumn2 = '01-JAN-2014'
Here it should tell me that the difference is 0 as the month and the year match in this case.
Case 2: DateColumn1 = '01-JAN-2014' DateColumn2 = '02-JAN-2014'
Here it should tell me that the DateColumn2 is lesser than DateColumn1.
Case 3: DateColumn1 = '01-Aug-2014' DateColumn2 = '02-JAN-2014'
|SQL Server 2012 r2 - Query results have 2 seperate results instead of 1||2||34|
|SQL Error - Query||6||42|
|union query column need default text||2||15|
|SSRS Deployment problem||5||67|