GilaMonster (5/20/2013)

---

Sean Lange (5/20/2013)

---

Lynn Pettis (5/20/2013)

---

Sean Lange (5/20/2013)

---

I don't think you need dynamic sql for this to work. You just need to get the right syntax. If you had posted...

Lynn Pettis (5/20/2013)

---

Sean Lange (5/20/2013)

---

I don't think you need dynamic sql for this to work. You just need to get the right syntax. If you had posted the error message...

You can either add the unique keyword to the column definition or alter the table...

I don't think you need dynamic sql for this to work. You just need to get the right syntax. If you had posted the error message it would be very...

sql1411 (5/20/2013)

---

Hi Sean,

Thanks for the response

Here are some business rules for the desired output,

•The significance of @Reportdate parameter something that I want to use it in the report as a...

Like this?

SELECT TestName, sample_time AS sample_time_start

, DATEADD(HOUR, 1, sample_time) as sample_time_end

, SUM(VALUE) FROM tblResults

WHERE

GROUP BY TestName, DATEPART(HOUR, SAMPLE_TIME)

Excellent job posting ddl and sample data. I can't figure out the logic behind what you say you want as desired output. What is the significance of the date parameter?...

Yes you would need to use xp_cmdshell.

SQL server is not a JVM so you need to...

xp_cmdshell.

http://msdn.microsoft.com/en-us/library/ms175046.aspx

I have a feeling that performance is going to be absolutely hideous if you do this in a trigger.

You could probably use xp_cmdshell....

Revenant (5/20/2013)

---

Stefan Krzywicki (5/20/2013)

---

Brandie Tarvin (5/20/2013)

---

Stefan Krzywicki (5/20/2013)

---

I think the other thing driving annoyance over Windows 8 is that it seemed to follow Windows 7 very quickly. People were just...

No, my wife had no issues with Vista. She...

Hi Tyekhan and welcome to the forums. The main issue here is that we have no idea what you are trying to do. We can't see your screen, we don't...

jenny 12957 (5/17/2013)

---

hi,

I am trying to figure out the schemas for a new database, and im wondering about the best practice for this type of scenario. I have a database,...

jayoub1 (5/18/2013)

---

Thank you very much for replying

The reason I would not be able to use these tools is that the user needs to be able to enter a start...