Here is an example. I want to have two fields as primary keys. Do I just add
Primary key as stated ?
SELECT distinct
TOP 100 PERCENT
[Client ID] Primary Key,
[Account Number] Primary Key, [Proj Black 1% Depr Month],
[Proj Black Str Adj],
[Proj Black Sea Adj],
[Black Book Straight Proj Loss],
[Black Book Seasonal Proj Loss],
into ProjGLClient
FROM dbo.CLNTtemp5
ORDER BY [Client ID], [Account Number]