We are starting a Data Warehouse project, and will be using SQL Server 2005, SSIS, SSRS, and hopefully SSAS.  we are also using WSS v3 (x64) to support our development...

Here is another alternative solution as well:

INSERT INTO PHONE_NUMBER_LIST (

    PHONE_NUMBER,

    PHONE_MODEL,

    LANG_PREF

)

SELECT

    PHONE_NUMBER,

    MIN(PHONE_MODEL),

    MIN(LANG_PREF)

FROM

    TEMP_TABLE AS s

    LEFT OUTER JOIN PHONE_NUMBER_LIST AS t

        on (s.PHONE_NUMBER = t.PHONE_NUMBER)

WHERE

   ...

David,

I agree with you, this is what I came up with:

INSERT INTO PHONE_NUMBER_LIST (

    PHONE_NUMBER,

    PHONE_MODEL,

    LANG_PREF

)

SELECT

    PHONE_NUMBER,

    MIN(PHONE_MODEL),

    MIN(LANG_PREF)

FROM

    TEMP_TABLE AS s

WHERE

    NOT EXISTS (SELECT

                    *

                FROM

                    PHONE_NUMBER_LIST...

You can use Reporting Services, you just can't configure a scale-out deployment.

We've built a development environment using dell PowerEdge 2850's (x64 dual quad-core xeon processors) without any difficulty.  We installed Windows Server 2003 R2 Enterprise x64 Edition for OS and SQL...

Scale-out deployment is only supported by Enterprise Edition, Developer Edition, and Evaluation Edition.

Check this out and see if it gives you what you are looking for:

declare @begindate datetime,

        @enddate   datetime

set @enddate = dateadd(dd, datediff(dd, 0, dateadd(dd, -1 * DAY(getdate()), getdate())), 0)

set @begindate...

You are welcome.  I like math!

Use this:

Sum([tblTraderPnL].[Net P&L] * [tblTradePayout].[Payout])

Try this:

sum([tblTraderPnL].[Net P&L] * [tblTraderPnL].[Net P&L])

Don't know why you would want to multiply the the sum of the field by the field.

Now you just have to convince him to let you design a proper database system, and allow you to normalize the data so it doesn't have to span multiple tables.

Good...

Now you just have to convince him to let you design a proper database system, and allow you to normalize the data so it doesn't have to span multiple tables.

Good...

Try this:

update sometable set

    emailaddress = replace(emailaddress, '@cwexample.', 'cw.')

where

    emailaddress like '%@cwexample.%'

Are you running any scripts in your SSIS Packages?  We found we needed to precompile our packages before deploying them to run on our x64 systems (our development systems are...

I just changed your insert query a little, but give it a try:

 INSERT INTO  [TableA](

    [ColumnA],

    [ColumnB]

&nbsp

 SELECT

    b.[ColumnA],

    b.[ColumnB]

 FROM

    [TableB] b

    LEFT OUTER JOIN...