Wonderful!!! This movie was taken last night which it pre-launch of firework for Singapore National Day 2008.
Read more...
Monday, July 14, 2008
Monday, July 7, 2008
Simple SQL Table Join
I would like to share about the simple join in my web page. The page is very draft but I hope it will be a useful information for a beginner of T-SQL.
TABLE JOIN
Create Test Table
USE [TESTDB]
GO
/****** Object: Table [Test] Script Date: 07/08/2008 11:46:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [Test](
[col1] [varchar](5) NULL,
[col2] [varchar](5) NULL,
[col3] [varchar](5) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
Create Test1 Table
USE [TESTDB]
GO
/****** Object: Table [Test1] Script Date: 07/08/2008 11:45:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [Test1](
[ID] [varchar](5) NOT NULL,
[total] [smallint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SELECT * FROM TEST
Result
===========================
col1 col2 col3
1 AA dd
2 bb ee
8 NULL NULL
GO
SELECT * FROM TEST1
Result
========================
ID total
1 100
2 200
6 150
INNER JOIN RESULT With Test and Test1 Tables
Return the rows from both tables which match the On clause condition
SELECT * FROM TEST1 a INNER JOIN TEST b on a.ID = b.col1
Result
=============================
ID total col1 col2 col3
1 100 1 AA dd
2 200 2 bb ee
LEFT JOIN RESULT
The result contain all rows from the left table and match rows from the right table.
SELECT * FROM TEST1 a LEFT JOIN TEST b on a.ID = b.col1
Result
=============================
ID total col1 col2 col3
1 100 1 AA dd
2 200 2 bb ee
6 150 NULL NULL NULL
RIGHT JOIN RESULT
The result contains all rows from the right table and match rows from the left table.
SELECT * FROM TEST1 a RIGHT JOIN TEST b on a.ID = b.col1
Result
=============================
ID total col1 col2 col3
1 100 1 AA dd
2 200 2 bb ee
NULL NULL 8 NULL NULL
LEFT OUTER JOIN RESULT
Same with left outer join.
SELECT * FROM TEST1 a LEFT OUTER JOIN TEST b on a.ID = b.col1
Result
=============================
ID total col1 col2 col3
1 100 1 AA dd
2 200 2 bb ee
6 150 NULL NULL NULL
RIGHT OUTER JOIN RESULT
Same with right join.
SELECT * FROM TEST1 a RIGHT OUTER JOIN TEST b on a.ID = b.col1
Result
=============================
ID total col1 col2 col3
1 100 1 AA dd
2 200 2 bb ee
NULL NULL 8 NULL NULL
FULL OUTER JOIN RESULT
The result contains all the rows from the left table and all the rows from the right table.
SELECT * FROM TEST1 a FULL OUTER JOIN TEST b on a.ID = b.col1
Result
=============================
ID total col1 col2 col3
1 100 1 AA dd
2 200 2 bb ee
6 150 NULL NULL NULL
NULL NULL 8 NULL NULL
CROSS JOIN RESULT
The result contains every row in first table is
joins with every row in second table without having any condition in the cross join.
SELECT * FROM TEST1 CROSS JOIN TEST
Result
=============================
ID total col1 col2 col3
1 100 1 AA dd
2 200 1 AA dd
6 150 1 AA dd
1 100 2 bb ee
2 200 2 bb ee
6 150 2 bb ee
1 100 8 NULL NULL
2 200 8 NULL NULL
6 150 8 NULL NULL
Read more...
TABLE JOIN
Create Test Table
USE [TESTDB]
GO
/****** Object: Table [Test] Script Date: 07/08/2008 11:46:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [Test](
[col1] [varchar](5) NULL,
[col2] [varchar](5) NULL,
[col3] [varchar](5) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
Create Test1 Table
USE [TESTDB]
GO
/****** Object: Table [Test1] Script Date: 07/08/2008 11:45:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [Test1](
[ID] [varchar](5) NOT NULL,
[total] [smallint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SELECT * FROM TEST
Result
===========================
col1 col2 col3
1 AA dd
2 bb ee
8 NULL NULL
GO
SELECT * FROM TEST1
Result
========================
ID total
1 100
2 200
6 150
INNER JOIN RESULT With Test and Test1 Tables
Return the rows from both tables which match the On clause condition
SELECT * FROM TEST1 a INNER JOIN TEST b on a.ID = b.col1
Result
=============================
ID total col1 col2 col3
1 100 1 AA dd
2 200 2 bb ee
LEFT JOIN RESULT
The result contain all rows from the left table and match rows from the right table.
SELECT * FROM TEST1 a LEFT JOIN TEST b on a.ID = b.col1
Result
=============================
ID total col1 col2 col3
1 100 1 AA dd
2 200 2 bb ee
6 150 NULL NULL NULL
RIGHT JOIN RESULT
The result contains all rows from the right table and match rows from the left table.
SELECT * FROM TEST1 a RIGHT JOIN TEST b on a.ID = b.col1
Result
=============================
ID total col1 col2 col3
1 100 1 AA dd
2 200 2 bb ee
NULL NULL 8 NULL NULL
LEFT OUTER JOIN RESULT
Same with left outer join.
SELECT * FROM TEST1 a LEFT OUTER JOIN TEST b on a.ID = b.col1
Result
=============================
ID total col1 col2 col3
1 100 1 AA dd
2 200 2 bb ee
6 150 NULL NULL NULL
RIGHT OUTER JOIN RESULT
Same with right join.
SELECT * FROM TEST1 a RIGHT OUTER JOIN TEST b on a.ID = b.col1
Result
=============================
ID total col1 col2 col3
1 100 1 AA dd
2 200 2 bb ee
NULL NULL 8 NULL NULL
FULL OUTER JOIN RESULT
The result contains all the rows from the left table and all the rows from the right table.
SELECT * FROM TEST1 a FULL OUTER JOIN TEST b on a.ID = b.col1
Result
=============================
ID total col1 col2 col3
1 100 1 AA dd
2 200 2 bb ee
6 150 NULL NULL NULL
NULL NULL 8 NULL NULL
CROSS JOIN RESULT
The result contains every row in first table is
joins with every row in second table without having any condition in the cross join.
SELECT * FROM TEST1 CROSS JOIN TEST
Result
=============================
ID total col1 col2 col3
1 100 1 AA dd
2 200 1 AA dd
6 150 1 AA dd
1 100 2 bb ee
2 200 2 bb ee
6 150 2 bb ee
1 100 8 NULL NULL
2 200 8 NULL NULL
6 150 8 NULL NULL
Read more...
Monday, January 21, 2008
APPLE MacBook Air
Wowed...!!! Apple Congratulation ...
Everything about MacBook Air has been streamlined. And then streamlined again. Except for the things that shouldn't be, starting with the full-size, backlit keyboard and 13.3-inch widescreen display. On the inside (yes, there's an inside), it boasts an
Features of MacBook Air are as follows.
1. Utrathin, utraportable
2. From a slimmer hard drive to strategically hidden I/O ports to a lower-profile battery
3. take full advantage of the wireless world, 802.11n Wi-Fi
4. built-in iSight Camera
5. 2GB of RAM built in
6. 1.6GHz or 1.8GHz Intel Core 2 Duo processor
Up to now, the price is $1799. Himmmmm... No money.. :D
Read more...
Monday, November 5, 2007
Happy Holidays in Singapore
~~ I'm very happy in holidays since I was at childhood still an old lady at present. :P ~~ So that I collected the holiday information for 2008. Happy holiday in 2008. But so few... :( ~~~
Read more...
Read more...
eight tips to balance your food choice
Today I would like to share my health knowledge on my blog.
I notify my image is getting fat day by day like a apple - pear shape, with a plumpy tummy and big hips.. :D :P heee..hee.So that I'm a golf stage among my friends - the player(guy) kick as far as they can. Kidding :P. Regarding to one health article, there are many shapes among the people as follows.
brown 'Take care' area
your body shape - brown area
This means you will probably have a tall thin 'chilli' type of shape. This isn't desirable for good health so you need to take care. You may need to gain weight.
green 'OK' area
your body shape - green area
This means you will probably have a healthy 'pear' shape, which is a healthy shape. With this type of body shape, any excess fat is stored under the skin around the bottom, hips and thighs, which is less harmful to health than having an apple shape.
amber 'Take care' area
your body shape - amber area
This means you will probably have a 'pear-apple' shape, which means you should take care. Make sure you don't put on any more weight, especially if your measurements fall towards the upper end of the area.
red 'Action' area
your body shape - red area
This means you will probably have an 'apple' shape. With this body shape excess fat is stored deep below the skin in the stomach area, which will increase your risk of serious conditions such as heart disease, raised blood pressure, Type II diabetes and some types of cancer. Your health is likely to be at risk so speak to your GP about losing weight.
Most ladies in myanmar like pear-apple shape including me, fleshy tummy and big hips. I calculated my BMI and weight even though the result is acceptable, I look like fatty. I ate one plate of rice in the morning, full of plate with rich curry at lunch and dinner as well. I never missed the supper also. Sometimes I think if i m going to have everyday like this, I cannot add the year to live heathy and happy.
Frankly I couldn't do exercise because I was lazy to get up early and also did the exercise as well. The only way is i should think about my eating. I try to less the foods which have more saturated fat like milk, cake, biscuit and so on. I found one health journal, there are eight tips for eating well on daily. Let see the picture first.
1. Base your meals on starchy foods
starchy foods - rice, cereal,bread, potatoes.
2. Eat lots of fruit and veg
let try to east five portion of variety of fruit and vegetable every day.(eg. you could have:
* a glass of juice and a sliced banana with your cereal at breakfast
* a side salad at lunch
* a pear as an afternoon snack
* a portion of peas or other vegetables with your evening meal
3. Eat more fish
4. Cut down on saturated fat and sugar
you can check the food label how much fat contain in your buy food.
5. Try to eat less salt - no more than 6g a day
6. Get active and try to be a healthy weight
you should try to weight your body and check your body measurement.So that you notice and balance about your health and weight.
7. Drink plenty of water
you should drink 6 to 8 glasses of water(1.2 liters) and drink other fluid to stop getting dehydrated. As I know is people should drink minimum 1.5 liters every day.
8. Don't skip breakfast
Breakfast can help give us the energy we need to face the day, as well as some of the vitamins and minerals we need for good health.Skip breakfast is not related getting thin for people.
I chose to balance my eating style at least three or four days per week. It's not for beauty but for healthy. I would like to go gym also but I couldn't because here is bitterly expensive for gym. But I would like to do soft exercise like aerobic, jogging, walking rather than hard exercise to be a good circulatory and respiration. Up to now my weight neither increase nor decrease but I feel I'm a little lighter than before. :P "koe bar thar ar pay ya tal.."
Have a nice day..frd!! We should be smarter than yesterday...Not harder to do this..urs frd..(pretty fat win) heeeee heee
Read more...
I notify my image is getting fat day by day like a apple - pear shape, with a plumpy tummy and big hips.. :D :P heee..hee.So that I'm a golf stage among my friends - the player(guy) kick as far as they can. Kidding :P. Regarding to one health article, there are many shapes among the people as follows.
brown 'Take care' area
your body shape - brown area
This means you will probably have a tall thin 'chilli' type of shape. This isn't desirable for good health so you need to take care. You may need to gain weight.
green 'OK' area
your body shape - green area
This means you will probably have a healthy 'pear' shape, which is a healthy shape. With this type of body shape, any excess fat is stored under the skin around the bottom, hips and thighs, which is less harmful to health than having an apple shape.
amber 'Take care' areayour body shape - amber area
This means you will probably have a 'pear-apple' shape, which means you should take care. Make sure you don't put on any more weight, especially if your measurements fall towards the upper end of the area.
red 'Action' areayour body shape - red area
This means you will probably have an 'apple' shape. With this body shape excess fat is stored deep below the skin in the stomach area, which will increase your risk of serious conditions such as heart disease, raised blood pressure, Type II diabetes and some types of cancer. Your health is likely to be at risk so speak to your GP about losing weight.
Most ladies in myanmar like pear-apple shape including me, fleshy tummy and big hips. I calculated my BMI and weight even though the result is acceptable, I look like fatty. I ate one plate of rice in the morning, full of plate with rich curry at lunch and dinner as well. I never missed the supper also. Sometimes I think if i m going to have everyday like this, I cannot add the year to live heathy and happy.
Frankly I couldn't do exercise because I was lazy to get up early and also did the exercise as well. The only way is i should think about my eating. I try to less the foods which have more saturated fat like milk, cake, biscuit and so on. I found one health journal, there are eight tips for eating well on daily. Let see the picture first.
1. Base your meals on starchy foods
starchy foods - rice, cereal,bread, potatoes.
2. Eat lots of fruit and veg
let try to east five portion of variety of fruit and vegetable every day.(eg. you could have:
* a glass of juice and a sliced banana with your cereal at breakfast
* a side salad at lunch
* a pear as an afternoon snack
* a portion of peas or other vegetables with your evening meal
3. Eat more fish
4. Cut down on saturated fat and sugar
you can check the food label how much fat contain in your buy food.
5. Try to eat less salt - no more than 6g a day
6. Get active and try to be a healthy weight
you should try to weight your body and check your body measurement.So that you notice and balance about your health and weight.
7. Drink plenty of water
you should drink 6 to 8 glasses of water(1.2 liters) and drink other fluid to stop getting dehydrated. As I know is people should drink minimum 1.5 liters every day.
8. Don't skip breakfast
Breakfast can help give us the energy we need to face the day, as well as some of the vitamins and minerals we need for good health.Skip breakfast is not related getting thin for people.
I chose to balance my eating style at least three or four days per week. It's not for beauty but for healthy. I would like to go gym also but I couldn't because here is bitterly expensive for gym. But I would like to do soft exercise like aerobic, jogging, walking rather than hard exercise to be a good circulatory and respiration. Up to now my weight neither increase nor decrease but I feel I'm a little lighter than before. :P "koe bar thar ar pay ya tal.."
Have a nice day..frd!! We should be smarter than yesterday...Not harder to do this..urs frd..(pretty fat win) heeeee heee
Read more...
Wednesday, October 31, 2007
BusinessObjects XI
Just now I'm playing with BusinessObjects XI(BO) to design the reports for customers demand. As for me, I'm more familiar with Crystal report than BO, a new era in IT to design the report to meet with customer requirements like crystal. I would like to mention(copy & paste) a few about BO. :P
BusinessObjects XI Release 2 is a complete suite of performance management, information management, reporting, and query and analysis software. It is consistently recognized as the industry’s leading business intelligence platform and enables companies to answer critical questions and share trusted insight across their organization. For additional information on BusinessObjects XI Release 2.
The key issued of using BO is that can create an environment where the users not required to know technically to view and retrieve the data for business decision and performance management.
I couldn't use not all BO tools from BO XI but designer and intelligence tools only. In BO designer, you need one dsn for DB connection to create the Universe which is the new interesting things in BO to make the relationship, joins & context between the tables. The BO intelligence tools seems like Crystal Report designer which can design the report with database fields and then can create the formula also. The main advantages is that can auto generate SQL and filter also.
I'm not very skillful in BO and just shared my experiences with new era. I think if you would like to play with BO, you will have some difficulties as it's lack of samples, source codes and information.
Read more...
BusinessObjects XI Release 2 is a complete suite of performance management, information management, reporting, and query and analysis software. It is consistently recognized as the industry’s leading business intelligence platform and enables companies to answer critical questions and share trusted insight across their organization. For additional information on BusinessObjects XI Release 2.
The key issued of using BO is that can create an environment where the users not required to know technically to view and retrieve the data for business decision and performance management.
I couldn't use not all BO tools from BO XI but designer and intelligence tools only. In BO designer, you need one dsn for DB connection to create the Universe which is the new interesting things in BO to make the relationship, joins & context between the tables. The BO intelligence tools seems like Crystal Report designer which can design the report with database fields and then can create the formula also. The main advantages is that can auto generate SQL and filter also.
I'm not very skillful in BO and just shared my experiences with new era. I think if you would like to play with BO, you will have some difficulties as it's lack of samples, source codes and information.
Read more...
Subscribe to:
Posts (Atom)