Many years ago I worked for a company as a computer operator (paid OT) where you were paid one hour straight time for every 4 hours you wore a pager...

doasidont (3/31/2016)

---

Thanks for advice. I am nearly finished with creating the scripts that will generate the test data. I have to make sure, however, that the data values...

MattieNH (3/31/2016)

---

It's funny how this is both timely and dated. The U.S. Department of Labor is in the process of issuing final regulations that will expand the number of...

I think this explains the behavior fairly well:

https://msdn.microsoft.com/en-us/library/ms187807.aspx

That would be an interesting one.

From what I know about VB.NET and C# (which isn't a lot), VB.NET does things for you behind the scenes that you have to do explicitly in C#. That...

Still need the DDL for the tables, sample data, and expected results based on the sample data.

Just seems a little cleaner:

with ConvertDate as (

select cast('01-' + string as date) DateValue

from (values('Dec-15'),('Jan-16'),('Feb-16')) test_data(string)

)

select datename(month, DateValue) + ' ' + datename(year, DateValue) MonthYear from ConvertDate;

Glad Hugo and I could be of assistance.

Simplified my code:

with qTally as (

select

n

from

(values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12))dt(n)

), EOM13 as (

select

CalendarDate = dateadd(second, -1, dateadd(month,datediff(month,0,getdate()) - n, 0))

from

qTally

)

select *...

alicesql (3/29/2016)

---

with qTally as (

select

n = row_number() over (order by (select null)) - 1

from

(values (1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1))dt(n)

), EOM13 as (

select

CalendarDate = dateadd(second, -1, dateadd(month,datediff(month,0,getdate())...

drew.allen (3/28/2016)

---

I think that...

Jeff Moden (3/28/2016)

---

Lynn Pettis (3/28/2016)

---

Probably not, but then he hasn't told us how he will be using it...

Probably not, but then he hasn't told us how he will be using it either.

Looks like an application error to me as well. Check the iMIS documentation.