I like Lynn's a lot more; having a view with just a newid in it is more useful, since i could use the same view for other purposes.

my code was...

well the reason for the error is one of the columns in an integer; you have to explicitly convert an integer to varchar when you are creating a string like...

gaps in an identity are normal. they happen when an error occurs and a transaction gets rolled back; although a transaction would not get committed, the incrementing of an identity...

i think the statement you pasted is missing which column in t1 is null; was that a copy/paste error?

it looks a little like pseudo code;

this is how I would do...

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...

there you go!

it's always the unexpected values in the data that trip me up too.

way to go!

you can use this to find the duplicating records, based on your SQL;

SELECT adv.A_AdvertiserID

,'Mobile'

,ab.[Telephone2]

FROM [MSCRM].[dbo].[AccountBase] ab

JOIN [DIGADV].[dbo].[Advertiser] adv

ON ab.[Name] COLLATE DATABASE_DEFAULT = adv.A_AdvertiserName COLLATE DATABASE_DEFAULT

GROUP BY adv.A_AdvertiserID,ab.[Telephone2]

HAVING COUNT(*) > 1

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...