You could try something like this as well:

update table1 set

    col5 = s.colsum

from

    table1 t

    inner join (

        select

            s.col1,

            s.col2,

            s.col3,

            sum(s.col4) as colsum

        from

            table1 s

        group by

           ...

Wouldn't have figured that one out from BOL, it doesn't show the round function accepting 3 parameters.  Curious where you found this info.

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.%'