If you use merge replication GUID's are a perfect primary key .

Hi Divya

Monday would be day 1, but a sunday returns 0.

Thanks for putting me in the right direction.

If you want Monday to be day 1 and Sunday to be day 7 use this:

SELECT ((DATEPART(dw, '2010-02-23') + @@DATEFIRST -2) % 7)+1...