Why?

http://www.sqlservercentral.com/Forums/Topic1558119-3077-1.aspx

http://laughingsquid.com/the-expert-a-hilarious-sketch-about-the-pain-of-being-the-only-engineer-in-a-business-meeting/

TheSQLGuru (4/2/2014)

---

http://msdn.microsoft.com/en-us/library/dd172122(v=vs.100).aspx

I don't see it listed here though, just the outer joins: http://technet.microsoft.com/en-us/library/bb510662.aspx

or here (although there are some rather surprising things supposedly being REMOVED in SQL 2014 and future...

gedhinch (4/2/2014)

---

Thanks for your help Sean,

I'll give you remainder of the tables for the variables,

weightkgs, warrantycode, product line, serialized, list price, prod class all come from the gbpricelist table...

The other part of this is that you are trying to update 5 million rows of data at once. Remember that SQL Server needs to write all the changes...

First, I just noticed something left out of my original code and fixed it here.

Second, I am also providing another solution that may work in both SQL Server and other...

And if the data stored...

IIRC a differential backup after switching back to Full Recovery model works as well.

Ed Wagner (4/1/2014)

---

Lynn Pettis (4/1/2014)

---

Ed Wagner (4/1/2014)

---

SQLRNNR (4/1/2014)

---

Ed Wagner (4/1/2014)

---

Personally, I really hope you're...

Ed Wagner (4/1/2014)

---

SQLRNNR (4/1/2014)

---

Ed Wagner (4/1/2014)

---

Personally, I really hope you're not old at 44....

You're not old!

kevin_nikolai (3/31/2014)

---

Thanks Lynn, I read the article.

Just for the fun of it I will compare all 4 functions for accuracy and speed:

DelimitedSplitN4K, DelimitedSplit8K, SplitList, fn_CSVToTableString.

Judging by the article,...

That is actually how the data is stored in your database? How do you know what year the month exists? What you have posted still doesn't really help.

kevin_nikolai (3/31/2014)

---

Hi Lynn, I will compare your function with the one below and the function 'fn_CSVToTableString', notify you 2moro which I find is the best.

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

CREATE FUNCTION [dbo].[SplitList]

(

@RowData nvarchar(Max)='',

@SplitOn nvarchar(5)=''

)

RETURNS @RtnValue...