Viewing 15 posts - 26,191 through 26,205 (of 26,490 total)
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
...
March 15, 2007 at 2:11 pm
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.
![]()
March 15, 2007 at 1:56 pm
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...
March 15, 2007 at 1:35 pm
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
...
March 15, 2007 at 9:33 am
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...
March 15, 2007 at 9:30 am
You can use Reporting Services, you just can't configure a scale-out deployment.
March 15, 2007 at 9:25 am
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...
March 15, 2007 at 8:25 am
Scale-out deployment is only supported by Enterprise Edition, Developer Edition, and Evaluation Edition.
![]()
March 15, 2007 at 7:51 am
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...
March 13, 2007 at 12:14 pm
You are welcome. I like math!
![]()
March 13, 2007 at 9:30 am
Use this:
Sum([tblTraderPnL].[Net P&L] * [tblTradePayout].[Payout])
![]()
March 13, 2007 at 9:19 am
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.
March 13, 2007 at 8:28 am
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...
March 9, 2007 at 10:08 am
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...
March 9, 2007 at 10:08 am
Try this:
update sometable set
emailaddress = replace(emailaddress, '@cwexample.', 'cw.')
where
emailaddress like '%@cwexample.%'
![]()
March 9, 2007 at 9:58 am
Viewing 15 posts - 26,191 through 26,205 (of 26,490 total)