MattieNH (1/5/2009)

---

Steve,

Not that I had tried that, but no. It would be nice to get something like MyServer.MyDomain.OurSystem, but I'd settle for 181.50.144.3. We're trying to build a...

Jeff Moden (12/26/2008)

---

Heh... Actually, I haven't had a cigarette in over a week. Still want one real bad, but trying not to give in. Also trying not to...

sqlblue (1/5/2009)

---

Thanks Noel, but I wanted to be able to do just a set of row, say 10,000 or

100,000 at a time. How do i do it so that the...

That makes sense, Jack...https://www.sqlservercentral.com/blogs/ken_kaufman/archive/2007/11.aspx

Also here[/url], in more detail.

RBarryYoung (1/5/2009)

---

Actually, no. I really do not know much about it, particularly how to fix it. I just have seen this one posted so many times here that...

Rewritten without the CTE it's much easier on the eye...

UPDATE p SET

SLC = (AC.AVGDirectLabour + AC.MAN...

Thanks for the feedback Wayne.

Works like a charm Ken - at least, it produces the expected output from the given sample - but you need to change SELECT ROW_NUMBER() OVER (PARTITION BY A ORDER...

Hi Anita

When do you get the error message - when you attempt to create the linked server, or when you attempt to run a query against it?

Normally I use a...

The table names keep changing - never mind, here's some sample data I made earlier...

DROP TABLE dbo.fct_WKLY

CREATE TABLE dbo.fct_WKLY (TIME_KEY INT, COMM_SYMB VARCHAR(2), TRD_DAY DATETIME, [CLOSE] MONEY, SMA_5 MONEY)

INSERT INTO...

Jeff Moden (1/3/2009)

---

And, seriously... if you want better answers faster and maybe even tested answers, post the data for future requests using the techniques found in the link in my...

Oops...thanks Jeff.

Select * from Apointment

Where apointment_date >= @specific_day AND apointment_date < DATEADD(DD, @specific_day, 1)

Bet yours is tested though 😀

So, of the rows which are returned by the query, you use only the most recent @Period to derive the moving average?

Try the following. It's untested btw...

SELECT SUM(CLS), COUNT(*), --...