Skip to main content

Posts

Showing posts from July, 2012

Concept of Mutual Funds

Concept of Mutual Funds A mutual fund is a trust that pools the savings of number of investors who share a common financial goal. The money thus collected is than invested in capital market instruments such as shares, debentures and other securities. The income earned through these investments and capital appreciations realized are shade by its unit holders in proportion to the number of units owned by them. Thus a mutual fund is the most suitable investment for the common man as it offers an opportunity to invest in a diversified, professionally managed basket of securities at a relatively low cost. Definition Mutual funds are associations or trusts of public members who wish to make investment in the financial instruments or assets of the business sector or corporate sector for the mutual benefit of its members. The funds collects the money of these members from their saving and invests them in a diversified portfolio of financial assets with a view to reduce risks and to maxi

What are the Key differences between IPv4 and IPv6.

What are the Key differences between IPv4 and IPv6. IPv4 Source and destination addresses are 32 bits (4 ytes) in length. IPsec header support is optional. No identification of packet flow for prioritized delivery handling by routers is present within the IPv4 header. Fragmentation is performed by the sending host and at routers, slowing router performance. Has no link-layer packet-size requirements and must be able to reassemble a 576-byte packet. Header includes a checksum. Header includes options. ARP uses broadcast ARP Request frames to resolve an IPv4 address to a link-layer address. Internet Group Management Protocol (IGMP) is used to manage local subnet group membership. ICMP Router Discovery is used to determine the IPv4 address of the best default gateway and is optional. Broadcast addresses are used to send traffic to all nodes on a subnet. Must be configured either manually or through DHCP for IPv4. Uses host address (A) resource records in the Domain Name S

Famous things of cities and states in India

India Is Famous due to following reason. Lucknow is  famous for its monuments like bhool bhulaiya Mumbai is  famous for  port. Agra is famouse for Tajmahal. Cochin is famous for its busy harbour complex which has found a safe haven in the Vembanad Lake waters. Shahjahanpur is famouse for Carton and Tilhar place of Shahanpur district is famous for Laung sweats. Sitapur is famous for Basen laddu. Ratlam is famous for Ratlami save namkeen. Andhra pradesh is famous for hyderabad biryani and haleem ,spicy foods,  ladies wear in hyderabad, redchilly from guntur Assam state is famous for Tea. Goa is famous for beaches and church. Kerala  is famous for cocunuts and cocunut oil,backwaters, lagoons, hill station. Maharastra  is famous for industrys, shipping. Karnataka  is famous for Bangalore IT professionals and engineering, coffee. Kashmir  is famous for apples. Utter pradesh  is famous for sugar, varanasi temple,taj mahal, handicrafts, aundh cuisine, etc.

Converting Resultset Into User Defined Name using select query in sql

Converting Resultset Into User Defined Name using select query in sql example SELECT date_format( doj, '%d/%m/%Y' ) AS week ,COUNT(user_id) FROm user_tb  WHERE doj between '2012-01-01' AND '2012-01-31' group BY WEEK(doj) Outlput will be like this Result week    COUNT(user_id) 06/01/2012  3 17/01/2012  2 25/01/2012  3 29/01/2012  1  

Total number of following things

Total number of following things Total number of websites in this world - 232000000 Total number of blog in the world - 70 million blogs Number of email accounts worldwide -3.146 billion Internet users worldwide-2.1 billion . Total number of countries in world-243 Total number of cities in the world-36,722 Total number of companies in world-100000000 Total number of banks in the world -1,000,006 The total number of railway stations in India -7000-8000 Total number of airports in the World are approximately 14000 airports. Total number of villages in world-3,900,000.(Approx.) Total Population of the World by Decade, 1950–2050 Read more: Total Population of the World by Decade, 2020 7,584,821,144 Total number of religion in the world-more than 730 established Religions Total languages in the world-6912 This is prediction which taken from different websites. Number may change in future. This post will show you only approximate result.

Splitting a String to a Certain Position,Pulling a Row Prior to Maximum Row,Update in Table in sql

Splitting a String to a Certain Position  substring('abc/123',charindex('abc/123','/')+1,3) Pulling a Row Prior to Maximum Row in sql SELECT    es.emp_employee_id    ,MAX(es.emp_stat_eff_dte) FROM emp_status es WHERE es.emp_stat_eff_dte <    (    SELECT       max(es2.emp_stat_eff_dte)    FROM emp_status es2    WHERE es2.emp_employee_id=es.emp_employee_id    ) order by es.emp_employee_id Update Table from Select Statement in sql To Update Table from Select Statement in sql you can see below example. E.g. update customers CUST set CUST.likes_us = 'Y' where CUST.link_id in  (select distinct REST.link_id   from restaurant REST   where REST.rest_type = 'Diner') and CUST.likes_us is null

Pivot Multiple Columns in sql server

MY table name  product1 ID    Amount      Date ---- 1    300     02-02-2010 00:00  2    400     02-02-2009 00:00  3    200     02-02-2011 00:00  4    300     22-02-2010 00:00  5    400     12-02-2009 00:00  6    500     22-02-2009 00:00  7    600     02-02-2006 00:00  8    700     02-07-2012 00:00  9    500     08-02-2012 00:00 10    800     09-02-2011 00:00 11    500     06-02-2010 00:00 12    600     01-02-2011 00:00 13    300     02-02-2019 00:00 Desired output:    Y1          Y2            Y3 ...........  sum(amount)   sum(amount)   sum(amount) What is an approach, where Y1 is the year part of the date, such that the result column would be the following? YEAR       2006   2009    2010   2011   2012 -   --------- Total         600   1300     800   1900   1200 Create procedure [dbo].[pivot] as begin DECLARE @Years nvarchar(max) SELECT @Years = STUFF( ( select distinct ',[' + cast(Year([Dates]) as nvarchar(4)) + ']' fro