Friday, April 30, 2010

Bak Flip Truck Covers

Guys, when you happen to preserve your Bmw car in a garage or carport mud and particles can still find a method beneath the hood and create grime construct-up that will cause your engine to work at lower than peak performance. It is obvious use a top quality bak flip truck bed cover is when you’ll want to keep your vehicle outdoors. Rain, wind, intense UV daylight, snow, dust and many different foul climate hazards can all combine to wear down exterior paint jobs, uninteresting windshields and home windows, erode tire rubber and water log sensitive engine parts. Your car is a significant investment, one which retains you transferring and capable of get by way of your day. Many individuals rely on their autos for work, errands and family transportation so they want their car to be reliable. It is just my opinion.

Van Racs

I like to share my views on bicycle carrying systems for cars. The type which rests on the back of cars and is held by straps does not inspire confidence in me. I seem to recall reading that a motorcyclist had been killed when one of these failed; also I know someone whose bike fell off one of these on the motorway. The roof mounted type are better in my view but there must be concerns about car-handling, damaging your car and of course one has to lift the bikes up which may not be so easy for older people. However, they are very popular.

In my experience, rear mounted systems using a towbar and additional illuminated number plate are the safest and best option. Do members recommend any particular make? Thule, Westfalia and Witter make systems which can carry up more weight: the latter works by hanging the bikes from what looks like a large set of upturned handlebars which slots onto a metal stem, whereas the former two use a hauler on which the weight and the goods stand on.

Access Covers!

Maintenance is keeping your car working well and looking good. There are basically two maintenance theories: do-it-yourself and let-someone-else-do-it. Most do-it-yourselves have a fundamental knowledge of how an automobile works and how to keep it working. They can, and most prefer, to do routine maintenance like changing the oil or replacing spark plugs. They have an intimate relationship to enjoy getting grease on their new sweat suits. Cars, as you might suspect, require more attention that we should always see to its accessories, access tonneau cover and check for oil etc. Even those in the let-someone-else-do-it camp who have bought old cars have a number of tasks they must do regularly to keep that vehicle in good condition.

Car Accessories

Ah! Right from the morning, something or the other stopped me to do anything.I got up late than usual and the breakfast was not ready and so i had to skip my breakfast. With an unclear mind, I started to office. There was a small accident and there gathered a hell lot of people and I got stuck up in the main road. I felt restless and went on walk to see what was the issue over there.


An auto-rickshaw had hit a car in sideways and the mud flaps were damaged. The argument was so big and a huge traffic lined up the spot. I directed the car owner to go through RealTruck.Com and purchase a mud flap. The issue got resolved and he moved the car then. I happily drove my way to work. For any of your car or truck related accessories, I would recommend RealTruck.com for you.

Thursday, April 29, 2010

Planning for my Masters

Gags, My only wish for the past 2 years is just to do a masters degree abroad. I have a strong liking to carry on with my Master's in health sciences, Master of Public Health (MPH). My health condition makes me feel that I can definitely pursue my studies with ease. Am looking forward to start the course by this December for which I need to apply before August. Studies apart, I have always dreamt of being there for my girl who is currently studying there. Doesn’t it sound good? I always feel that I haven’t been to her expectations. I always want to be with her and pour all my affection towards her. In simple words, I want to make her realize my love towards her. Nowadays, she is very much worried about something and she tells me that she is missing me a lot. Whatever it may be, am it gives me a great feeling when I think of doing my master's abroad. Initially I thought of doing a course on Doctor of Business Administration (DBA) and after a big confusion I decided on MPH. I am sad for the only reason that I am not able to fulfill my dad's wish to make me do a degree on Doctor of Education (Ed.D.) and also for the reason that am going to miss my friends a lot more than anything. As I always say, my friends are always great and I can never let them go. I am worried of missing my most beautiful friends. Hoping for the best to happen!

Wednesday, April 28, 2010

Article Writing!

It is a known fact that internet is ever-growing. Am puzzled whether you guys know that sharing your views over the web gives you money. Yes, recently I happened to check into a revenue sharing writing site where you can share your articles and get paid for it. I found it interesting as they give you the money based on the number of visits. I have made my mind to write articles in a natural way with no less quality. The are open to a variety of topics and are ready to publicize your content to a greater extent. The benefit is that we are paid about 80% of the total payout. Ain't it interesting? Hope it will be useful for we bloggers.

What is global warming?

Global warming is the term applied to an increase in the overall temperature of the earth. More precisely, it is a significant sustained increase in the average temperature of Earth’s landmasses, oceans, and atmosphere which causes climatic changes relatively over a short period of time as a result of the activities of humans. Human activities since the Industrial Revolution as resulted an increase in greenhouse gases. This buildup of greenhouse gases result an increase in the world's temperatures by a process known as the greenhouse effect.

Just a small rise in temperature ( 2° F or 1.1°C) can have serious effect on climatic conditions and weather changes. This could affect the frequency and severity of storms, hurricanes and tornados, distort seasons duration, increased cloud cover, change in precipitation level and wind pattern. Warmer sea surface temperatures will cause frequent and more storms and hurricanes along the Gulf coasts and southeastern Atlantic.

Auto Parts

Gags, nowadays it is very good to go in my car to work. I feel the comfort and enjoy my drive from home to work everyday. Driving a car is not a fashion but to maintain it in a proper condition is a challenge. Day before yesterday, a guy in bike overtook my car in a very crooked road and the result was that my tail light got damaged. I felt bad and drove my way to work. After an hour, I looked upon Auto Parts in the web and ordered it right from my workplace. I wondered that it was so simple to lace an order online. So maintain your vehicles with suitable spare parts whenever necessary.

Serve The Mankind

Service to mankind is service to God. I always feel dejected when I see physically challenged people. I will go ahead and aid them in the best way I can. It makes me question God while seeing the blind people. Deaf or dumb can manage a bit when compared to the blind. I hope you all agree on the above statement. If any of your friends are in need of a better doctor to perform Lasik surgery, I would definitely recommend Dr. Thierry Hufnagel, a famous Ophthalmologist. Lasik vision recovery seems to be the fastest surgery wherein the patient will be able to see well in a day or two. Guys, just check out and please help the needy people.

Tuesday, April 27, 2010

Me and My Jimmy

Hi friends, all the day though I was thinking about what to give in as my next post. Suddenly, a thought arose and asked me why I shouldn’t write about my pet dog jimmy that lives at my home. It is the best friend I have ever got. I always love to play with jimmy and would pass my time by just looking at the crazy pranks that it does. I will give lot of importance to jimmy and to pen, it is very naughty that it will eat only mutton. Similarly, I can never give up even if a small insect sits over him. Jimmy manages to fight against all the insects well except fleas. For your information, fleas is the term that indicates any type of small, wingless, bloodsucking insects that have legs adapted for jumping and are parasitic on warm-blooded animals. Cockroaches can also be counted under fleas. Even I enjoy watching it fight. I will also fight with jimmy but you won’t believe it will be funny to fight with him. One more I wish to say is my jimmy’s agility. It’s beyond words. Any person with any breed of dog can understand a dog’s agility. All you need is a positive attitude, commitment, teamwork, and proper training for the dog. It is a great way to exercise while building a strong bond between you and your pet. The benefits of agility are unlimited for dogs and people of all ages and backgrounds.

Air Purifiers

Guys, last two days was hectic with work and I was unable to give time for anything.When we buy a vehicle or a property, we would always check for the vehicle's condition, the genuineness of the seller, the documents etc. There are also essential things in life which are of greater importance and we are least bothered to check for its purity. For an instance, consider air, water, fire etc. There are companies like Aqua to enhance the purity of drinking water. You might ask me how does air be impure? Have you heard of air pollution? The air that comes out of vehicles, the dust that settles on your floor, the air that gets mixed up with the natural air, everything add to produce polluted air. We can never avoid stepping out as a preventive measure but we can always reduce and limit ourselves to stay away from polluted air. As I browsed through, I got to see a guide on ozone air purifiers. There are a lot of guidelines, ways and advices to stay away from polluted air. I understood a lot after surfing the site and specially got to know about the living air that is the air we breath in & out. There are various types and brands to look upon. Just stay safe and see to that the air or water you take in is pure.

Saturday, April 24, 2010

Chennai's Public Transportation

Most of Chennai's intra-city transport requirements are met by an extensive public transport system. The bus service, which is run by the government-owned Metropolitan Transport Corporation covers the city and its suburbs extensively.Bus services are generally considered efficient, but buses on some routes can get very crowded at times. The bus service, which plies about 2773 buses on 375 routes, moves an estimated 4.2 million passengers each day.

In addition to the bus service, private metered call taxis, fixed rate tourist taxis and metered autos are extensively used. In the case of autos though, drivers often demand flat rates especially for short distances(say 1-2 km). Vans which are run like bus services and popularly called "Maxi Cabs" also ply on many routes in the city. The suburban areas of the city are also served by private mini bus company services as well as government bus transport corporations of neighboring districts.

Despite a sharp increase in the number of four wheelers in the city many private vehicles are motorcycles, mopeds or scooters, all of which are preferred to cars for their lower prices,fuel efficiency, maneuverability, and ease of parking.

Online Banking

The advancements over the web has changed our lives to a greater extent. Some 10 years ago, if person needs to get a loan, he/she should approach the bank, complete a hell lot of formalities to get the loan approved. But today, it is just a click away. In a similar fashion, we were not exposed to online banking before. But today, a person just logs into his/he account and makes the payment by linking his credit card. Online payment services allow business and consumers to exchange money electronically over the internet. These services can act as a replacement or a supplement to accepting credit cards and have recently become very poplar with merchants and consumers. Moreover, we can also maintain our account online and take control of our debt through Cavalry payment services. The transactions are processed within a few seconds. Guess how long does it take the service to process a single transaction? Slow transaction processing can deter customers from making a purchase and subsequently dwindle the repeated use of online banking. So, all the providers across the globe would process the credit card transactions in less than one minute. These services make ou business over the internet to receive payment from any customer with an email account. With an online payment service, your business can directly deposited funds, issue and mail checks, and store account funds to be used through a debit card. So guys, create an account online and speed up your transactions.

Thursday, April 22, 2010

My Cousin's Reception

Gags, I would like to continue writing about my cousin's marriage reception in this post. As mentioned before, the day was full of fun. Many important persons were invited and everyone were just pouring in. The reception stage was decorated with beautiful red roses, some violet and green satin ribbons with lord Ganesha's idol in the center. We took utmost care to arrange for the best right from the Reception Chairs to refreshments post dinner. Everything was done in a grand manner except for the music orchestra. That was also well managed then. Another attraction was my cousin's wardrobe. Ah! He was given a black blazer and a lavender shirt with a dark violet tie and a branded black shoes. It suited him perfectly that he was looking damn smart. Coming to my aunt's (the bride) side, she was also looking good in a grand blue silk saree. In short, the couple attracted the gathering and I felt that they are specially made for each other. The funniest part of the evening was the photos we took with him. My younger brother (4 years old) was jumping when he was made to sit in the reception chair. My cousin then told that he was able to sit better in that chair. Had a nice time!

Wednesday, April 21, 2010

An Enjoyable Day!

Hi Friends, hope you all had a good day at work. I feel glad that I have completed the work that was assigned to me. It was an existing module and I was asked to change the logic. I never thought the out would be so perfect. My manager appreciated me. Also my joy doubled I met my friend at cafeteria after a long time. Had a nice chat with him for almost an hour in the evening. He started talking about the huge collections of Future Fins that are available, As the topic seemed new to me, I was completely engrossed in it. It is always very sweet of him. He is very jocular and witty to such an extent that he will make fun every moment. Though we work for the same organization, we couldn't meet each other often because of the irregularly changing shift timings. Such a nice person who is kid at heart and do anything for his close friends. Hey dude, none can ever be so good to me man. I feel really happy about our friendship and hope we will be friends for life. As per your wish, order and purchase a fin and a surfboard soon man. Let us try to meet often. Try to make it a point. My friends are always great.

Monday, April 19, 2010

Sir Thiyagaraya Nagar

T.Nagar residents are an unusual mix of the traditional and the modern and this is reflected in the way the neighbourhood has been growing. Several new eateries have come up while at the same time, traditional restaurants are also packed. With the city extending its bed-time more every year, the locality has acquired a reputation of always being in the fast lane. The grand textile showrooms close very late at night, and their hoarding boards constantly illuminate the roads. Early in the morning, joggers and walkers take full advantage of the empty roads, with the fresh air that's so hard to come by in this area at all other times of the day. Panagal Park, Natesan Park and Jeeva Park all have their regular crowd and their walkers' associations are extremely active.T.Nagar is also a place of musical intellects.Lot of sabhas are very active during the December month.

In addition, T.Nagar is easily accessible from most parts of the city by bus. The T.Nagar bus terminus off Usman Road is a hub for services operating via the commercial district, including routes to Mylapore, Kodambakkam, Tiruvanmiyur, Ambattur, Pattabiram, Annanagar and Tiruvallur. There are also routes to various places in neighboring Kanchipuram and Thiruvallur districts. Other important bus stops in T.Nagar are Panagal Park, Pondy Bazaar, Power House, and Vani Mahal.

A busy weekend!

Guys, good morning. My cousin's marriage went on cool yesterday and the day was full of fun & frolic. I met all my relatives and was very happy that we all had a nice chit chat and gossips all the day long. For the reception, an orchestra troupe was arranged and at the last moment, their team didn't turn up as the troupe leader met with an accident. Everyone were so puzzled as how to cheer the gathering with pleasant music. Suddenly, an idea struck my mind that I patiently took my laptop, surfed through the web, downloaded a plenty of songs from free torrents and just connected my audio output to those loudspeakers in the hall. All the people there appreciated me for my work. Things are very simple. I just downloaded and played the music they want but they felt as if I had made their evening.

Above everything, my cousin was on cloud nine yesterday. He was looking very smart and reticently was giving pose to all the camera clicks with his sweet smile. My aunt told me that she doubts whether the orchestra would have pleased the gathering this much. Another highlight was the dinner. A clean buffet was on the court with a number of varieties, both veggie and non-veg. Apart from the dining, some chat items and snacks were arranged right up at the reception hall so the people could enjoy the happenings with some starters. On the whole, had a good get together and I wish my sweet cousin a happy married life through this post.

Friday, April 16, 2010

Real Estate!!!

During periods of rising house prices, falling interest rates, and increasingly competitive and efficient refinancing markets, cash-out refinancing is like a ratchet, incrementally increasing homeowner debt as real-estate values appreciate without the ability to symmetrically decrease debt by increments as real-estate values decline. This paper suggests that systemic risk in the housing and mortgage markets can arise quite naturally from the confluence of these three apparently salutary economic trends. Using a numerical simulation of the U.S. mortgage market, the researchers show that the ratchet effect is capable of generating the magnitude of losses suffered by mortgage lenders during the recent financial crisis. These observations have important implications for risk management practices and regulatory reform. We should recognize both the risks and the advantages inherent in a robust credit industry. What all of this means for real estate investors who want to add to their portfolios is an increased opportunity to hunt for and find worthwhile bargains. I felt worthwhile while I bought a farm through Jacksonville NC Real Estate. It is always that a homeowner who has been unable to keep up with the mortgage payments often has also been unable to keep up with the maintenance of the property. So guys, be careful and make a articulate decision while investing.

Funeral Insurance Cover

Life starts by birth and ends by death. It is unfair if I post only the moments that we enjoy. We should also think the other way around. So I thought of giving a post related to death of a person and so here I am. There are people who don't even have money to have their basic needs and some others will be tensed and will lose their senses when any of their relatives die. At these situations, people are unaware as to what to do on the funeral day. If somebody asks me the question, "Are you scared of arranging for funerals when someone passes away?", I would definitely say "no". The reason being I have got a funeral insurance quote for myself. You might have heard of various life insurance plan but a funeral Insurance is that it will look after your family and loved ones and make sure your ideas are delivered the way you need when you pass away. Isn't that interesting? I found it to be safe and worthy. Like any other plans, you can get monthly premium, you can plan up well in advance and look it up in a broad-minded manner. You can be sure of your wishes being recorded. Don't mistake that I am asking you to think of death right now but it is a fact that we, all the humans who are born gonna die someday or the other. If you wish, you can also get a funeral insurance plan.

Thursday, April 15, 2010

How do Astronauts communicate in space?

In order for one to hear sound it must travel through air (gas particles) of which space has very few per cubic centimeter. Sound can only travel through a solid, liquid or gas. Space being an almost perfect vacuum does not allow sound to travel and be heard by the ears. Sound is vibrations of air particles, so any “sound” that is heard in space has to come from other means such as from the electromagnetic spectrum and these waves are not sound.

As such, astronauts communicate with each other in space when they are spacewalking through the use of radio waves. Radio wave signal are sent to their headsets which then translates the signal into the form of sound . When receiving and sending message to earth it is sent in the form of radio waves which is then translated to sound wave (message) by a radio set. Radio wave is a part of the light spectrum called electromagnetic spectrum (click here to see diagram) and is therefore a light wave. Light does not need a medium to travel and this, further explains why the Sun’s light travels through space to earth. Light waves are not sound waves. Astronauts can however, talk to each other as if they were on Earth only when they are in their space ship. Here, there are enough air particles to vibrate and take the sound to their ear drum.

Wednesday, April 14, 2010

Hair Loss???

Friends, I feel amazed. Wikipedia contains all the details you require. It is almost more than eight years and the work of vast numbers of people around the world, but the English version of Wikipedia has finally amassed more than what they actually predicted. The site broke through the 3 million barrier early on Monday morning, with the honors taken by a short article about Norwegian actor Beate Eriksen - a 48-year-old cast member of a popular local soap opera. Although the latest milestone was reached without much fanfare - a short announcement was one of the few mentions of the breakthrough. It still marks a significant achievement for a project which says its aim is to collect the sum of all human knowledge.

Do you know? The English version of Wikipedia remains the largest, attempts in other languages continue to expand. The French Wikipedia now has more than 800,000 articles, while the Japanese, Polish and Italian sites have around 600,000 each. The German version of the site is also awesome. I happened to browse through these details when I went though an article related to ISHRS. Just for your information, Wikipedia was founded in 2001 by a team including web entrepreneur Jimmy Wales and philosopher Larry Sanger. There are a plenty of information over the web. Try to make the best use of it.

Earth Day!

With respect to vehicle cost, added is the fuel cost too. I am planning to contribute towards the Earth Day! I was unable to get an accurate handle on the effect that the use of hydrogen fuel cells has on the price due to the fact that the purchase costs of the hydrogen vehicles clearly included development and infrastructure capital costs that have been extremely diluted for the diesel ICE bus. However, it can be said that the price of the fuel cell stacks is quite noticeable at $268/kW. For a standard 70 kW passenger car, this adds up to a cost of $18,760, which is very significant. 100 years from now, this is projected to have changed, as by 2020 the price of the fuel stacks is projected to have dropped to around $38/kW, corresponding to an engine cost of $2,660, which is much more reasonable. However, there are problems on the horizon with respect to the platinum reserves. If hydrogen fuel cell vehicles were to become the primary source of transportation for the entire world, the demand on the platinum reserves would exceed the supply. Fortunately, there has been progress with respect to the catalyst. Additionally, I always go through Fuel Doctor News and Reviews on a daily basis. Quantum Sphere corp developed a nano-metal electrode formulation that drastically increases electrolysis efficiency, and considering that fuel cells are just the reverse of electrolysis, it is, in my opinion, very likely that we will manage a way to catalyze the reaction efficiently without the use of significant amounts of platinum. Save Fuel, save your country!

Tuesday, April 13, 2010

Planning for a Tour

Hey guys, am glad that the tour which we were longed for is finalized now. We were actually planning for it for about 4 months and each time one or the other said no to it. The very reason being everyone must get their leaves approved by their organization. Yes, all of us have become busy with our professional lives and we definitely need a break and hence the tour plan is initiated. We have got five full days and we are yet to decide on the places as to where to step in. We are planning to book as a complete tour package and move on. I personally would suggest Costa Rica Resort who promises a very good in-country travel package. The prices are bit cheap when compared to those provided by other resorts. Right from the departure to the arrival, they would take care of everything. Remember, the price they quoted includes even the food that we are going to have. Just think off guys. If everyone are okay with it, let us go ahead and book the same. If you have any other suggestions, kindly let me know. Don't think much, we should finalize as soon as possible. Meanwhile, someone do inquire about the air fares and the tram facilities. Looking forward for a good time. We can rock!

Attacked by Ants

Hope the day starts fine for you but not for me (ha haa). I dint sleep the whole night as I was terrifically attacked by a group of ants and not mosquitoes (pity me!). I thought of writing it up over here in my blog. I am a person who will never sleep even if there is a small disturbance. Sometimes I even feel the whirling sound of fan is noisy. Yesterday, there was a function at home and all my relatives visited during which some children were playing and were eating the sweets on my bed. They would have scattered it and hence the ants surrounded the sweet bits I guess. Do any one of you know how to get rid of ants? If so, please do suggest me the best way to get rid of ants. I have heard many people at work saying that they lost their sleep due to mosquitoes but I wonder what would happen if I go and tell them ants made me off? Everyone would think that this guy had encountered something wrong last night, he might have drunk and is just blabbering, laugh at me and so on. For all those funny minds, I would show this blog post as a proof. Even then, everyone would make fun of me. Mm expecting a good day at work. Good day to you too!!!

Sunday, April 11, 2010

Fancy Lamps

With my house construction is almost completed, it is giving me a great look now. I am looking out for decorative lamps to fit in. I am planning to go for indoor lighting on sale. Lampshades are an integral part of any kind of lamp and give the lamps their decorative uniqueness and grandeur. Lampshades cover the lighting fixtures and deliver a soft glow, lending a serene and subtle beauty to the lamps. Lampshade designs vary from extremely traditional and ornate to simple trendy ones. However, irrespective of their designing pattern and style, lampshades complement lamps and fascinate homeowners.

Lampshades are made of glass, cloth, silk and other transparent materials. Various ornamental items are used to enhance the look and decorate these shades. Colorful cloth embroideries, beads, shells, paintings, fabrics, stained glass and prints are some of the most common materials used to decorate the shades. Hurricane gall shades are also popular lampshades, bearing a traditional look. These lampshades were used with non-electric lamps, such as gas or oil wick lamps. However, hurricane glass shades are now used for electric lamps as well and impart the look of an oil lamp. A collection of lampshades of different make, model, purpose and price can be found online. Buyers can view online catalogs or visit the local lampshade dealers for buying or replacing lampshades. However, the owners may change their lampshades with the changing time and fashion, reflecting their personal choice. Hope I would get a better lamp.

Flash Games!

Gaming is very interesting when it comes to flash games. Generally, kids enjoy playing games on their personal computer. I have also given a positive nod to those games when I entered my senior secondary level. Nowadays, kids have started playing games right from the age of 6. Flash games makes them fulfilled. One fine day, I saw my younger brother playing the flood runner game through funbrain. The game was very interesting and I just loved the way he played. He will always be playing Need for speed and now he is more into flash. Never thought that he would like flash games to this extent. Even I also have a strong liking towards the Deep Destroyer and the Copter games. My favorite of the two is DD. During my graduation, I was madly into Counter Strike, Quake and the Age of empires. We guys used to play CS even during our lab hours at college. Those days won't come back. Another game that is making me play is the space ball 2. Just try playing flash games as they make you think logically at the same time, the games are ore funny. It perfectly suits to my brother and he is in front of the system for about 4 hours a day. Oh God! I don't know where does it gonna end. Try flash!

Friday, April 9, 2010

Difference between JOINS and UNION in SQL

In this post, I have given the difference between the use of Joins and the use of Union keyword in SQL.

I have a table named Table1 with Severity, Response SLA and Resolution SLA as its columns. Now I need to take the number of issues for both Response SLA and Resolution SLA based on Severity.

1. Using Inner join:

SELECT A.[Severity],A.[ResponseSLA],A.[Count],B.[ResolutionSLA],B.[Count] FROM
(
SELECT [Severity],[ResponseSLA], Count(1) As [Count] FROM Table1
WHERE GroupID = 4 AND [Month] = 'Mar - 2010'
GROUP BY [Severity],[ResponseSLA]
) A
INNER JOIN
(
SELECT [Severity],[ResolutionSLA], Count(1) As [Count] FROM Table1
WHERE GroupID = 4 AND [Month] = 'Mar - 2010'
GROUP BY [Severity],[ResolutionSLA]
) B
ON A.[Severity] = B.[Severity]
Order By A.[Severity]

The above query fetches the following result:

Severity

ResponseSLA

Count

ResolutionSLA

Count

Sev2

Not Met SLA

1

Not Met SLA

1

Sev3

Met SLA

29

Met SLA

31

Sev3

Not Met SLA

2

Met SLA

31

Sev4

Met SLA

597

Met SLA

613

Sev4

Not Met SLA

16

Met SLA

613


Note: You can replace "SELECT A.[Severity],A.[ResponseSLA],A.[Count],B.[ResolutionSLA],B.[Count] FROM" With "SELECT * FROM" and fetch all the columns.

2. Using Union:

Consider you need to calculate the total count. Then you should query as below.

SELECT * FROM
(
SELECT [Severity],[ResponseSLA], Count(1) As [Count] FROM Table1
WHERE GroupID = 4 AND [Month] = 'Mar - 2010'
GROUP BY [Severity],[ResponseSLA]
) A
UNION
(
SELECT 'Total' [Severity],'' [ResponseSLA], Count(1) As [Count] FROM Table1
WHERE GroupID = 4 AND [Month] = 'Mar - 2010'
)

The above query fetches the following result:

Severity

ResponseSLA

Count

Sev2

Not Met SLA

1

Sev3

Met SLA

29

Sev3

Not Met SLA

2

Sev4

Met SLA

597

Sev4

Not Met SLA

16

Total


645


Note: In UNION, the number of columns and the column names should match. In this case, the columns of both A & B should match each other.

Hope you understood the difference. Joins always add the columns to the left and the union statements add the columns to the bottom of the result grid.

Flipkart.com

  Flipkart, founded by the Bansals in 2007 is now being headed by Kalyan Krishnamurthy since 2016. A Billion dollar firm with more than 70 m...