Also paste the structure of your PartList table in here also.
If I've helped, please RATE my post. Some Informative Links: [Useful T-SQL Factsheet ] [T-SQL DateTime DataType][10 Most Asked SQL Questions and Answers][Connection Strings Refs]
Forum Rules