Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ratheeshpatakal
Starting Member
1 Post |
 Posted - 2013-02-04 : 05:20:12
|
| 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.scenarios-----------1.I want to calculate day wise(eg:- offers applicable somedays 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.Regards,Ratheesh. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-04 : 05:41:46
|
| 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 MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Sql Server performance issue