Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Sql Server performance issue
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

United Arab Emirates
1 Posts

Posted - 02/04/2013 :  05:20:12  Show Profile  Reply with Quote
Hi there,

I have some one requirement in my stored procedure please help me.

I want to calculate rates for all product.there are some scenarios to calculate.

1.I want to calculate day wise(eg:- offers applicable some
days be some days)
2.I have different offers like 1 day free or 10% discount or both etc...
3.i have to check availability of product.
4.I have to check day wise stop sale.

I want to calculate this all product rates with in 3-5 seconds.
currently it is taking 40-60 seconds.

Please help me on this.


Very Important crosS Applying yaK Herder

52326 Posts

Posted - 02/04/2013 :  05:41:46  Show Profile  Reply with Quote
show us what you've done so far and also some sample data from your tables.
Also explain how the offers etc are stored in the system and your additional rules if any for calculations.

SQL Server MVP

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.43 seconds. Powered By: Snitz Forums 2000