Unfortunately, the condition...

Dear All,

I solved it, and I will tell you how after finishing the whole query and give the report to my MANAGER, since he is waiting for the report

ColdCoffee (5/4/2010)

---

May be, something like this?

WITH CTE(ID_NUMBER ) as

(

select distinct O.ID_NUMBER ID_NUMBER from Table as O

WHERE (O.FIRST_DATE BETWEEN '20090101' AND '20091231')

)

select ID_NUMBER , count(ID_NUMBER) R_Count from CTE

GROUP...

I know this,

But I forgot to tell you that my query return values for more than one condition.

I mean: the query returns records for more than one person, and I...

Where can I see SQL BOL?

could you please tell me the way to use a dynamic query to solve my problem here???

What do you mean by this process (setting DB to simple then back it to Full again) will break the Log chain and I should take a full backup to...

sriram, :D;)

Thank you very much...you solve it.

But how can we make this automatic... I mean can we do this by maintenance plan? because some times we forget to reduce the...

Ok I've created the stored procedure, but I could not create a job that calls the stored procedure every week.

How can I call the stored procedure through the job??

It is a very good solution,

Thank you very much R. Brush

;):)

I think that the best solution is added by krayknot.

Thanks to all...

Also your soultion is not ideal because it needs a substring function for each three digits, so if you want to convert a large number like " 46905730295547" to the...

No it is not a char, it is a numeric(15, 4).

Thank You very much.

I did not know that there is a CASE option in the SQL.

Thanks a lot

well, I have a trigger that reads the latest inserted data and insert them into another table. I've wrote the trigger, then it inserted all data from the first table,...

Thank you very much...Both of you correct.

Thanks again