Lynn Pettis (3/10/2013)

---

SQLRNNR (3/10/2013)

---

Lynn Pettis (3/10/2013)

---

GilaMonster (3/10/2013)

---

Since it's the msdb job tables, it's a bit of a stretch to say we don't have data. That said, that had a feel...

SQLRNNR (3/10/2013)

---

Lynn Pettis (3/10/2013)

---

GilaMonster (3/10/2013)

---

Since it's the msdb job tables, it's a bit of a stretch to say we don't have data. That said, that had a feel of 'do...

alan_lynch (3/10/2013)

---

Hi Lynn

That sort of works but when I run just this part for the second time I get.

Msg 2627, Level 14, State 1, Line 2

Violation of PRIMARY KEY constraint...

Where does this data come from?

If the code isn't suitable, then it is a logic error. In this case what you think it should be doing, it isn't. We need to figure out...

helal.mobasher 13209 (3/10/2013)

---

Lynn,

you were right, I should have provided descriptons as what I am tryin gto do. Here is the when running the query:

Name1Name2Total

X1 Y1 8

X2...

Brad Marsh (3/7/2013)

---

Ok was able to get this done now:

Here is the table structures

CREATE TABLE [dbo].[HMD](

[WeekNum] [float] NULL,

[MonthName] [nvarchar](255) NULL,

[Response1_Num] [float] NULL,

[Response2_Num] [float] NULL,

[Response3_Num] [float] NULL,

[Response4_Num] [float] NULL,

[Customer Id] [nvarchar](255)...

Is there an echo in here?? How many times I have felt that way here. 🙂

No, you aren't wrong, just that I...

Welsh Corgi (3/10/2013)

---

Lynn Pettis (3/10/2013)

---

Since some of us do not necessarily have a similar environment as you, it may be helpful if you created temporary tables and populated it with...

Plus,...

Not...

Here, I will even help you start. Here is a script to create working copies of the two msdb tables used in your query. All you need to...

Okay, first, I am not apologizing for what or how I said it. I am curious, however, if anyone thinks I went to far here.

Since some of us do not necessarily have a similar environment as you, it may be helpful if you created temporary tables and populated it with data from your msdb...

It is possible that to improve system performance, you could more your nonclustered indexes to other file groups and have this file groups on separate spindles. This could allow...