Viewing 15 posts - 1 through 15 (of 17 total)
SSMS all day long for SQL work. VS for other coding.
December 4, 2020 at 10:40 pm
The count of years in the most recent of the 3 islands based on my most recent sample data example.
July 9, 2015 at 1:27 pm
This seem to be pulling beyond lapse periods. When I have the following, I am expecting a count of 3 not 7, which is what I am receiving.
INSERT INTO...
July 9, 2015 at 12:48 pm
I will need to hit some more ids against it but this appears to hold up to my small amount of unit checks. I will be able to bump...
July 6, 2015 at 6:12 pm
sg, my apologies for the confusion.
This will operate based on fiscal year 07-01-2014 to 06-30-2015. I am in need of a count of consecutive fiscal years if...
July 6, 2015 at 11:41 am
Ok, started playing with this a little more over the 4th. I have come up with the following and it is getting the count of years based on a...
July 6, 2015 at 7:51 am
Jason, not sure what you are asking. When that piece is added back I am getting a red squiggle line under the ROWS bit. UPDATE*** I removed the...
July 5, 2015 at 11:27 am
When that piece is included, there is a red squiggle line under the ROWS bit. When that is taken out and the query is parsed, it is telling me...
July 1, 2015 at 2:47 pm
Wouldn't you know that since the ROWS was giving me a red line I removed that part but it still did not like it 🙂
July 1, 2015 at 2:12 pm
Yep, that would explain it. I am in 08 R2. Thanks!
July 1, 2015 at 1:42 pm
My editor is not liking the Rows or the order by part. I am trying to run this as query.
July 1, 2015 at 1:29 pm
I am not getting any results where I expect them with your query sg. I am not sure why as I would say it is sound by looking at...
July 1, 2015 at 12:44 pm
The solution presented works to a point. An additional point of criteria, that I was only informed of this morning, is that we only want to count as consecutive...
July 1, 2015 at 9:32 am
My apologies, I was not aware of the business rules previously as it had to be decided upon since we are rebuilding something that previously existed. Same reason I...
June 30, 2015 at 9:42 am
Whoops, that is my fault. 4 should have three upon looking at it again. My apologies.
June 30, 2015 at 6:53 am
Viewing 15 posts - 1 through 15 (of 17 total)