Thank you for your reply. I have 2008 installed and was trying to apply SQL Server 2008 R2 Service Pack. I am thinking what I need to do...

Thank you Lowell! I don't think I forget this one moving forward!

Thank you kindly! This solves the problem.:-)

thank you very much! article solved the problem.

Thank you guys! I left contract out in error this has been very helpful!!!

Thank you for those who replied. I think I did a bad job explaining what I wanted to do. Below I have provided sample code and 2 queries....

Ahhhh! Got it! thank you very much! I was missing the join!

That's it thank you .... perhaps I was overthinking it! 🙂

thank you for pointing that out! all set! 🙂

works great and thank you! Row number is what I was missing!

I got involved as a partner, but the terms of the partnership have not been defined. There was no initial contract or anything I signed. Since I worked many...

thank you this solved the problem!

Hi, I maybe need to open a new string for this one, but if I want to query by a specific date range and only show the records when...

thank you guys, problem solved combining both suggestions!

Thank you for your help!

So basically, what I am trying to do is turn each parking space into inventory by day. Or in 1 year, one parking space will...