ChrisM@Work

Forum Replies Created

Viewing 15 posts - 9,001 through 9,015 (of 10,143 total)

RE: Looking Forward

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 5, 2009 at 9:30 am

#921245
RE: insert in batch question

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 5, 2009 at 9:14 am

#921221
RE: Proc does not execute but query does

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
Also here[/url], in more detail.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 5, 2009 at 8:37 am

#921183
RE: Proc does not execute but query does

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 5, 2009 at 8:27 am

#921173
RE: UPDATE from CTE

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 5, 2009 at 7:22 am

#921111
RE: Select statements included within a function cannot return data to a client

Thanks for the feedback Wayne.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 5, 2009 at 5:51 am

#921054
RE: need a simple query

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 5, 2009 at 5:32 am

#921042
RE: Error While retrieving data in Query Analyzer from Excel File

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 5, 2009 at 2:42 am

#921003
RE: Select statements included within a function cannot return data to a client

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 4, 2009 at 9:53 am

#920867
RE: Select statements included within a function cannot return data to a client

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 4, 2009 at 4:50 am

#920840
RE: Search on a smalldatetime column

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.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 4, 2009 at 3:27 am

#920835
RE: Search on a smalldatetime column

Select * from Apointment
Where apointment_date >= @specific_day AND apointment_date < DATEADD(DD, @specific_day, 1)
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 3, 2009 at 2:56 pm

#920768
RE: Select statements included within a function cannot return data to a client

RBarryYoung (1/3/2009)
Oops, Chris got in before me ... 🙂
Bet yours is tested though 😀
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 3, 2009 at 11:04 am

#920725
RE: Select statements included within a function cannot return data to a client

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(*), --...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 3, 2009 at 10:41 am

#920720
RE: like operator problem

WHERE RIGHT(column, 1) = '%'
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 3, 2009 at 8:33 am

#920690

Viewing 15 posts - 9,001 through 9,015 (of 10,143 total)