JunkIt (7/29/2014)

---

I'd like to retrieve the processor name (the same that name that shows up in the system properties control panel applet)

I was able to get this code to work...

rajsin7786 (7/29/2014)

---

Hi Gurus,

Sorry for the late reply, attaching the actual execution plan for your reference. The query was generated from a BI tool that's the reason why its got 3part...

kilter

I see that several others jumped in and found you a working solution. Glad you were able to get it working and thanks to the others for jumping in. 😀

OldCursor (7/28/2014)

---

Forgive me for being grumpy and I do appreciate your offer of help - really. But I thought my original post was clear. The table holds records...

OK I got the columns you want to see but what the actual values for the sample data you posted? I am not understanding what you are trying to do...

Oh wait...I think I am beginning to see what you are trying to do here. You want to see what the value of x and y is for any given...

OldCursor (7/28/2014)

---

Your reply is most unhelpful. I suspect I may stop using SSC in future if this is the sort of reply I get.

To make it clear try this:

Create...

Koen Verbeeck (7/28/2014)

---

patrickmcginnis59 10839 (7/28/2014)

---

I've seen some of the "duplicate question" posts, and I think they could maybe post a link to the question that got duplicated, I haven't seen...

To be fair...every single question that...

OldCursor (7/28/2014)

---

I have a table that records when a value changes. For example item = x, date = 2014-06-15, value = 0; item = y, date = 2014-06-16, value =...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

This thread is our water cooler. It is a place where we...

Lynn Pettis (7/28/2014)

---

patrickmcginnis59 10839 (7/28/2014)

---

Sean Lange (7/28/2014)

---

patrickmcginnis59 10839 (7/28/2014)

I'm looking at the replies in this very post. Diarrhea? Yes, probably "good natured fun" as probably seen by the threadizens, but...

amolacp (7/28/2014)

---

Hi Eirikur & SSC,

I appreciate the response from you guys. I apologize for not being clear before. We have jobs that only get shipped on Thursday of every...