Thanks guys.

I tried putting the query in a text file. It works fine, and I think I can live with the overhead.

Thanks, Anders, for the suggestion to execute a...

I'm trying to accomplish a view that offers a unified view of the available data, and that is very dynamic: it should vary in "width" (number of fields) as needs...

EXCELLENT! Thanks!

No, that doesn't work at all :

DECLARE @sql        VARCHAR(5000) --Var for dynamic SQL

DECLARE @Columns    VARCHAR(1000) --Columns to use from Name/Value...

I'm afraid I'm still having problems. Robert Cary's code works just great, but when replacing his table names with my own it doesn't work any more. I somehow get each value...

Sorry, I didn't realize you actually use the PIVOT command in your code.

Thanks. Would it be possible to use the PIVOT command to achieve a "combined" table? I've heard elsewhere that it is an excellent feature in SQL 2005.

Robert Cary asked:

Will you be using this solution to retrive info for only one ID value at a time?

No. Probably not.

If you are using it to return multiple IDs, will...

I'm not sure I understand your problem correctly, but wouldn't checking for null do the trick? I mean like this:

SELECT [sCustomerFullName], [sAccountNumber], [sSIM], [sPlanCode]FROM A a  WHERE EXISTS (

SELECT * FROM B b  WHERE IsNull(a.ssim, '') = IsNull(b.sSim, '') AND...

Thanks John,

That's the only solution I could think of too and it worked like  a charm (except for being quite slow...). When getting back to work after the holidays I...