Or if you want to make this look more to what you may be familiar with, drawing off of your example ,

USE tempDB;

GO

/* ----------------------------- */

CREATE TABLE #stakeholder_notes(

note_id INTEGER NOT...

Great, Sean's example solves this. You can refer to his last post.

sartis (1/5/2016)

---

MMartin1 (1/5/2016)

---

You provided sample data and the tables structure. Can you also provide what you want the final output to look like? We may be able to fill in...

You provided sample data and the tables structure. Can you also provide what you want the final output to look like? We may be able to fill in the gap...

I prefer CTEs when one recordset depends on the prior. This could be potentially quite confusing with multiple subqueries

With Cte0 as

(

SELECT /* some record set */

),

Cte1 as

(

SELECT /* ..*/

FROM...

If you right click a column in a table, and choose properties >

you will see a node for 'Extended Properties.' Here you define what you want to add to...

Aside from the task of somehow accounting for the same client across the two databases potentially, a thought I have is that in theory you can load the ids for...

Solomon Rutzky (12/29/2015)

---

Eric M Russell (12/26/2015)

---

Well, im still not sure about RegEx in a data warehouse. Parsing text columns suggests things like product descriptions were not identified by category in...

Hi, did you make use of the "DelimitedSplit8K" function?

My first impression when I see these restrictions is, if this is a test or homework question for a class.

Jeff Moden (12/25/2015)

---

I believe my favorite non-SARGable problems are due to the inappropriate use of "OR" and things like the following...

WHERE ISNULL(SomeNumericColumn,0) > 0

...

WHERE ISNULL(SomeCharacterColumn,' ')...

Jeff Moden (12/28/2015)

---

Heh... apparently, thousands of people agree with you. Instead, they...

Eric M Russell (12/30/2015)

---

Orlando Colamatteo (12/30/2015)

---

Eric, agree it's not a ton more but Phil expressed it in more detail. This is basically my thoughts on it and where my comment...

As the name implies, staging is just that. The data is not meant to be a permanent fixture, otherwise call it a operation data store. If the goal is auditing...

+1

I avoided...