Eirikur Eiriksson

-------------------------------------------------------------------------------

-- FIRST READ

-------------------------------------------------------------------------------

Table 'TBL_NUMBERS'. Scan count 1, logical reads 123814, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

...

WayneS (9/9/2016)

---

J Livingston SQL (9/9/2016)

---

feeling pleased (for the minute!)

off the shelf tower.....

6th Generation Intel(R) Core(TM) i7-6700 Processor (8M Cache, up to 4.0 GHz)

16GB (2x8GB) 2133MHz DDR4 Non-ECC 1 SR

2TB...

hehe...you are probably right Phil 😀

please dont cross post on multiple forums...highly unlikely to gain you any more respondents.

maybe this post will help....seem to remember similar problems, but cant remember the solutions!

https://social.msdn.microsoft.com/Forums/office/en-US/9540ba5f-bccc-446a-9179-5bb50e191bac/cant-delete-record-from-sql-server-table-from-within-ms-access?forum=accessdev

Gazareth (9/9/2016)

---

drew.allen (9/9/2016)

---

Jacob Wilkins (9/9/2016)

---

The Dixie Flatline (9/9/2016)

---

Okay.... although I'm not going back into the divide by zero thread.

Both SET ANSI_WARNINGS OFF and SET ARITHABORT OFF...

....and he isnt going to listen to anyone either

Lynn Pettis (9/9/2016)

---

ThomasRushton (9/9/2016)

---

Grant Fritchey (9/9/2016)

---

GilaMonster (9/9/2016)

---

Grant Fritchey (9/9/2016)

---

BrainDonor (9/9/2016)

---

I've been following that thread since it started - fascinating. I'll give him full marks for determination ("Tis but a scratch"...

itortu (9/7/2016)

---

Hello, I think you are correct. I just do not know how to include all the tables and data involved in the creation of these "smaller" sets and ask...

rerlston (9/7/2016)

---

moymike (2/4/2016)

---

I'm assuming a better option has come available since this was posted, but here is another.

The pivot year is 1950 though, which would be a problem...

Jason A. Long (9/6/2016)

---

Eric M Russell (9/6/2016)

---

Still there is the issue that two words sounding alike are completely different.

SELECT[dbo].[DoubleMetaPhone]('Pheasant');

FSNT FSNT

SELECT[dbo].[DoubleMetaPhone]('Fussy Aunt');

FSNT...

should work in 2012 and above....care to share a simple version of your code that throws the error...

EDIT sorry spelling is hopeless this evening

-- just for fun

SELECT[dbo].[DoubleMetaPhone]('Pheasant');

SELECT[dbo].[DoubleMetaPhone]('Phesant');

SELECT[dbo].[DoubleMetaPhone]('Fessant');

SELECT[dbo].[DoubleMetaPhone]('Fezant');

SELECT[dbo].[DoubleMetaPhone]('Phes ant');

SELECT[dbo].[DoubleMetaPhone]('Fez aunt');

quite impressive

spin (9/6/2016)

---

i think so? 😐

I really want to be able to pivot the data in excel so i can see ytd by

week

week - product

week - customer

week - customer -...

I didnt make any response to the OP, but having read the responses and the...