:hehe:

She has you for breakfast.

Did you find a useful resolution for this problem?

Pint of strong black coffee and three smokes.

Shaun McGuile (7/30/2008)

---

I don't keep contact details in my head,

but I do have a 1 through 12 instant lookup multiplcation matrix.

.i.e. give me any two integers 1 through 12 and...

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,...

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...

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...

What problem, Chandru? I suspect your answer...

Chandru (7/30/2008)

---

If new fk_id is passed (i.e fk_id which is not present in custom_data table) then i have insert into custom_data table otherwise i have to update the...

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...

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 =...

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...

Hi Chandru,

There's a problem with the INSERT INTO ... SELECT ... block.

SELECT

...

It takes less than a millisecond on...