RAJ writes "Dear sir I Have requirement such that i want to generate a Unique keys. Simillar to what Newid() Does but i need the key generated to be same Whenever i execute that Function. i wll give an Example.Select FunctionName() , au_lname, au_lname, Phone from Authors------------------------------------------------- UniqueKey au_lname au_lname Phone-------------------------------------------------- 1 White Johnson 408 496-7223 2 Green Marjorie 415 986-7020 3 Carson Cheryl 415 548-7723 4 O'Leary Michael 408 286-2428 5 Straight Dean 415 834-2919 6 Smith Meander 913 843-0462 7 Bennet Abraham 415 658-9932 8 Dull Ann 415 836-7128 9 Gringlesby Burt 707 938-6445 10 Locksley Charlene 415 585-4620 11 Greene Morningstar615 297-2723----------------------------------------------------------
The above Uniquekey (It should be Serialkey) Column was generated by that function. For How many times it was executed it should show the Same result ie. Same UniqueKey. I don't want to use a temp Table because may base table has Millions of records. I tried with the sql server 2000 functions but i can't do that. I think i have to write a Extended sp if so what any quicker method to do that. And i do want to knowWhether it is Possible. Give me some sugesstions."
Sql server Functions 
Posted - 2001-09-12 : 09:02:36