Now here's a bit of a sticky wicket. I installed the new 2013 Access Run Time engine and my OPENROWSET query still wasn't working.

Got to poking around and found...

An old thread to be sure, but I'm trying to get this to work now with Office 2013.

I found there's a new Access Database Engine for Office 2013.

http://www.microsoft.com/en-us/download/details.aspx?id=39358

If I have...

Stefan Krzywicki (5/6/2014)

---

GilaMonster (5/6/2014)

---

No, it was not me that pointed it out, because for a page split to occur, there must be an insert/update operation occurring. SQL doesn't randomly, when...

Greg Edwards-268690 (4/21/2014)

---

TomThomson (4/20/2014)

---

Fillet "a fish" is not a good test....

Greg Edwards-268690 (4/21/2014)

---

Dwain -

More like a barn find than the one in your picture.

But very little rust, and only 24k original miles.

You can see it's been awhile since dad last...

Greg Edwards-268690 (4/20/2014)

---

dwain.c (4/20/2014)

---

Greg Edwards-268690 (4/20/2014)

---

Dwain -

Hope my car is faster, as I can't even stretch a fish lie to make one that big. 😀

Not the '66, but still...

Duplicate post removed.

Greg Edwards-268690 (4/20/2014)

---

Dwain -

Hope my car is faster, as I can't even stretch a fish lie to make one that big. 😀

Not the '66, but still have a Goat...

Greg Edwards-268690 (4/19/2014)

---

Lynn Pettis (4/19/2014)

---

SQLRNNR (4/19/2014)

---

Lynn Pettis (4/19/2014)

---

Greg Edwards-268690 (4/19/2014)

---

Lynn Pettis (4/19/2014)

---

It is amazing what crap advice people (Gail NOT included) give to others when they ask for help regarding...

Raja M (4/16/2014)

---

Interesting article, but I question the test harness.

I think you should create a more realistic table that has a sizable number of columns. There should...

Steve Jones - SSC Editor (4/9/2014)

---

Adding and bumping topics in here: http://www.sqlservercentral.com/Forums/Forum2824-1.aspx

Please don't commit to more than one and please don't add in random comments. I'd like to try and...

Jeff Moden (4/9/2014)

---

dallas13 (4/9/2014)

---

Thanks Thats much easier.

The example I created has email addresses length=8 but in reality it may be any length and I wanted to just replace...

Since there's very few rate codes present, I thought of a way you can have your cake (return delimited strings) and eat it too (get relatively good performance).

1. The all...

Y'all probably gonna think I'm a might touched in the head for coming up with something like this but it does do the work in one pass of the table...

davidku (4/2/2014)

---

Geez... found the solution myself.

By default, POWER function will follow the data type from the first argument.

http://technet.microsoft.com/en-us/library/ms174276.aspx

By defining 2.718 as a FLOAT and use a variable to call the...