mishra.vipinkumar001 | SQLServerCentral

mishra.vipinkumar001

Forum Replies Created

Viewing 3 posts - 1 through 4 (of 4 total)

RE: I have written a Stored Procedure having 3 nested while loops in it .This is Working fine and I am getting desired result as I have tested this on small set of data ,but while running on large set of records it taking huge of amount of time, might be due to multiple nested while looping

Hi Guys,
Any Update on this .

September 11, 2013 at 5:50 am

#1649224
RE: I have written a Stored Procedure having 3 nested while loops in it .This is Working fine and I am getting desired result as I have tested this on small set of data ,but while running on large set of records it taking huge of amount of time, might be due to multiple nested while looping

If 3+ visit in last one year then A.
If Atleast 1 visit in past 24 months and 1 visit in the past 12 months then B.
If 1 visit during last...

August 30, 2013 at 11:14 pm

#1646528
RE: I have written a Stored Procedure having 3 nested while loops in it .This is Working fine and I am getting desired result as I have tested this on small set of data ,but while running on large set of records it taking huge of amount of time, might be due to multiple nested while looping

Hi Kapil,
Below are the Business logic and Code.
If 3+ visit in last one year then A.
If Atleast 1 visit in past 24 months and 1 visit in the past 12...

August 30, 2013 at 11:14 pm

#1646527

Viewing 3 posts - 1 through 4 (of 4 total)