I think you want something like this, but I'm not sure:

CREATE TABLE #Tracking

(

ID INT IDENTITY(1, 1),

COrderID...

I recommend sp_WhoIsActive that Adam Machanic has provided free to the community. You can download it here.

If you don't want to go that route you need to be sure...

Matt Miller (#4) (9/24/2014)

---

Assuming I understand how you were planning to use the view (i.e. land the data as is somewhere temporary, then use a view as the SELECT part...

I'm assuming that you mean when you pass NULL to an insert/update statement?

There are a couple of things I think would work, 1 that impacts your application and 1 that...

Not sure if it is related, and this post will likely fix it, but I haven't been getting email notifications from The Thread, since it was resurrected. I know...

So you need to pivot the data based on the date. I'm also assuming you need a dynamic pivot because you won't know the dates when the code is...

I was wondering why I only had 7 emails from The Thread this morning after not looking all weekend.

I also lost 1093 points. I wonder if that...

I don't think I misread your post, I felt like I answered specifically what you asked. The closes thing to a question in your first post is this:

I think...

jcrawf02 (9/19/2014)

---

NomCom = weed out those who are truly unfit, nothing more. They should be like an HR person screening resumes. Don't give me the one who has been only...

Well, I'd start from the guidelines provided by MS and then tune from there instead of going the other way. For the most part I've found most of MS's...

When you say you tried it, do you mean you granted Browse permission only on the single report?

When you say it didn't work can you tell us what...

EDIT: You can pretty much ignore the stuff below. You can download SSDT for free and it has a schema comparison tool included.

There are ways to do it...

First of all, deleting data does not release the space back to the OS or shrink the database. Shrinking a database is a manual process and is not recommended...

As far as MAXDOP and SharePoint go, SharePoint 2013 resets MAXDOP to 1 if you change it, according to an MVP I know, so if you have applications that are...

Roy Ernest (9/18/2014)

---

Jack, the NomCom should rank them. But PASS should not disclose the ranking when announcing the slate. This is like saying that he/she is worst of the batch...