Amount is DPL_CODE wise. For same code amount will be same. Dont wan't AVG, SUM or MIN/MAX...Just distinct AMOUNT will do....

Thanks,

Santhosh.

Am in management studio.

Thank you.. will check it once again..

Thanks you..

Precisely...but the fun is that, same page works wihout any problem when executed in another server.

Thanks for guidance..

Thanks....I can see it now...

Thanks a lot.

I tried to save it as package and got the message that it's saved succesfully. But am not able to that package anywhere in sql server. It's neither in Maintenance...

Hello,

The problem is that SSMS itself is not opening....Without query analyzer how will I fire the command..?

Thanks a lot. will try the same...

Thanks a lot dear Marsh...I restored the backup in live server into nwe database nad pointed the site to that..It's workign fine now...

Can you tell me what's SP_WHO2..?

And how to check if another process hold a lock on the table?

Thanks...

santhosh.

Thansl for prompt reply..will revert back to u after checking these..

Thank you so much Marsh...

What's BOL by the way..?

Once again thanks,

Regards,

Santhosh Nair.

Thank you so much.

I just wanted to confirm this. Fine, I will give the rights accordingly.

Infact there was an SQL injection attack on our database recently.

So I need to implement...