Without the DDL to create the schema you are referring to and the DML to insert relevant data, it is very difficult to figure out a solution.

But---it sounds like you...

Good Morning!

The simplest solution to this would be to use PIVOT to flip the data into the format you are looking for. Please try out this SQL and let...

Dave Vroman (5/19/2014)

---

Great article. I do have a very small point in that all phone numbers can't be BIGINT for the reason that there are some international numbers which require...

davoscollective (5/19/2014)

---

Good article, and very important.

I noticed some queries only today being executed by very experienced analysts doing awful non-sargable sins like joining a date column to a datetime...

Works for me---I'll submit one for each over the next few weeks!

I'll take this one. It might be a bit short on its own. If you'd like, I could create a more comprehensive article that discusses all of the...

ranmazure (5/15/2014)

---

Everything is still working good, I've re-arranged my Task order to match yours as well.

One question, on our Insert Statement... The Select Portion...

SELECT

INPUT_TABLE.Key1,

INPUT_TABLE.Key2,

INPUT_TABLE.Key3,

'E' AS Action_Type,

GETDATE() AS Action_Date

FROM Input_Table INPUT_TABLE

WHERE...

Glad to hear everything is working! The order does matter somewhat, but I don't believe it will affect the results. Ie if you insert first, then a future...

That was certainly a use case that we did not take into account before. The trouble was that there were non-unique combinations of Key1 and Key3 (even though Key1+Key2+Key3...

Jeff Moden (5/12/2014)

---

It would also be cool to identify any DMVs that have been deprecated or discontinued, if there are any. If there are none, that would be good...

Good to...

OK---sounds good, I'll do the same for 2012 vs. 2014 and submit when it's all together!

ranmazure (5/8/2014)

---

I'm working with a Daily Input Table and I'm keeping track of Changes in a 'Change Table'.

For example, on Day 1, the Change Table will have no records as...

I just submitted an article about changes in 2012 DMVs...if this is good, I can create one for SQL Server 2014 in a similar format and take this one.

mrcgray19 (5/6/2014)

---

Of course it would be that simple!

Almost perfect.

When the employee does have 2 term records, it of course now returns both records. How would I further filter those...