This worked perfectly! Thanks so much for your help.

Yes you are correct.

Thank you as well!

I apologize for that. I will ensure that I provide more info in the future.

Luis Cazares (4/29/2014)

---

Something like this?

WITH SampleData(ID, Source, Rank) AS(

SELECT 123, 'Foo', 10 UNION ALL

SELECT 123, 'Bar', 20 UNION ALL

...

My apologizes. I misspoke. It is not...

I'm losing my mind actually the calculation was correct I'm sorry for wasting anybody's time. I am kept transposing the amt in my head when writing it down.

Thanks all. It actually was my permissions on the DB..... Rights granted and SP working!

After messing with this all night I think I might be close but not sure

I believe what I have is to take the first character of the string ensure it's...

Thanks so much for the tips! I'm pretty new at SQL Server so I love the tips.

I'm apparently not awake this morning. I found the solution. My less then should have been -89 < -10 instead of <

All these answers worked so I thank you all. As to why I was doing the cross join... I'm new at SQL and that was the approach I thought...

All that is contained in the tables are the last updated dates. I will try and work around that but there are no columns in any of the tables...

Lowell (1/31/2014)

---

I think you simply want SET @Day = cast( getdate() as date)

you have a DATENAME function that would reurn 'FRIDAY", which you tehn try to cast as a date,...

I am trying to pass it a date and have it return day of week. But the first thing I wanted to try was to just create a SP...