ChrisM@Work

Forum Replies Created

Viewing 15 posts - 9,211 through 9,225 (of 10,143 total)

RE: SQL Help

Ian (12/9/2008)
Sorry I did not see that page you linked, but very helpful. I will get that information out soon.
thank you Chris
You're welcome Ian, and thanks for taking the trouble...
^{“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 9, 2008 at 9:54 am

#909766
RE: Slow function

How long does it take to run once?
How many times is it running in the procedure which brought it to your attention as being a potential bottleneck?
^{“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 9, 2008 at 9:49 am

#909759
RE: SQL Help

Ian, could you please set up some sample data for each of the three tables as indicated in the link below? You will also need to provide a table of...
^{“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 9, 2008 at 9:44 am

#909752
RE: Return Values and store those values for evaluation

Joe, the syntax of your sp and the statement calling it look exactly correct to me. Provided that the output params are DECLAREd before the sp is called, they should...
^{“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 9, 2008 at 9:30 am

#909744
RE: Updating using Execute SQL Task

Have you really got two tables in this update, dbo.PROVIDER_PARTICIPATIONS and Mytable?
^{“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 9, 2008 at 9:24 am

#909739
RE: Update a table while conencting two different server

This should do it, Arun:
UPDATE c SET IsReturned = 1
FROM OPENROWSET('SQLOLEDB', 'DRIVER={SQL Server};SERVER=CSDGWEB;UID=EPP_Developer;PWD=devel0per',
EPP_Prod.EPP_Developer.ClarificationPayments) c
INNER JOIN thangela.MissingClariDb a
ON a.Paymentlot...
^{“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 9, 2008 at 9:00 am

#909722
RE: Slow Query

Change the DELETE FROM to TRUNCATE, you're clearing out all rows and TRUNCATE is non-logged.
The UNION joins together 5 different result sets before inserting them into the target table -...
^{“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 9, 2008 at 8:46 am

#909709
RE: T-sq doubt

Garadin (12/9/2008)
Chris Morris (12/9/2008)
You tell us. There are no mindreaders here.
I knew you were going to say that.
Thanks Seth made me larf that did! Now, about the Lottery tomorrow...
^{“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 9, 2008 at 6:16 am

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

waykna (12/9/2008)
Your description is about right, except that the latest (most current) n rows are used for the calculation. The function moves from the most current to the earliest...
^{“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 9, 2008 at 5:44 am

#909569
RE: T-sq doubt

dastagirid (12/9/2008)
I WANT TO KNOW WHAT IS THE LAST 10 RECORDS IN MY DATABASE TABLES .IS ANY COMMAND IS THERE OR NOT ? ...
Please don't shout, UPPERCASE is shouting.
It's...
^{“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 9, 2008 at 5:28 am

#909564
RE: T-sq doubt

Chirag (12/9/2008)
Chris Morris (12/9/2008)
steveb (12/9/2008)
SELECT top 10 * FROM [YourTable] Order by YourId Desc
It really depends on how your table is orderd, otherwise the results will not really mean...
^{“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 9, 2008 at 5:09 am

#909559
RE: T-sq doubt

steveb (12/9/2008)
SELECT top 10 * FROM [YourTable] Order by YourId Desc
It really depends on how your table is orderd, otherwise the results will not really mean anything
That's the first...
^{“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 9, 2008 at 4:27 am

#909538
RE: T-sq doubt

last 10 records
Based on what criteria?
^{“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 9, 2008 at 4:24 am

#909536
RE: Update a table while conencting two different server

Arun, you seem to be a little unsure of which db (of adhoc_payge and EPP_Prod) is on a remote server. Can you clarify please? Are either of them on 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

December 9, 2008 at 3:24 am

#909522
RE: dynamic column generation

Cross-post, answered here:
http://www.sqlservercentral.com/Forums/Topic615978-338-1.aspx?Update=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

December 9, 2008 at 2:38 am

#909511

Viewing 15 posts - 9,211 through 9,225 (of 10,143 total)