sorry about the naming thing...i wrote my comments, then added the code, change the name along the way in there....

glad it's working for you.

did you change it to be a...

you'll need to make your code a function.

once it is a function, say udfRandomString()

you can create a table and set it's default value to the function.

you might run into problems...

I'm admittedly slow at times, but i just changed the time on my server to 12 hours earlier than the real time..., and compared getdate() to OS time; they are...

start>>Run cmd ...

it's the way the IN function works:

the IN() function requires an array() of values, NOT a single variable that happens to have commas in it. that's what you have...a single...

SLQ server automatically handles queueing via a system of LOCKING at the row,then page,then table levels;

a great example is multiple people updating a single table.

there is no need to block...

mithun.gite (4/3/2009)

---

yeah thanks for that function actually, we have this function and we are using it also... and we handling such situation thru dynamic sqll......but this question has come when...

you sure THAT function is working?

it's definition is:

Returns @Tbl_IDs Table (ID Int)

but you are passing varchar GUIDS...so i doubt it returns anything valid.

set @Ids='''fe44fcb1-49c5-4a03-93de-6fadfbb5dbd0'',''FD857BFA-13F9-4051-91B8-6677D2A31C52'''

won't be right, something like this...

in one way or another, a comma delimited parameter needs to use one of the many SPLIT() functions from the Scripts section on SSC, or use dynamic SQL; there's no...

duplicate post.(actually triplicate!)

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread...

duplicate post.(actually triplicate!)

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread...

duplicate post.(actually quaduplicate!)

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread...

duplicate post.(actually quaduplicate!)

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread...

duplicate post.(actually quaduplicate!)

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread...

I've seen an app like that, and upon investigation, found out that giving rights to Public was a knee jerk reaction to fix permissions by someone who did not understand...