First of all, thanks Dwain for doing the testing & suggesting your own solution.

ChrisM - think you've got some tuning to do 🙂

just as a side dish ... why is...

Adi Cohn-120898 (6/25/2012)

---

Here is one more way:

;with MyCTE as (

select HotelId, RoomTypeId, cast (DateKey as char(8)) as DateKey, FreeCount,

row_number() over (partition by RoomTypeId, case when FreeCount = 0 then 0...

Jan.Sundbye (6/25/2012)

---

Jan.Sundbye (6/8/2012)

---

I have similarly need but in my case I just want to build and maintain one package and use a parameter as a variable in the package. Can...

Excellent, thanks guys. Both ways look good to me - as I expand the problem into the real world, I'll assess which fits best.

Apologies if this is obvious, but you're not looking for a full duplicate. Just a duplicate...

Koen Verbeeck (6/22/2012)

---

My guess is that you have duplicate rows in your source.

The first row inserts fine but at the second row you get the unique key violation error.

When you...

As my Friday good-deed service to lazy people, here's that link again but with URL tags added:

Link here

If you'd rather avoid code, you might like to have a look at the Pause Task[/url] on CodePlex.

Everyone who fought the Nazis, including internal rebels within Germany, took risks. The article doesn't say "Americans beat the Nazis", it says people who took risks did that. And I...

Please detail what is wrong with Cold Coffee's solution.

IceDread (6/19/2012)

---

Phil Parkin (6/19/2012)

---

IceDread (6/19/2012)

---

Intelligence does not make you great. Some studies I read showed that if you had reached what you wanted or were content with what you had...

If you don't know what you want, what chance do we...

I think that some Canadians might have been involved too.:rolleyes:

IceDread (6/19/2012)

---

Intelligence does not make you great. Some studies I read showed that if you had reached what you wanted or were content with what you had you stop to...

Please provide sample data and sample desired results so that we can understand your requirements better.