Dear Gershom Plz reply if the solution given by ROji has worked. I am just as eagor as any other Anil Never Give Up
Dear Roji And Adriaan Thanks a lot for your responses. The tables used in my query are indexed and i feel like continuing with the derived table...
Dear Gurus Temp tables increases the performance or derived tables increases the performance? Here below i am posting a query which i had created...
Thanks Mirko For your reply Deep Regards Anil Never Give Up
Gurus Of the following two queries which one will execute faster Query 1 SELECT NoOfShr,ShrAmt from CUS_tShrInstLdgrHdr WHEREBrID =...
Dear Thomas Try this Delete from customers1 where datediff(mi,createddate,getdate())<15 Regards Anil Never Give Up
Dear Friends Thanks for your reply I had tried the solutions mentioned by you. But this solution cannot help me in my application as my requirement...
Dear guru's Is it possible to bring in the functionality of Row_Number function in Sql2000?. Some hotfixes available? Deep regards Anil...
Dear Gurus Below is the trace capture of a save action of one of my forms This save action takes 11 seconds at our office and it takes 20 seconds at...
Dear Friends Thanks a lot for your replies. In the mean while I worked upon and framed a query something like the one below. sharing it with you....
Dear gurus Kindly help me in getting the query that returns the Tablename,IndexName and fieldname for the entire database Deep Regards Anil Never...
Friends Introduction of NOLOCK hint in the Select statements in the Function mentioned in the previous post can avoid Locks? Regards Anil...
Friends<br /><br />Below is the exception information from my production server's event log file<br />1) Exception Information<br...
Dear Roji That link was really useful. Now I am able to locate the Sp's that are causing blocks. Thank you Anil Never Give Up
Thanks Roji For your Immediate Response. I will try to work it out Thanks Anil Never Give Up
Friends I have got lots of tips and helps from This forum. Hope you gurus can throw some light into my following issue also Is there a tool or an...
Dear Friend To My Knowledge The Following Query is Equivalent TO The Cursor mentioned. INSERT Into SomeTable (Employer_id ,...
Dear Satya Thanks for the Response Almost all the branches have similar infrastructure Deep Regards Anil Never Give Up
Dear FrankKallis Thanks For Your Response. I will Paste the code for you This SP contains several Sub Sp's out of whic i am placing the important...
Dear Friends I am having a typical problem I am working in project that deals with a bank that has got 40 branches.Intially the bank has given us a...
Separate names with a comma.
