0

please help me in this,how would i do some recursive statement in my stored procedure.
here is what i want

-- @requestcode will genereate some random string
set @requestcode = (SELECT substring(@username,0,3)+'-'+SUBSTRING(CONVERT(varchar(255), NEWID()), 0, 9))

-- then i want to check if the string generated is existing to 'sampletable'
select @requestcode from sampletable

-- if it is existing back to the @requestcode query until it is not existing

thanks in advance

4
Contributors
3
Replies
38
Views
4 Years
Discussion Span
Last Post by BlindArcher
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.