I am in the manufactoring industry. We are more concerned with billing and inventory issues. Hopefully 5 places will be okay.

Thanks for the advice. It was an...

Thanks to both Jeff and Jacob for the help. Based on your posts I will use decimal instead of money. I was wondering, since I am only working with...

Thanks. I appreciate the help.

Unless I am mis reading something (I haven't had my coffee yet), the article http://sqlservercodebook.blogspot.com/2008/03/sql-string-functions-tutorial.html gives the same definition of LTrim and RTrim. I believe that the...

I was under the impression that one of the reasons that you use a decimal data type instead of a float is to avoid rounding issues. Does Money avoid...

Thanks for the information and the link. I had an instructor which told us that the decimal point was part of the precision and another instructor who said it...

Thanks. To be on the safe side do you see any problems using a decimal data type instead of money for US Dollars?

Thanks

Thanks so much. I really didn't want to have to bother with PCL.

I want to thank you for getting back to me so quickly. I was wondering if it was possible to add a button to a webpage that when clicked,...

Actually SSCrazy's response seems to make sense. I had not thought about fixed length strings.

Thanks

I would take a slightly different approach. I would create one stored procedure that returns all of the fields from the table. I would then do one of the following:

a)...

Thanks so much for the time. This will be a big help to me.

I have never seen IsNull used in this fashion. Am I correct that:

1. If @PartialKey is Null then the statement below conceptially does:

Where FirstPartOfKey =...

Sounds like a fun exercise.

Thanks. I didn't think that I would have any problems. I just needed to be sure.