Dear members, we provide a solution of bugs related to sql server along with study material and interview preparation of SQL server. click below link to get your solution http://mssqlinterview.blogspot.com/

Hi I have a table (Sql server 2000) which has 14 cost columns for each record, and now due to a new requirement, I have 2 taxes which needs to be applied on two more fields called Share1 and share 2 e.g Sales tax = 10% Use Tax = 10% Share1 = 60% Share2 = 40% So Sales tax Amt (A) = Cost1 * Share1 * Sales...

Hi, Thanks for the reply. But I'm working on SQL Server 2000 & need a solution for the same problem in SQL Server 2000. My OS is Windows Server 2003 I'm sorry I forgot to mention this beforehand. Would appreciate if any fellow member can guide me to a solution. Ankit Mathur