Viewing 15 posts - 9,736 through 9,750 (of 10,143 total)
James A. Lawrence (7/30/2008)
What is a chav?
She has you for breakfast.
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
July 30, 2008 at 1:15 pm
Did you find a useful resolution for this problem?
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
July 30, 2008 at 10:13 am
Pint of strong black coffee and three smokes.
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
July 30, 2008 at 9:42 am
Shaun McGuile (7/30/2008)
but I do have a 1 through 12 instant lookup multiplcation matrix.
.i.e. give me any two integers 1 through 12 and...
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
July 30, 2008 at 9:41 am
DROP TABLE #OrderRenewals
CREATE TABLE #OrderRenewals (OrderRenewalID INT, OrderRenewalRef INT, OrderID INT, RenewalStatusCode CHAR(3), RenewalDate DATETIME)
INSERT INTO #OrderRenewals (OrderRenewalID, OrderRenewalRef, OrderID, RenewalStatusCode, RenewalDate)
SELECT 1, 10, 444, 'ACT', '01-06-2006' UNION ALL
SELECT 2,...
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
July 30, 2008 at 8:46 am
ScoreA and ScoreB don't exist for the WHERE to use yet.
INSERT INTO Tablex (a,b,c,d,ScoreA,ScoreB)
SELECT a,b,c,d,ScoreA,ScoreB
FROM (
SELECT DISTINCT a,b,c,d,
ScoreA = (CASE WHEN...
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
July 30, 2008 at 8:18 am
Yep, spot on Mr Baseball.
/* table definitions for testing =====================
-- Payment batch table ==========================
CREATE TABLE [dbo].[ptPaymentBatches] (
[PaymentBatchID] [int] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY]
CREATE UNIQUE CLUSTERED...
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
July 30, 2008 at 7:36 am
Chandru (7/30/2008)
Yes Chris i too tried in that way but it will create problemLet me try in a different scenario
Thanks
Chandru.
What problem, Chandru? I suspect your answer...
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
July 30, 2008 at 6:51 am
Chandru (7/30/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
July 30, 2008 at 6:08 am
Hi Chandru
Couple of questions:
1. How many rows are returned by the source FROM OpenXML(@xml_hnd, '/NewDataSet/Table1', 2)?
Always one, or possibly more than one? "Always one" would make things easy.
2. Are you...
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
July 30, 2008 at 5:37 am
Antonio's method is probably cleanest but if you want to pursue the method which you started with, then this will help.
DECLARE @LongStr VARCHAR(200), @ShortStr VARCHAR(200)
SET @LongStr = 'http://website.net/trimmed-Jacket.aspx?yyy=137668&DeptId=16465&TypeId=1&Type=0&viewall=1'
SET @ShortStr =...
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
July 30, 2008 at 5:19 am
That sounds about right, Chris.
I've also increased i and j to 1000 to generate a 1 mill row table and that took 46 seconds - but first I changed...
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
July 30, 2008 at 4:45 am
Hi Chandru,
There's a problem with the INSERT INTO ... SELECT ... block.
SELECT
...
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
July 30, 2008 at 4:25 am
karthikeyan (7/30/2008)
Coming back to my research, I have executed the below script..
.
.
The above code took 2 hour 10 minutes for inserting 1,000,000 records.
It takes less than a millisecond on...
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
July 30, 2008 at 3:59 am
Hello
If you're prepared to experiment a little, then a numbers or tally table can make this kind of operation really sing. Here's something which might start you off.
DECLARE @cSearchExpression nvarchar(4000),...
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
July 30, 2008 at 3:45 am
Viewing 15 posts - 9,736 through 9,750 (of 10,143 total)