The database that I maintain in my company started as an Access database sometime in the mid to late 90's. It was transitioned over to SQL 2000, SQL 2005, and...

I have used APPLY. I was tasked with finding all the production routing steps for inspection within a given date range. Simple enough, but the kicker was that they also...

Well written. I like number 9 especially. I can't tell you how many times I've said that no matter how much I test a new piece of code it isn't...

Thanks for the quick reply Dugi. My problem is that there is no exe file to extract from the zip file. It's a shame. They sound like some great...

I must be doing something wrong. I downloaded the scriptsmanager.zip file from the link but when I try to extract the scripts there are no files present in the zip...

Thank you Bob and Jeff for your excellent feedback. I have modified my solution based on your input. This is a bit simpler and easier to read. No CAST at...

Thanks for the reply,

The numbers were just used as an example. I'm really using integer fields as part of the equation and your right, I did not have to cast...

Sorry folks, I jumped the gun. If I covert the integers to a float data type the division occurs the way I expect it to

Select Cast(1 as Float)/Cast(100 as Float)