Why not just create a .NET console app and schedule it with windows scheduler? This doesn't like the type of thing you need sql for at all.

Well I guess the joke is lost now as the topic has apparently been removed. :hehe:

This is because you...

Jeff Moden (8/7/2013)

---

Sean Lange (8/7/2013)

---

You might also click on the Stairways over on the left side. There are a number of series that start out basic and get more advanced...

JoshDBGuy (8/7/2013)

---

Within the loop there are multiple transaction statements. Because these are all very dependent on one another i'd like the loop to stop completely and not insert or delete...

Glad you were able to figure it out.

You can use the IFCode shortcuts (over on the left) when posting to create code boxes. 😉

JoshDBGuy (8/7/2013)

---

Hello All,

I have a question behind the logic of Try and Catch. I'm using Try Catch in a complex statement with a While Loop. If I put the Try...

Oracle765 (8/7/2013)

---

Hi Sean

The reason they change frequentl is that they are imported from a spreadsheet and the user selects the column name from a drop down box which matches the...

GilaMonster (8/7/2013)

---

Sean Lange (8/7/2013)

---

Gail doesn't this actually shortcut to the current user's default schema?...

Gail doesn't this actually shortcut to the current user's default schema? Of course that...

Why not just raise an error when there is an error?

http://technet.microsoft.com/en-us/library/ms178592.aspx

Why not just split the two conditions? No need for a cte here.

SELECT TOP (500) test.[TestId]

FROM tblTest as test

WHERE test.EndDateTime < @Date OR test.StartDateTime < @Date;

The next question is, which...

This is still the strangest requirement I have heard of in years...I can't come up with any rational reason why you would want to blindly modify all the data in...

Stefan Krzywicki (8/7/2013)

---

Sean Lange (8/7/2013)

---

Stefan Krzywicki (8/7/2013)

---

paul.knibbs (8/7/2013)

---

Stefan Krzywicki (8/7/2013)

Yep, owned by Oracle, but there's nothing I can do about that. This is going to be a small database for...

Simply reposting the...