Viewing 15 posts - 9,001 through 9,015 (of 10,144 total)
MattieNH (1/5/2009)
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...
January 5, 2009 at 10:04 am
Jeff Moden (12/26/2008)
January 5, 2009 at 9:30 am
sqlblue (1/5/2009)
100,000 at a time. How do i do it so that the...
January 5, 2009 at 9:14 am
Jack Corbett (1/5/2009)
I believe WITH RECOMPILE also works.
That makes sense, Jack...https://www.sqlservercentral.com/blogs/ken_kaufman/archive/2007/11.aspx
January 5, 2009 at 8:37 am
RBarryYoung (1/5/2009)
January 5, 2009 at 8:27 am
Philip Horan (1/5/2009)
Thanks, not a million miles away from getting one right! 🙂Phil.
Rewritten without the CTE it's much easier on the eye...
UPDATE p SET
SLC = (AC.AVGDirectLabour + AC.MAN...
January 5, 2009 at 7:22 am
Thanks for the feedback Wayne.
January 5, 2009 at 5:51 am
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...
January 5, 2009 at 5:32 am
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...
January 5, 2009 at 2:42 am
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...
January 4, 2009 at 9:53 am
Jeff Moden (1/3/2009)
January 4, 2009 at 4:50 am
Jeff Moden (1/3/2009)
Just to be absolutely correct... the DATEADD portion of the code should be the following...DATEADD(DD, 1, @specific_day)
Oops...thanks Jeff.
January 4, 2009 at 3:27 am
Select * from Apointment
Where apointment_date >= @specific_day AND apointment_date < DATEADD(DD, @specific_day, 1)
January 3, 2009 at 2:56 pm
RBarryYoung (1/3/2009)
Oops, Chris got in before me ... 🙂
Bet yours is tested though 😀
January 3, 2009 at 11:04 am
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(*), --...
January 3, 2009 at 10:41 am
Viewing 15 posts - 9,001 through 9,015 (of 10,144 total)