Viewing 3 posts - 1 through 3 (of 3 total)
I use HASHBYTES('SHA1', ... to detect changes in strings.
Can anyone from Microsoft validate your function? If they can I am hoping to save space since HASHBYTES('SHA1' currently uses varbinary(20).
February 19, 2012 at 11:18 pm
#1449076
Any feedback?
March 20, 2011 at 5:46 pm
#1301088
This will make my job obsolete as a BI person but ...
Add an identity column (surrogate key), and a Change_Type (price change, promo etc) to the renamed Prod_Hist (was...
October 1, 2009 at 5:48 pm
#1060750