Eugene Elutin (12/11/2012)

---

Phil Parkin (12/11/2012)

---

WolfgangE (12/11/2012)

---

You misunderstood. I cannot use the house numbers in my query. That was just to show how the result should be. I have not...

WolfgangE (12/11/2012)

---

You misunderstood. I cannot use the house numbers in my query. That was just to show how the result should be. I have not only 1 street in...

?? looks remarkably like a lowercase version of my solution 🙂

cidr (12/11/2012)

---

Hi there,

Apologies for the elusive subject title. I'm trying to filter only rows on one field only when another field has a certain value.

I have a...

select *

,GroupNumber = (

case

when HouseNumber <= 214

then 1

when HouseNumber <= 238

then 2

...

Jeff's code is not wasted, do not worry.

But there is only so much that we can do to help - now you need to help yourself & do some study/learning.

10e5x (12/10/2012)

---

Hi Phil,

I shall try your approach first since u sounds very confident. And I believe u totally know your stuff. But sad to say, I am not up till...

This is a most entertaining thread.

I could help with the SSIS stuff (thanks Jeff!) - if it were needed, but it is not.

First task: write the proc to return the...

So many choices, I just can't decide which row I like best!

guoxiang1610 (12/9/2012)

---

Phil Parkin (12/9/2012)

---

May I ask how you think that SSIS can help you with this problem?

Based on the data provided, it looks like a stored proc would be suffucient...

May I ask how you think that SSIS can help you with this problem?

Based on the data provided, it looks like a stored proc would be suffucient to provide the...

gloing59 (12/8/2012)

---

very good website:

===== http://www.globalmarket.name// =====

The website wholesale for many kinds of fashion shoes, like the nike, jordan, prada, also including the jeans, shirts, bags, hat and the decorations.

WE ACCEPT...

T Childers (12/7/2012)

---

Just in case anyone else has gotten here for the same reason I did which was you're trying to build an SSIS package based on a stored procedure...

DarthBurrito (12/7/2012)

---

Let me add that I'm using this SP for a SSRS report. As the code I provided stands, the SP has one parameter called Products. So the parameter accepts...

Table variables and temp tables are not the same. Temp tables often perform...