Hi Kevin,

That's a really good starting place for me. It doesn't quite put everything on one line when matching on serial (when I run it on actual data), but I...

TheSQLGuru (8/21/2013)

---

Let me try to put together a quickie demo to see if what I am thinking will work in this case. I have come across your situation before...

TheSQLGuru (8/21/2013)

---

One question: is the numeric value that indicates each "type" of value fixed? If so I think I can come up with something to get what you need...

That was so many emails at once I thought someone died.

Er, yeah, sorry about that! SPSS Dimensions makes like 8 tables per project DB. I wouldn't wish this on...

TheSQLGuru (8/21/2013)

---

erikd (8/21/2013)

---

Sean - yeah, I sort of figured. I was hoping there was a general rule for a situation like this. Assuming I'm just looking for direction and not...

Sean - yeah, I sort of figured. I was hoping there was a general rule for a situation like this. Assuming I'm just looking for direction and not a full...

Maybe check the account used under the Log On tab in the SQL Server service properties.

Start > Administrative Tools > Services

Scroll down to the SQL Server instance, right click,...

Right click on your server instance in SSMS and select properties.

If there's a user listed under SERVER PROPERTIES > SECURITY in the proxy account section, that user may need access to the directory as well.

You're right. Here's how it happened:

My original query, which I picked the median-getting part up from here ( http://sqlblog.com/blogs/adam_machanic/archive/2006/12/18/medians-row-numbers-and-performance.aspx ), and thought fit the needs of the SP, didn't. I...

That's interesting, Sean. I don't think about injection much since I'm the only person who uses most of the code I write, and none of it is really ending up...

Also, when I run it like this, it works too. Now I'm very confused. I've run it on a whole mess of tables and received correct results.

USE [Utilities]

GO

SET ANSI_NULLS...

Thank you so much Luis. I wish you guys had tip jars sometimes.

I got your code to work, and then, when the egg cleared from my face, realized I needed...

Due to popular demand, I decided to test each of these queries. I used a .xlsx file with 215,337 rows, and 15 columns.

SELECT * INTO dbo.ImportTest

FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',...

This isn't precisely what you're trying to do, but I found it helpful when trying to do some similar parsing. There's a lot you have to look out for.

http://www.informit.com/articles/article.aspx?p=25049