Are both datasets coming from the same data source? If so, is joining them at the source an option?

Here is what a query using my calendar table would look like:

SELECT TOP 1

t.PlanID,

t.TaskInstructions,

...

There are plenty of ways of circumventing local restrictions of what you can, or can't, do in the database build process, but it would be much better if these arbitrary...

Jeff Moden (1/16/2016)

---

Orlando Colamatteo (1/16/2016)

---

Jeff Moden (1/15/2016)

---

murtzd (12/17/2015)

---

Hi all,

I'm experiencing a very frustrating issue. I am using the guide below to read a cell value in Excel into a SSIS...

Jeff Moden (1/15/2016)

---

murtzd (12/17/2015)

---

Hi all,

I'm experiencing a very frustrating issue. I am using the guide below to read a cell value in Excel into a SSIS variable;

http://www.techbrothersit.com/2013/11/ssis-read-excel-cell-value-in-ssis.html

It works very well...

ScottPletcher (1/16/2016)

---

Orlando Colamatteo (1/16/2016)

---

There could be a trade off for CPU and coding effort. If you wrapped the calculation into an...

There could be a trade off for CPU and coding effort. If you wrapped the calculation into an iTVF (which we...

ScottPletcher (1/16/2016)

---

Simple mathematical calcs could give you any of those dates, with no need for I/O against a table. But I'm also not attempting actual code without existing data...

There is a repro and explanation is in the SSC Forum thread linked to in the Connect item albeit using an expression in the ORDER BY:

http://www.sqlservercentral.com/Forums/Topic607455-145-1.aspx

Here is another repro using...

I'll dig/work one up and post back.

The XML technique is OK, just, OK. And if used I prefer to add TYPE to avoid entitization.

For CLR http://groupconcat.codeplex.com will get you...

Luis Cazares (1/14/2016)

---

SELECT @Notes = @Notes + CONVERT(char(11), DATE, 103) + NOTES + CHAR(10)

FROM tblNOTES

WHERE NOTE_ID = @NOTE_ID

...

True. I haven't heard anything that cannot be persisted yet, but you never know.

I think these "calculations" would become simple lookups on a calendar table using ROW_NUMBER() with PARTITION BY and ORDER BY.

The fact that the author is not citing RFC4180 is troubling. This is exactly where many implementations start out on a bad foot, namely they are making up their own...

Luis Cazares (1/15/2016)

---

Orlando Colamatteo (1/15/2016)

---

@guy1966, I am not sure why you insisted on...