ChrisM@Work (3/4/2013)

---

prakashr.r7 (3/4/2013)

---

...

Yes...i am restricted, Chris 🙁 . This is how my functionality works. So i have to stick with it. no other option. Have to generate unique random values....

Eugene Elutin (3/4/2013)

---

You can do it using user defined function with a help from small view which makes NEWID() safe for use in UDF's:

CREATE VIEW dbo.UDFSafeNewIDBase AS SELECT NEWID() as...

Cadavre (3/4/2013)

---

Sounds like an extremely odd requirement, so I doubt we're getting the whole picture. I'd suggest that you think about what Chris stated.

Anyway, I guess that something like this...

IF NOT EXISTS(select * from SrcCodeMap where CodeID = @CodeID and LTRIM(RTRIM(PnxCodeValue)) = @result )

...

What ever the process, you can't generate unique random values more than allocated right, Chris ? I am just curious...

ChrisM@Work (3/4/2013)

---

Have you looked at alternative means of populating @result and @VendorCode in the following,

with a view to making the entire process set-based?

INSERT INTO SrcCodeMap (JurisID, CodeID, SrcCodeValueRef, SrcCodeValue, SrcCodeDescr,...

Yes,...