Chris,

Interesting code. Do you have any performance testing on your method compared to the DelimitedSplit8k function? (Click here for the latest Delimited Split Function.)

This is an interesting article; however there are several things that are just flat-out wrong with it, especially pertaining to table variables....

mtillman-921105 (12/1/2010)

---

Wayne, you always respond with such terrific answers.

I'm glad to know most people usually still use temp tables rather than variables, I was afraid I was just being...

Good timing Jason - I was going to look for this thread tomorrow to get the pdf. Thanks for bringing it to the front!

Duplicate post. Please post all replies here

Ken Sturgeon (11/30/2010)

---

I have a query tuning question. I have a table with some 1.7 mil records and the 2 columns (SalesOrder = col1, SalesOrderType = col2) being searched on...

Table variables can't use statistics, so the optimizer treats them as having just one row. Even if you use the OPTION RECOMPILE hint, it knows nothing about the uniqueness/density of...

If one of those columns is a PK, you could try:

;

WITH CTE AS

(

SELECT PK-COLUMN From dbo.emp_A Where EMP_state = 'PA'

EXCEPT

SELECT PK-COLUMN From Obbeaver.RevProd.dbo.emp_A

)

INSERT INTO dbo.emp_A

(Column1,Column2,Column3,Column4,Column5)

Select Column1,Column2,Column3,Column4,Column5

From dbo.emp_A

...

CirquedeSQLeil (12/1/2010)

---

WayneS (12/1/2010)

---

CirquedeSQLeil (11/30/2010)

---

Jeff Moden (11/30/2010)

---

Thanks, Jason. Heh... When Steve first came out with the "Requested Articles" forum,...

CirquedeSQLeil (11/30/2010)

---

Jeff Moden (11/30/2010)

---

Thanks, Jason. Heh... When Steve first came out with the "Requested Articles" forum, I banged...

Gianluca Sartori (12/1/2010)

---

I don't...

-- Set the UserName and Password columns to how they are specified in the spreadsheet.

-- Set the path/name of the spreadsheet, and the...

Just curious... when creating sql logins, you need to specify a password. Does the Excel spreadsheet also have that specified, or how are you implementing that?

JD Gonzalez (12/1/2010)

---

Thanks for a great post. Always great to read your stuff:)

I'm curious as to why you made this a table-valued function v. a scalar valued function? ...

Gianluca Sartori (12/1/2010)

---

Thank you, Wayne!

It also took me to Paul Ibson's...