Got it!

Had to run a couple queries

ALTER LOGIN sa

WITH PASSWORD = ' '

-- Since the account was diasbled

ALTER LOGIN sa ENABLE

Thanks all... hopefully I can get...

Thanks Brian,

When I check it is set to 2 though, so apparently it's set to mixed mode. So what gives when I log on as 'sa' and I get...

Actually I'm using a vbscript to write the file.  The SP is massive and does a lot of checking and data validation.  If one thing is missing I don't want...

And the winner is!!

No Converts - 6 secs

Converts - 7 secs

Both contain the same "From" clause with the missing link.

Removed the link on the no Converts - 21 secs.

Removed the link...

Changing the datatypes and getting rid of the inline converts made the response time go from 30 secs to 1 sec.  The dups were coming from a missing link between...

Actually yes I need that behaviour and the dups are not coming from those relationships. For each repcodem.rcode1, 2,3,& 4 there are many repcodes. It's a 1 to many...

what if I separate this out into multiple views?

I kind of need the inline converts seeing as the front end I'm feeding this beast requires those fields to be nvarchar.

Execution plan???

Thanks guys,

I used David's last approach.  Simple and easy and response time is super fast for my record set.

I got this working since I have a SP that is already walking down the entries in table 1.

SET @RefDes = ''

select  @RefDes = @RefDes +  ref_des + ', '...

Yup,

Using a union was the answer, but I had to convert all my values to varchar since the matching fields must be the same data types

Thanks

Thanks guys,

I actually wrote my own function specific to my needs returning just the position and not the table.

I ended up just using a cursor to walk down through the values instead of an inline select into a temp table.

Thanks for the info! Nice thing to know

Actually I'm calling the BCP command from a VBscript that exports to an excel file.  I typically will use the ISQL or OSQL call to do inserts or BULK INSERTS,...

Never mind,

Thank god we backup daily.  I just restored from backup.