go here and search for the word "toolbox"

http://www.sqlis.com/post/file-watcher-task.aspx

I have been taught that relying on exceptions for Control Flow is a poor design pattern. Exceptions are expensive for systems to generate and if we are incorporating them into...

Jason A. Long (1/19/2016)

---

+1000...

Unfortunately a CLR...

This looks like a place where SQLCLR could come in handy. A function similar to MySQL's GREATEST is what we're looking for.

Can you delete all other data from your Worksheet, zip it and attach it to this thread? I think I need a real-world example to...

ScottPletcher (1/19/2016)

---

Of course that code doesn't specify the date key, so it will do a full table scan. Again, vastly too much overhead when two very simple arithmetic calcs will...

Maybe it's just me but that does not look as intuitive as this to get the 2nd Tuesday in April 2016:

-- get the second Tuesday of the month

SELECT day_dt,

...

MMartin1 (1/19/2016)

---

MMartin1 (1/15/2016)

---

In Excel, insert a column next to the one with the date. Assuming there is a value in B2 displaying like 12/31/2015 ... Enter a formula into C2...

Phil Parkin (1/19/2016)

---

I tried this in Excel 2010 and, whether the date is a 'proper' date or just a date entered as...

what about when you press F2? same?

The timings I presented were for 3 column 1MM rows. I wondered the same and did 10 to see how it did and the placing came out the same:

cross apply:

Table...

Jason A. Long (1/19/2016)

---

Eirikur Eiriksson (1/18/2016)

---

Nice idea but I see two potential problems, firstly the costly concatenation and substringing with the data type conversion is going to impact the performance...

Chances are that while you see a date in the cell when you open the Excel file the data behind it is stored as a decimal. When you open the...

A lot of folks have trouble getting third party tools brought into their environment under any circumstances but especially when a task can be done natively in SSIS.

Eirikur Eiriksson (1/18/2016)

---

Orlando Colamatteo (1/18/2016)

---

@mister.magoo, never seen APPLY used with a row-ctor to unpivot like that. Very cool.

Just for the sake of providing an alternative, we can do the same...