Viewing 15 posts - 9,211 through 9,225 (of 10,143 total)
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...
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
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?
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
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...
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
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...
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
Have you really got two tables in this update, dbo.PROVIDER_PARTICIPATIONS and Mytable?
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
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...
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
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 -...
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
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...
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
waykna (12/9/2008)
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
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...
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
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...
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
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...
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
last 10 records
Based on what criteria?
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
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...
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
Cross-post, answered here:
http://www.sqlservercentral.com/Forums/Topic615978-338-1.aspx?Update=1
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
Viewing 15 posts - 9,211 through 9,225 (of 10,143 total)