You can add a default to that column (GetDate()), so you wouldn't have to specify it in the insert/select.

Select dtMain.*, (Amount1 + Amount2) / 1000 as Par from (

SELECT

PriceDate,

PortName,

'Amount1' = (SELECT SUM(BaseSettleAmt) FROM Table1 WHERE TransCatCode In ('005')),

'Amount2' = (SELECT SUM(BaseSettleAmt) FROM Table1 WHERE TransCatCode In ('010'))

FROM Table1

WHERE...

Do you have a calendar table and a holidays table??

The query would look something like this :

Select max(C.date) as date from dbo.Calendar C left outer join dbo.holidays H on...

Same difference. The server doesn't fetch any data in an exists clause, so you don't need to worry about * or 1 (unless you have a group by clause).

Is this a copy/paste from a much older thread Farrell??

Option B :

Insert into db2.dbo.TableName (col list) select col list from db1.dbo.TableName2

Right click on the database in EM / all tasks / import data

then follow the wizard.

I didn't know that you knew that button Sue .

Can you provide more details... I'm not getting the other server part?

I think your design is wrong. You'd be better off having a budget table with all the revenues/expanses. Use the date of the "transaction" as the clustered index,...

If there's a null in the in list, it'll cause the in to fail. The correct syntaxe for this type of query is this :

Select E.col1, E.col2 from...

Is an object refferencing a linked server?

HTH.

Keep it up... you'll find it eventually (still have no clue) .

Just for luck, can you post the execution plan for both servers?

Select userID, firstName, lastName from dbo.ActiveUsers

union all

Select userID, firstName, lastName from dbo.InactiveUsers