like i said, each column can have a different table...if you have 40 columns in the view, you are asking for 80 total? is that right?

what is the exact query...

i know there are issues with getting a 64 bit drivers;

outside of that, I've always used a script to add my oracle linked server.

this syntax might help you, since it...

the easiest thing, thinking about it is to avoid trying to add the "source" as a part of the datarow and rename the columns in your view to identify the...

it's not clear what you want. you've got to show us an example of your expected output, because you can't really mix schema info with datainfo....

what query are you using?

since...

if you run the command

EXEC sp_depends YourViewName

it will give you two sets of tables: the first is the sources of the tables/views and columns that that view refernces to...

why is it every woman i meet on the internet is really a guy?

just kidding, and my apologies.

Goo point;

i know the default length is varchar(30), whenever i convert something numeric to varchar, i've always left it in the simplified form and allowed the default conversion to work,...

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