please give us more details with expected result.

beginners SQL book will really help to understand the concept of Indexes.

Like why only one clustered index per table

When we say clustered index can also have non unique rows,...

U missed an 'END' for case in second line.

U havent specified anything about the ID column.

Thank you very much for the reply.

there is nothing wrong with your SP code.

just check the exec statement.

declare @ret varchar(100)

exec sp1 @ret output

select @ret

This will definitely work.

raiserror makes no difference to the values assigned...

You need to assign the value of the sum to variable @Result

Correct the set @sql statement to the following.

SET @sql = N'SELECT @Result = SUM(' +...

you dont need to add '-1'

the following will also give the same result

SELECT a.fieldname, a.fieldlength, ISNULL(SUM(b.fieldlength), 0)

FROM fields a LEFT OUTER JOIN fields b ON a.fieldid > b.fieldid

GROUP BY a.fieldname,...

Hi ashish

thanks for the reply.

I only found 1 mdf and 1 ldf of the same name. I attached it but i didnt find anything useful in it.

this will work

Select Route from routetable where places like'%Kalaignar Nagar%' AND places like'%Kodambakkam%'

hi Paarthasarathy

when u rename a table, only the name gets changed but the Object ID remains the same. U can check this in sys.Objects table.

the Foreign keys relate to old...

hi

Subhro

Please give us some more details about your problem so that we can try to help.

Frankly speaking the screenshots are not of much use here.

Thank you Gail for the quick replies.

this database exist since a long time, and i have joined this comp 2 weeks back.

SO i am not aware why these settings are...

Hi Gail Shaw

Thanks for the reply.

About your first question : No i haven't checked this on production server, all i was testing was on my machine and couple of my...

Thanks Sharath

I checked the Execution plan.

There is an clustered index seek with a warning saying "columns with now statics" and then 1 column name and same for one more table...