Data is not showing correctly

Vamsi k

Hi All,

We have changed inline quires to storedprocedures. Before changed the results are correctly loaded into Grid. But after converted into storedprocedures ,the records are not coming into a correct order which was previously we are getting.Queries are everything is correct.

**Loading data into is also taking much time

Kindly share your answers.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Salman Beg7y ago
Hi.
Can you please Share your query. There might be Small mistakes. Otherwise you need to connect with DBA for performance Improvement of Query.
Thanks.
Sreekanth Reddy7y ago
Hi vamsi,

Understood your need, but for that untill we have a look over your query we cant trace the mistake(I think better create another forum with specific procedure which is not binding.).

& Regarding the time delay, first check the execution plan of a procedure in your sql server & confirm how much time its consuming... Then try to decrease the cost of performance.
If you are new to execution plan follow the below URL by spending some time :

https://www.red-gate.com/simple-talk/sql/performance/execution-plan-basics/

If it helps mark as accepted answer.
Thank you.
Nikunj Satasiya7y ago
Hi Vamsi,

Can You Show me your SQL Statment and Stored Procedure that you created for display data on the grid?

Data is not showing correctly

Hi Vamsi,