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

First thing I would like to know is what is the error you are receiving?  The syntax of your statement appears correct, except I would probably use a variable to...