If you tell us a bit more about the table you are querying we can figure something out.

Its tough to demonstrate when we are guessing at information.

For...

dva2007 (6/28/2011)

---

Ninja's_RGR'us,

We have a table with each patient record where they can have multiple opeation code (up to 15 operation). it has to be in a separate column as most...

You could use row_number to achieve this.

The question is whether you actually need to do this to get the unique count for the report. If you could explain...

Could you explain a bit more in detail what you are trying to do and give us table definitions for the tables you are using?

In your sample data, how do...

FYI, you can format IF logic into a WHERE clause using CASE if you need to.

In the above example, though, you probably shouldn't be using all those dateparts in the...

At a quick glance, couldnt see why you would only be getting one hit.

But some quick observations:

1)Your code is looking for zip codes within a search box, not radius (as...

Can you post the table definitions so that we can give you a working query instead of pseudocode?

This sounds a lot like a homework / test question

Try putting the CTE definition into the string for the dynamic sql. I'm pretty sure you can't link dynamic sql to a CTE the way you tried to.

NOTE: Actually I have a small logical error in the above. If the "gap" in category is for the entire activeperiod I won't find it.

Adding the following...

Wow, this one was nasty.

First of all, a couple clarifications as housekeeping.

There are 29 days in Feb in 2008 (affects your expected output)

Based on your expected output, I think...

Learner1 (10/19/2010)

---

yes, it is dynamically passed ,the list of column is passed through a parameter

it is dynamic sql, Can be any column in the table like Age ,Salary, Name,...

Learner1 (10/19/2010)

---

Hi all

Is there any way that I can pass the column names in where clause and select them.

like

select * from employee

where column_name in (age,salary)

this shows me only Age and...

Dominic Gagné (10/19/2010)

---

thanks for the replies.

I figured out that, by using a derived table, it works fine:

SELECT * FROM

(

SELECT DISTINCT

a.perID,

a.rxDate,

a.rowID,

a.cntNom,

a.cntOrdre,

STUFF(

(SELECT '; ' + CAST(Quantite AS VARCHAR) + ',' + medNom...

Could you describe briefly what you want your case in the order by to accomplish?

There are multiple things wrong here (as noted above, the order by needs to be a...