India Post's gold offer for Akshaya Tritiya

For those who are eager to bring wealth and prosperity to one’s doorstep, going by the new-found aura of Akshaya Tritiya, India Post is all set to create avenues for investment in gold coins. And to make the option really attractive for customers, a six per cent discount is being offered on purchases.

On Akshaya Tritiya, which falls on April 24, buying gold is an important part of the worship of Lakshmi, the Goddess of Wealth. India Post is offering the special discount on gold coins of any denomination purchased through post offices during the period from April 1, 2012, to June 30, 2012.At present, gold coins are available at more than 800 post offices across the country.The  gold coins are available with India Post logo in tamper-proof packaging along with certification by internationally recognished  assayers in the  denominations of 0.5 g,1g,5g, 8 g, 10 g, 20 g and 50 g of 24 carat and 99.99 per cent purity The coins are manufactured by the world-renowned Valcambi SA, Switzerland.

Trai: One paisa per second plan mandatory

NEW DELHI: The Telecom Regulatory Authority of India (TRAI) has asked all service providers to ensure that they offer their customers atariff plan of one paisa per second along with other offerings.

The regulator in a tariff amendment order said it had become "mandatory" for service providers to offer in each service area at least one tariff plan each for both postpaid and prepaid subscriber with a uniform pulse rate of 'one second'.

"The service providers will be at liberty to offer alternative tariff plans with any pulse rate within the overall ceiling of 25 tariff plans," TRAI said in a statement.

The rates for premium rate services currently levied by service providers are substantially higher as compared to the normal tariff applicable for a two-way communication due to the fact that the charges levied also include the price for content.

Keeping in view the fact that calls and SMS made for participating in competition and voting hardly contain any content, TRAI's Telecommunication Tariff (Fifty First Amendment) Order 2012 also mandated that tariff for such calls and SMS shall not exceed four times of the applicable local call or SMS charges.

The amendment also provides flexibility to service providers to applyrevision in international long distance tariff uniformly for new as well as existing subscribers.

TRAI had issued a consultation paper in October last year on "Certain issues relating to Telecom Tariff" seeking views of stakeholders.

Most of the operators opposed when asked if one standard plan for all service providers particularly for a prepaid subscriber would be relevant in the present scenario of Indian telecom market.

The regulator has also retained the existing cap of 25 tariff plans that can be offered by access service providers including post-paid and pre-paid.

Source -TOI

Get old look to Gmail

If you have given new look to your Gmail account and it is now irritating you, eager to have that good old look but not finding option, please login to your Gmail account and click the link below.

Have old Look

To get this old look as and when you need it ,in Firefox-Bookmark your old look inbox

In Internet Explorer-Add old look inbox to Favorites.
First login to your Gmail.You will get new look.Then click Bookmark or Favorite.You will be taken to Old Look.

Courtesy : http://srfix.blogspot.in/

Repair Internet Explorer with Fix IE Utility

We are pleased to release the Fix IE Utility v 1.0. This freeware portable utility re-registers all the concerned dll & ocx files required for the smooth operation of Internet Explorer.

Simply extract the contents of the .zip file and run the  utility.

If you face any problems while running IE, maybe after recovering from a malware attack, and if you find that the Reset Internet Explorer feature does not help you, run this tool to re-register around 89 dll & ocx files, which are required for the smooth running of Internet Explorer.

Fix IE Utility has been tested on IE 7, IE 8 and IE 9, on Windows Vista & Windows 7.  Before running the utility, make sure that all your Internet Explorer windows are closed.

Download

Courtesy : www.thewindowsclub.com & http://sapost.blogspot.in/

SQL: Query to find Duplicate Rows in a Table

If you would like to list duplicate rows with the count for a table, the following query would be helpful.

Query: Duplicate Rows

SELECT Column1,Column2,Column3,Count(*)
FROM dbo.TableName
GROUP BY Column1,Column2,Column3
HAVING ( COUNT(*) > 1 )

And there are scenarios where we need to find the combination of Columns in a table occurred only once. In such case the following query could be used.

Query: Unique combination of columns

SELECT Column1,Column2,Column3,Count(*)
FROM dbo.TableName
GROUP BY Column1,Column2,Column3
HAVING ( COUNT(*) = 1 )

Hope it helps.
Source : http://sapost.blogspot.in/