Use DISTINCT..!

Yes.Consistency IS quality.

Nice one. Quality and consistency are based on time period of works.That is I had learned from you.

Regards,

Kannan

Actually, I woluld like to display like heirarchical lists in my work.Because i used Recursion method.

Thanks....

Yes...Thank you very much...Recursion has some disadvantages. For Example:

Each time we get one record from the DB, it takes n seconds.

Each DB connection/disconnection takes n * 2 seconds.

Allocating...

Thanks lot for all people....

But i got some idea from internet......

-- Written by: Greg Larsen

DECLARE @OUT BIGINT

DECLARE @CMDX NVARCHAR(4000)

DECLARE @Y INT

-- set @Y to the number for which you want...

Thanks lot.... SQL script is possible?

any ideas. Thanks..

Thanks lot....

First of all, I just wondered about your answer.Thank you very much for your timely help.

Actually, this data are used for Monthly Report display. We are creating Stored Procedure for...

All the tables are having nearly 30+ fileds.But the loop part, we are taking the EXPLANATION ID and CODE. For example:

Sample Data for loop part

CLAIM_ID EXPLIN_ID EXPLA_DESC

100...

What is Materialized views? Is it replace INDEX?

Thanks,

Kannan

Thanks....We were avoided the cursor inour Stored Procedure.We are fetching row-by-row from tables...If you have any ideas about Dynamic index purpose, how can i create and drop the index in...

Thanks. I used 5 tables.I have a problem with my WHILE loop,because the 5 tables have more than 3 lacs records.Each time loop will be excuted,we have got longtime to...

Thanks Andras Belokosztolszki.I got that.

I have Some of questions.

1. What is Dynamic SQL?

2. Is there any diffrences between Dynamic SQL and Stored Procedure?

3. Can i perform this operation using...

Thank you very much.