When you approach this problem you need to dissect what you are trying to accomplish. Since both columns of your "tableb" need to be joined to the "tablea" you...

There are several ways to do this but it really depends on your preferences.

You can use the union method above.

If you plan on executing this query from SSMS everytime; you...

You may want to check out this link.

http://www.sqlservercentral.com/Forums/Topic285021-146-1.aspx

I used the process similar to originsone in the thread, where I created a System DSN using the Driver do Microsoft...

You could also try using the command line with BCP. Here's one for the AdventureWorks DB.

At the command line cd to C:\Program Files\Microsoft SQL Server\90\Tools\Binn

Then type

bcp "SELECT CONT.FirstName,C

ONT.LastName,ADDR.AddressLine1,ADDR.AddressLine2,ADDR.City,SP.StateProvinceCode,

ADDR.PostalCode...

If the with cube doens't turn out with your expected results, I think this will get you there.

DECLARE @INITIALVALUES TABLE

(

VALUE CHAR(1)

)

INSERT INTO @INITIALVALUES

SELECT ''

UNION ALL

SELECT 'A'

UNION ALL

SELECT 'B'

UNION...

If I've pieced this all together it looks like you want update a table using orderid and patientid however this give erroneous results due to the fact that combination (orderid/patientid)...