Forum Moderators: open

Message Too Old, No Replies

Display data that keep coming in for three consecutive days

         

shruti

2:36 pm on Jul 22, 2008 (gmt 0)

10+ Year Member



I have a challenge is :
========================================================
My data base table XYZ is

BSCID, Cellid , Seiz , Drps ,dropflag ,RF, Oth ,Traff, trafflag , Total , DIT , IHFL ,ihfflag , TCD , TCA ,SDD , SDA ,TAVL ,tchaflag , Drate ,date .

========================================================

Now i have to check if the Second column in XYZ "Cellid" has any value that is being repeated for more than three days.

I have the "date" column at last. So Taking todays date into consideration and going back for three days, I need to check if there is any value in the CELLID field that is being on there continuously.

Please can anyone help me?