ChrisM@Work

Forum Replies Created

Viewing 15 posts - 9,241 through 9,255 (of 10,143 total)

RE: Moving Average Over a Data Table Requiring Group

Here's a slightly different take on it:
[font="Courier New"]SET DATEFORMAT MDY
DECLARE @Tbl TABLE (
        Symbol INT,
        MarketDate DATETIME,
        Price DECIMAL(10,2),
        Volume INT
        )
INSERT INTO @Tbl
VALUES (1, '1/1/2008', 1.00, 1)
INSERT INTO @Tbl
VALUES (1, '1/2/2008', .98, 10)
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

December 8, 2008 at 7:52 am

#909146
RE: Convert VB Simple Moving Average Function to T-SQL

waykna (12/8/2008)
Yes, they are independent. TrdDay is a date (business day) for which there is trading data (high, low, close, etc...), and period is the size of the simple moving...
^{“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

December 8, 2008 at 5:49 am

#909104
RE: Convert VB Simple Moving Average Function to T-SQL

Hi Wayne
Are TrdDay and period completely independent?
^{“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

December 8, 2008 at 5:00 am

#909085
RE: Change a Views data types

A Little Help Please (12/8/2008)
Chris, THANK YOU so much for your time and patients.
You have helped my understand stand the process much better!!
I have commented out the RAISEERROR line and...
^{“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

December 8, 2008 at 4:53 am

#909080
RE: Change a Views data types

A Little Help Please (12/8/2008)
Yes
I think iv resolved the issue, at the bottom of the SP someone had put in some error constraints:
END
--Otherwise the files should not be updated
ELSE
BEGIN
Execute...
^{“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

December 8, 2008 at 4:22 am

#909073
RE: Change a Views data types

Step 3 - the step which fails - is this the step which transfers data from the bargains table to tblClients?
^{“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

December 8, 2008 at 3:55 am

#909062
RE: Change a Views data types

You're importing from a flat file to the table bargains? Is this the only step performed by SSIS?
^{“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

December 8, 2008 at 3:42 am

#909056
RE: Change a Views data types

A Little Help Please (12/8/2008)
Chris,
I have just recently taken over looking after this DB. It was well before my time so Im not sure why this issue with the ClientID...
^{“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

December 8, 2008 at 3:05 am

#909047
RE: Change a Views data types

A Little Help Please (12/5/2008)
One thing that I dont understand, these same tables/views/SP all are the same as in my mirror istance in SQL2000, once i moved it to SQL2005...
^{“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

December 8, 2008 at 2:36 am

#909040
RE: Change a Views data types

Why do you have different clients with the same clientID?
Why call your column ClientID if itdoesn't uniquely identify clients?
^{“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

December 8, 2008 at 2:29 am

#909036
RE: Improve SQL Query Performance

debjani.bedajana (12/7/2008)
The main idea is the database stores , how many users are getting which variation GRoupA, GroupB, GroupC, GroupD. And each group has four elements. So how many users...
^{“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

December 8, 2008 at 2:22 am

#909032
RE: Sp_Execute with cursors

Hi Mitchy
While there's a chance that this code could be tweaked to work, the first question is "what are you trying to do?"
Can you explain this in words e.g....
^{“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

December 6, 2008 at 5:19 am

#908803
RE: Improve SQL Query Performance

In addition to providing the material Gail has requested and following the advice of Gsquared, can you please post the whole batch of statements? Looking at the two queries you've...
^{“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

December 6, 2008 at 1:59 am

#908772
RE: Replacing multiple occurrences of a string in a text column

You could use PATINDEX in a WHERE clause to identify rows which require editing. SUBSTRING also works with text datatype: passing the return value of PATINDEX to the start value...
^{“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

December 5, 2008 at 8:53 am

#908387
RE: Help needed for a twisted SQL query

We got there in the end! Thanks for the feedback Chris.
^{“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

December 5, 2008 at 8:24 am

#908351

Viewing 15 posts - 9,241 through 9,255 (of 10,143 total)