Friday, August 26, 2011

How to find the total amount of a Customers Sales By using Sql Query ?

How to find total amount in Sales Table of One Customer in sql query ?

Select C.CustomerId,C.CustomerName, sum(S.Amount) as Total  From Customers C,Sales S
where C.CustomerId=S.CustomerId
group by C.CustomerId,C.CustomerName

Thursday, August 18, 2011

How to Find Duplicate Records in SqlServer Table

1.How to Find Duplicate Records in Table ?

Select ColumnName From TableName
group by ColumName
having count(ColumName)>1
order by ColumName

Thursday, August 11, 2011

Visual Studio Tools For Microsoft Office

VSTO
VSTO is Have tools for MicroSoft Office to automate the Office in application level and programming level.
Its have more features , it makes office editable and un editable.

Amazon.in


Don't Copy

Protected by Copyscape Online Plagiarism Checker

Pages

Offers