if @order_type = 'SLO'

set @mkt_rate = @lst_ask

...

These are really nice and thorough. I think I'll borrow them too 🙂

Cross Post http://www.sqlservercentral.com/Forums/Topic573930-338-1.aspx

Cross Post http://www.sqlservercentral.com/Forums/Topic574818-338-1.aspx

Thanks so much for your help!!

Does anyone know the answer?

Try this:

SELECT ID

,[NAME]

,STATUS

,STUFF(

(

SELECT ''...

Mean, Variance, and Standard Deviation are built in SQL functions.

--mean

SELECT AVG(Period) AS Mean

FROM @Sample

-- standard deviation

SELECT STDEV(Period) As StandardDeviation

FROM @Sample

-- variance

SELECT VAR(Period) As Variance

FROM @Sample

I'm a bit confused. I went back and reread the original post to refresh my memory. Sure enough, the end of the week is specified as Sunday:

weekly contains...

Here's another way.

SELECT DATEADD(wk, DATEDIFF(wk, 5, a.salesdate), 5) AS EndWeek

,a.line

,sum(a.cost)

FROM #DAILY a

GROUP BY DATEADD(wk,...

Carl Federl (8/25/2008)

---

There is a very long post titled "just the date, please" at http://www.sqlservercentral.com/Forums/Topic379596-8-2.aspx that, for various algorithms, confirms the validity and has performance comparisons.

The best solution consists of

1....

-- works as expected on the following builds:

-- Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation ...

OK, it definitely looks like the build.

I tried my test script on a different database server with the later build and it works as expected.

Does anyone know if this bug...

Both servers are running Windows Server 2003...

DavidB (8/22/2008)

---

Just to reiterate the original posters comments, he is aware of how to get past the issue but he does need to know what it is happening on the...