Database

ma se wrote:

Shipping (1) -- (M) ShippingInShippingType (M) -- (1) ShippingType

(1) -- (M) is one to many.

I am trying to get the shipping name from the Shipping table, together with the shipping type information.

FROM
  ShippingType
    INNER JOIN ShippingInShippingTypes 
      ON ShippingType.ShippingTypeID_PK = ShippingInShippingTypes.ShippingTypeID_FK
    INNER JOIN Shipping 
      ON ShippingInShippingTypes.ShippingID_FK = Shipping.ShippingID_PK;

FROM Shipping INNER JOIN
 ShippingInShippingType ON Shipping.field = ShippingInShippingType.field INNER JOIN
ShippingType ON ShippingInShippingType.field = ShippingType.field

<br />
use northwind<br />
<br />
DECLARE @MyLike nvarchar(50)<br />
DECLARE @mySQL nvarchar(200)<br />
<br />
<br />
SET @MyLike = '''%AN%'''<br />
<br />
SET @mySQL = 'SELECT * from Employees Where FirstName Like '  + @MyLike <br />
<br />
exec sp_executeSQL @mySQL<br />

<br />
<indentity impresonate="true" userName="username" password="password"><br />

kscadi wrote:

Thanks a bunch. Oh and sorry for cross posting.

kscadi wrote:

DTSWizard.exe

VK-Cadec wrote:

SQL2005 no longer provides the DTS services or like a wizard as in SQL2000