GilaMonster (3/4/2014)

---

What data duplication?

Not...

Once more with details:

[Expr1031] = Scalar Operator(CONVERT_IMPLICIT(int,[FlexQuotes].[dbo].[BRFCLSeaWeekHis].[Year] as [FCL].[Year],0)),

[Expr1032] = Scalar Operator(CONVERT_IMPLICIT(int,[FlexQuotes].[dbo].[BRFCLSeaWeekHis].[Week] as [FCL].[Week],0)),

[Expr1033] = Scalar Operator(CONVERT_IMPLICIT(nchar(3),[FlexQuotes].[dbo].[BRFCLSeaWeekHis].[CurrencyCode] as [FCL].[CurrencyCode],0)),

[Expr1034] = Scalar Operator(CONVERT_IMPLICIT(decimal(18,5),[FlexQuotes].[dbo].[BRFCLSeaWeekHis].[RateTotal] as [FCL].[RateTotal],0)),

[Expr1035] = Scalar...

SELECT DATEDIFF(dd,0,GETDATE())-1

SELECT DATEADD(dd,DATEDIFF(dd,0,GETDATE())-1,0)

SELECT DATEADD(hh,18,DATEADD(dd,DATEDIFF(dd,0,GETDATE())-1,0))

Use q3. q1 and q2 help explain the algorithm.

SELECT --TOP 100 PERCENT

objectid AS companyid,

-- max(CASE WHEN symbolTypeid = 7 THEN CONVERT(int, symbolValue) ELSE NULL END) AS mergentId,

MAX(CASE WHEN symbolTypeid = 5 THEN symbolValue ELSE NULL...

You've missed the FROM list in CTE3.

igloo21 (3/4/2014)

---

Above bolded parts in the quotes display a contradiction. Did the query run correct when removing both the CASE statements or did it NOT run correct?

If it didn't run...

sCustomer_number is float:

SELECT DISTINCT TOP (100) PERCENT

c.iCustomer_id,

c.sCustomer_number AS CustomerNo,

CASE WHEN c.sCustomer_number = 1 THEN 660 ELSE c.sCustomer_number END AS sCustomer_number,

c.sCustomer_name AS CustomerName,

c.sCustomer_state AS Customerstate,...

SELECT DISTINCT TOP (100) PERCENT

c.iCustomer_id,

c.sCustomer_number AS CustomerNo,

CASE WHEN c.sCustomer_number = 'SL000000' THEN 660 ELSE c.sCustomer_number END AS sCustomer_number,

c.sCustomer_name AS CustomerName,

c.sCustomer_state AS Customerstate,

cc.CustomerType AS Channel,...

rodjkidd (3/4/2014)

---

Tom,

Shrewsbury - somewhere else that's on my "yet to visit" list. I'm getting almost as much out of this discussion as Gail is.

Deciding whether to wait for the discount...

Change the key column order of the index nci_SalesDistrict so that UbiquitousTinyIntColum is the leading edge, followed by keysalesdistrict.

It will probably give you seeks. Better still, data should come off...

Remove the index hint from the query whilst you are still testing and developing. Index hints are used when you've exhausted other, simpler, possibilities.

Add rua.userIsBound to the index as...

It's tragic how little remains of...

paul.knibbs (3/3/2014)

---

Or maybe head across the Severn Bridge...

GilaMonster (3/3/2014)

---

ChrisM@Work (3/3/2014)

---

GilaMonster (3/3/2014)

---

I'm going to picking your brain in the next month or so about vacation spots, I'm planning to take a off week after Bits, Wales looks close....

GilaMonster (3/3/2014)

---

rodjkidd (3/3/2014)

---

Almost posted last night that site was up. But apparently we shouldn't have noticed...