ChrisM@Work (6/29/2012)

---

If you'd said "less than 6" then you would have had alternatives options to a function. With a maximum of about 50 items in the list, then I reckon...

Hundreds of ways of skinning this cat.

Here's one:

declare @a table (PID int primary key clustered)

insert @a (PID) select 101 union select 103

--Obviously expand this / modify it as needed to...

What about this?

SELECT *

FROM dbo.Product_Test p

WHERE p.PID IN (101,103)

Do you want dynamic headers/footers, or just some static text?

Jeff Moden (6/28/2012)

---

Heh... "It Depends.":-P

What I'm really waiting for next if for Phil to answer the qauestion as to whether...

Is it perhaps importing a named range on the spreadsheet?

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...