http://forum.lowyat.net/ Sun, 08 Nov 2026 19:15:20 +0800 FeedCreator 1.7.2 http://forum.lowyat.net/topic/491227 hi there..i got some question need u all help. i know is easy but..i duno wat is the solution. i have attached a file. hope u all can give me a hand. thank you. purpleangel85 Codemasters Fri, 20 Jul 2007 14:42:00 +0800 http://forum.lowyat.net/topic/473723 hihi, i wish to find some web design freelance job..or any data entry job or flash cd production?.can u all intro to me?plz....thanx purpleangel85 Jobs &amp; Careers Sat, 16 Jun 2007 16:01:38 +0800 http://forum.lowyat.net/topic/472214 hihi...konnichiwa..i m newbie here.<br />i m developing an online lab management system for my group project. i need some help on the ms sql server store procedure. <br />hmmm...from the information get from my lecturer and person-incharge. every asset in the lab have their expire date.<br />means: if the assets borught today then thier value will reduce 25% every year. until 0% that is need 4 years.<br />i wan to do it to run automatically every year to reduce itself without anyperson login o.<br />let say,<br />2007----100%--<br />2008----75%<br />2009---50%<br />2010---25%<br />2011--0%<br />i have a table field store the asset brought date and one field column is store the percentage value of the asset..so every year, if the difference between the brought date and current year date is 1 year is reduce until 75%,<br />if difference is 2 year then 50%, 3 year is 25% and then if difference is 4 year then will reduce until 0%..then i know the ms sql store procedure will help me write the script. but, i duno how to write the store procedure since i m new in using ms sql.therefore, need some guidance from u all.<br /><br />haha..i duno u all understand wat i am talking or not..hope u all understand lo...<br />thank you. ya :-) arigatou gozaimasu&#33;&#33;&#33; purpleangel85 Codemasters Wed, 13 Jun 2007 18:05:26 +0800