AjasHadi

The decimal data type in sql server 2000 has precision and scale. The precision defines how many length of chars that can exist from left to right including the the numbers after the decimal point. For example col1 decimal(3,2) can contain total of 3 numbers. 9.20 is valid whereas 99.2 is invalid because sql server will add a zero at end to make it 99.20 and that invalidates the rule of precision 3. try this drop table testDec2 create table testDec2(col1 decimal(8,2)) insert into testDec2 values (999996.9999999) --number on left is of len 6 and even thogh we have 7 digits after decimal point, sql -- will truncate the number to insert 999997.00 . Notice the rounding. -- if you try to insert 999999.99 it wont work because of rounding. The number will -- be 1000000.00 i.e. total of 9 chars. select * from testDec2 give it a try. ;-)

Found this great tutorial to mimic the gmail conversation style threading of conversation / emails in one single thread. http://www.petroleumjelliffe.com/2006/02/make-outlook-work-like-gmail/ Right click on From, or Subject and select Field Chooser. Select Conversation and drag it to any place where From, Subject etc appear. Conversation will appear along From, Subject wherever you have placed it. Right Click Conversation and select Group by this field. Thats it. You are done. I got a message saying cant group by Date and conversation. so I sorted my mail by sender and then clicked on conversation. It worked for me. Make sure you arrange mail in such a way that the new email is listed on top. HTH.

I use Dreamweaver 8 on Windows XP and recently started to get this error message for no reason. It just started one day. the following translators were not loaded due to errors coldfusion.htm has configuration information that is invalid. This could also happen for XSLT.htm has configuration information that is invalid, ASP.htm: has configuration information that is invalid. ASP.NET.htm: has configuration information that is invalid. and so on. The solution to this problem is to delete FileCache_X.dat files from the Dreamweaver user configuration folder, where X is a random number and it could be different for your system. See below Dreamweaver 8 on Windows XP: C:\Documents and Settings\[username]\Application Data\Macromedia\Dreamweaver 8\Configuration All the best. I was able to successfully solve this problem