Saturday, August 7, 2010

good articles on fixed floating hybrid rate

http://business.rediff.com/slide-show/2010/aug/04/slide-show-1-fixed-or-floating-or-hybrid-home-loan.htm#contentTop

Saturday, July 24, 2010

Dependency Injection discussion

http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&discussionID=19725684&gid=43315&trk=EML_anet_qa_ttle-0Qt79xs2RVr6JBpnsJt7dBpSBA

http://mef.codeplex.com/Thread/View.aspx?ThreadId=35083

ASP.NET & MVC

http://www.linkedin.com/groupItem?view=&srchtype=discussedNews&gid=43315&item=24397298&type=member&trk=EML_anet_qa_ttle-0Qt79xs2RVr6JBpnsJt7dBpSBA


http://www.codeproject.com/KB/aspnet/MVC2Introduction01.aspx

Friday, July 23, 2010

SSRS - running total

--Member wise running total
=FormatCurrency(RunningValue(Fields!Totalamt.Value, Sum, "table1_MemberName"))

--Running total never reset
=FormatCurrency(RunningValue(Fields!Totalamt.Value, Sum, Nothing))

Wednesday, July 14, 2010

SSRS, Cascading Parameters and Expression

-- dropdown filter
http://msdn.microsoft.com/en-us/library/aa337169.aspx

--expression
http://msdn.microsoft.com/en-us/library/ms157328.aspx

Tuesday, July 13, 2010

UNIX, crontab file

-- Basic UNIX script command
http://freeengineer.org/learnUNIXin10minutes.html

--list Crontab file

crontab -l

--edit crontab file

crontab -e

--Get yesterday using UNIX script
today=`date "+%Y%m%d"`
#get yesterday
date "+%Y%m%d"
date +%Y%m%d -d "yesterday"

CurrentDate=`TZ="GMT+24" date +'%y%m%d'`
echo $CurrentDate;

YESTERDAY=$((`date +%d` -1))
MONTH=`date +%m`
YEAR=`date +%Y`
NDAY=`date +%u`
WEEKDAY=${DAYS[`date +%u`]}
if [ $YESTERDAY -eq "0" ]
then
MONTH=$((MONTH-1))
if [ $MONTH -eq "0" ]
then
MONTH=12
YEAR=$((YEAR-1))
fi
set `cal $MONTH $YEAR`
shift $(($# - 1))
YESTERDAY=$1
fi
echo $YEAR$MONTH$YESTERDAY;
varyesterday="$YEAR$MONTH$YESTERDAY"
#end yesterday

echo $varyesterday;

Tuesday, June 22, 2010

String must be exactly one character long.

When you have DBML lINQ entity fields with CHAR data type. you will get an error while retrieve the data.

Solution:
----------
1) go to the DBML entity
2) select field
3) press F4
4) change data type to string from char, where you have DB data type VARCHAR(1)
5) Save