And I just specified name as "schedule"....

It may be some other name also........So I cant find that name dynamically...

this is the query

SELECT [ScheduleID],ScheduleName FROM [Schedule] ORDER BY schedulename ASC

and this is the result

1Schedule1

3Schedule12

4Schedule14

2Schedule2

5Schedule31

I want output in this format

1Schedule1

2Schedule2

3Schedule12

4Schedule14

5Schedule31

As Ken said, its not compulsory to have a clustered index to primary key... By default primary key will have clustered index. You can drop that clustered index and make...

Sorry. .. I was telling related to integer datatype.. actually i also agree with Lowell

Mithun....

I will tell what i know.....In case of ur query , in where clause u have specified column of integer type...

if u pass any numeric value as varchar then it...

Its good idea... but again we have to use temporary table inside the function.. Anyhow I am also using same function and here is the function which does that work....

CREATE...

Thanks Michael,

That deadlock problem got solved after adding primary key to the table.

Cheers,

Manohar

He is the procedure...

ALTER proc [dbo].[UpdateUserProgressData]

(

@user-id bigint=0,

...

Here condition will checked for existance of tht record... If the record is already inside that table, then it wil be updated else a new record gets inserted...

...

It worked....Thanks a lot.. :hehe:

Thanks Nitin,

But I want to replace all table names inside a procedure with schema prefix to it..

I have 2000 procedures in my database and i cant prefix manully..

So I...

Hi Sundar...

Well its not a good idea to implement drill through report from performance point of view.

Even though i can help u..

I wil send reply to ur mail...

Cheers....

Manohar V