Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Thursday, 21 September 2017

Creating table in SQL Server

In this article, we have prepared queries to design database and table.



We have designed this table as per our need to create SSRS report.

--Creating database
create database MySchoolDB

--Using database
use MySchoolDB
Go

--Creating table
create table tblTeacher
(
TeacherCode int identity(1,1) primary key,
TeacherName varchar(50),
Address varchar(50),
City varchar(50),
State varchar(50),
Pincode varchar(6),
Designation varchar(50),
DOB varchar(10),
AdditionalInformation varchar(300),
Salary money,
CurrDate varchar(10),
Remarks varchar(100)
)

--Inserting records in table
insert into tblTeacher(TeacherName,Address,City,State,Pincode,Designation,
DOB,AdditionalInformation,Salary,CurrDate,Remarks)
values('Vijay Singh','Sector-100, H.No-1000, ABC Society, XYZ Nagar','Nirman Vihar',
'Delhi','100000','Head PE Coach','21-09-1979',
'Vijay Singh holds a BPE in Physical Education from Delhi University. He was assigned this job in 2003 as Assistant PE Coach.',
70000.00,'21-09-2017','This is system generated report.')

--Retrieving records from table
select * from tblTeacher



Use above records in our following SSRS Reporting article series.


For any query, comment us below.



Click imagination hunt to read latest blogs.



Keep learning and sharing...
Read More »

Monday, 18 September 2017

Soaked Chickpea (Chana) are the new beneficial to eat apart from almond.

Soaked Almonds? Remember your mom asking you to eat soaked almonds every day in the morning.

Soaked Chickpea (Chana) are the new beneficial to eat apart from almond. Chickpeas are both high in protein and fiber with starch elements; thus making you feel full and curb your heart’s desire for junk food and unhealthy sugar cravings.



Chickpeas are full of nutrition; it is full of high levels of vitamin B, phosphorus, folate, zinc, and iron; all of which are important if you are a vegetarian or a vegan and not missing out on the nutrients and protein.



Chickpeas can also be great evening snack or a running breakfast for those with a fast-paced life. You can combine chickpeas with a little of black pepper and salt, also add some tomato and onion to put some added flavor to the much-needed protein.
Read More »

Friday, 15 September 2017

Gifts Section: Period edition | Gifts For Women on Their Period

Are you a guy with less than a dime’s clue as why is it good to gift something to your girlfriend, wife or your mother when they are on their period.



Have you been in the problem for a small mistake during her period? Is she calling and not talking to because of the smallest mistake you did while she is on her period.

Fear not mate, let us help you in this section of “Gift section”

1.Chocolates: Every girl on their periods love some sugar and gifting her the favorite chocolate with some added donuts and a hot coffee will brighten up her mood and will win u a cute smile and some more level of trust. Sugar also boosts mood in general, just like a run; it boosts the level of happy hormones in the body.

2.Perfume: Buy her the special fragrance which just hit the market, because who doesn’t love a perfect fragrance around themselves. The power of smell is high psychological wise due to the fear of smelling bad during the period.



3.Punch Bag: Girls scream in pain, an upheaval of emotions and always have the urge to hit something or someone, trust us, if given a chance every girl will punch because of the pain. Be a bit innovative and set up a punching place dedicated her during her period to ease her pain, emotions and putting her at peace.
Read More »

Thursday, 14 September 2017

Best Ways to Relieve Period Cramps | Menstrual Pain

Managing Pain: Period. Have you started to live comfortable in that bubble for 5 days of the month?
Are you feeling blue and want to stay hidden those few days?
Do you have constant pain where you want to cry or hit someone?



Let us help you with some tips to tackle the pain

1. Massage your tummy and mostly your back to help the flow of muscles and blood is in a smooth
way, clearing all the obstruction.

2. Have ajwain with warm water to ease the pain.

3. Drink ample amount of water for bloating and easement of the flow through your body.

4. Though many people ask to have hot things while on periods, avoid coffee as it adds to the
cramp pain.

5. Try covering up your feet and legs, it keeps your body a bit hot.



6. Keeping your body temperature a bit hot, you can use hot water bottle with putting it on your
tummy, back.

7. Do a bit of stretching or some yoga for not putting your body in stiffness.
Read More »

Tuesday, 12 September 2017

Pipe and Cistern Short trick | Part 2




Read More »

Saturday, 9 September 2017

Pipe and Cistern Short trick | Part 1

Read More »

Thursday, 7 September 2017

Free Discount Coupons code: Cashback, Offers and Promo code


Flight Booking Coupons/Offers save large using our flight coupons



MobiKwik Coupons/Offers



Nearbuy Offers/Coupons


Pizza Hut Offers/Coupons


Read More »

IBPS Examination for Clerical Cadre Across India I Last Date to apply: 03 Oct 2017

IBPS Clerical Notification 2017- Apply Now

Date of Posting:07/09/2017

Company Name and Type: IBPS has given notification for recruitment of clerical cadre job.

Nature of Job: Bank job


Last date of submission: 03-10- 2017

Hiring Process: Selection will be made by online written test

No. of Vacancy: not mention yet

Qualification
: Any Graduate




Age limit
: Minimum 20 Year and Maximum 28 Year

Application Fees: For General Candidate- Rs. 600

                               For SC/ST/PWD Candidate –Rs. 100

                               For OBC Candidate-Rs. 600

How to ApplyClick on link to apply online

All the Interested candidates who fulfill the above eligibility criteria may Apply Online by visiting the website during 12-09- 2017 to 03-10- 2017 and no other mode of application will be accepted.

Website: www.ibps.in

Notification: Click Here

Start date for Online Registration: 12-09- 2017 to 03-10-2017

Last Date of Payment Application fees: 30-06- 2016

Download Pre Examination call letter: November 2017




Online Pre Examination date: 02-12-2017,03-12-2017,09-12-2017 & 10-12-2017

Online Main Examination date: 21-01-2018

Provisional Allotment: April 2017




For any query, comment us below or read the full advertisement.



Keep learning and sharing...
Read More »

Monday, 4 September 2017

Love to see your skin glow with radiance? I Love when people compliment you?

Love when you can’t stop looking at yourself in the mirror?

We want you to glow more than ever this summer. And we are here to make this possible through some healthy and tasty diet changes.


1. Berries: Strawberry, blackberry, blueberries are all beneficial for your health and skin with an additional low sugar count. They are high in vitamin C, helping you glow and maintain the elasticity of your skin. U can find frozen berries in India and can make some yummy and healthy smoothie for your appetite cravings.

2. Avocados: They are rich in vitamin E and acts as a fat soluble. If you cannot find avocado as a whole, u can have bottled juice instead.


3. Walnuts: Walnuts are high in Vitamin B and helps in anxiety, stress management, mood control and prevents skin disorder. It also contains elegiac acid which help the body in fighting against cancer.
Read More »

Thursday, 24 August 2017

Going through the relationship with a phase of fights? Need Solution

Are the fights still continuing over a year?

Do you love the person but fight every time you try to talk?


With getting in touch with anyone on this planet getting easier day by day; working hard to keep that special is getting harder day by day. You must be wondering throughout your day that I love this person and everything but the moment you two get together you feel that you stopped connecting. Let us discuss, two of the main reasons of feeling out of love, when with them:

1. Reality v/s illustration: People always have a tendency to image things rather than acting on the present situation. It happens same when people start to imagine their relationship, be it being influenced by movies, other couples, news or any imagination in your head. Stop for a second and let the person give you something rather than imagining and to give a break, many people need to stop giving scenarios to their better half just to test them and their love after years into
the relationship.


2. Trust: There is a difference between people being possessive and having trust issues. Possessive is being adorable that you are a little jealous of someone eyeing your loved one. And being jealous, not trusting because you have a weird feeling because they make new friends and the new friend tends to become more interactive in nature.

Comment your queries.
Read More »

Wednesday, 23 August 2017

Sarahah: A popular app that allows you to share ‘honest’ feedback anonymously

"Sarahah" means 'Honesty' and the purpose of this app is to Improve your friendship by devising your strengths and areas for improvement. Comment your friend's positive
 honest feedbacks.



So Below mentioning some of the factors that are needed to understand. Some factors also start creating the problem for users.

1) Not all the Sarahah messages/feedbacks are "Practical/constructive".

2) Psychologically unhealthy for the young generation.

3) Spreading hatred and inciting social crime is easy.

This blog is not to warn you against using this app. We will not say that the app is not good to use, but we have to be wise about how we use it in a positive manner. As said Technology, if used positively can result in the creation of new phase but when misused can lead to a path of destruction.
Read More »

Tuesday, 1 August 2017

Are you having ample sleep and still see those dark under eyes?

Are you sick of seeing yourself with those deep, dark under eyes?
Not to fret, we will help you with some tips to vanish the under eye and have that baby eyes with
sparkling eyes.



1. Eye Pads: you can easily see eye pads on various online stores to soothe your eyes and give them a
refreshing look. If you don’t trust the eye pads, we can DIY them at home itself. Soak a cotton ball in
rose water or cold milk as an eye pad. Keep the cotton balls for 15 minutes and wash your face
gently. For better results do it twice a day.



2. Oil massage: Massage is the best to relax and rejuvenate your body in the best possible way. You
can use coconut oil which is found mostly in our households. The oil is full of nutrients and
nourishes the under eye skin which will help you to vanish the darkness.
Read More »

Thursday, 27 July 2017

Types of SQL Server Joins


Continuting with the previous article. Let’s discuss the last and final step to understand every type of join.

Step-4: Last step, performing different types of joins.

Let’s check out every join one by one.

Inner Join/Join: Starting with “inner join” or simply “join” keyword which give only the matched rows specified in the ON condition. Our result set would look like this:

--Using join
select P.PassengerId as PassengerId,P.PassengerName as PassengerName,
F.FlightName as FlightName,F.FlightCode as FlightCode
from tblPassengers P join tblFlight F
on P.FlightId = F.FlightId
 
Join by imagination hunt blogs
Join


--Using Inner Join
select P.PassengerId as PassengerId,P.PassengerName as PassengerName,
F.FlightName as FlightName,F.FlightCode as FlightCode
from tblPassengers P inner join tblFlight F
on P.FlightId = F.FlightId
 
Inner Join by imagination hunt blogs
Inner Join


Left Join/ Left Outer Join: Next, “left outer join” or simply “left join” keyword which give all rows from LEFT table and only matched rows from other table specified in the ON condition. Unmatched columns cell are replaced with NULL. Our result set would look like this:

--Using Left Outer Join
select P.PassengerId as PassengerId,P.PassengerName as PassengerName,
F.FlightName as FlightName,F.FlightCode as FlightCode
from tblPassengers P left outer join tblFlight F
on P.FlightId = F.FlightId
 
Left Outer Join by imagination hunt blogs
Left Outer Join


--Using Left Join
select P.PassengerId as PassengerId,P.PassengerName as PassengerName,
F.FlightName as FlightName,F.FlightCode as FlightCode
from tblPassengers P left join tblFlight F
on P.FlightId = F.FlightId
 
Left Join by imagination hunt blogs
Left Join


Right Outer Join/ Right Join: Next, “right outer join” or simply “right join” which give all rows from RIGHT table and only matched rows from other table specified in the ON condition. Unmatched columns cell are replaced with NULL. Our result set would look like this:

--Using Right Outer Join
select P.PassengerId as PassengerId,P.PassengerName as PassengerName,
F.FlightName as FlightName,F.FlightCode as FlightCode
from tblPassengers P right outer join tblFlight F
on P.FlightId = F.FlightId
 
Right Outer Join by imagination hunt blogs
Right Outer Join


--Using Right Join
select P.PassengerId as PassengerId,P.PassengerName as PassengerName,
F.FlightName as FlightName,F.FlightCode as FlightCode
from tblPassengers P right join tblFlight F
on P.FlightId = F.FlightId
 
Right Join by imagination hunt blogs
Right Join


Full Outer Join: Next, “full outer join” gives all records from LEFT and RIGHT table specified in the ON condition. Unmatched columns cell are replaced with NULL. Our result set would look like this:

--Using Full Outer Join
select P.PassengerId as PassengerId,P.PassengerName as PassengerName,
F.FlightName as FlightName,F.FlightCode as FlightCode
from tblPassengers P full outer join tblFlight F
on P.FlightId = F.FlightId
 
Full Outer Join by imagination hunt blogs
Full Outer Join


Cross Join: At last, “cross join” gives the cross product of two table. Here, it is not reqiuired to specify the ON condition. Our result set would look like this:

--Using Cross Join
select P.PassengerId as PassengerId,P.PassengerName as PassengerName,
F.FlightName as FlightName,F.FlightCode as FlightCode
from tblPassengers P cross join tblFlight F
 
Cross Join by imagination hunt blogs
Cross Join


For any query, comment us below.

Previous – Types of SQL Server Joins #1


Click imagination hunt to read latest blogs.


Keep learning and sharing...
Read More »

Featured post

Think that makes you rich and richer

 Napolean said: “You can think and grow rich, but if you can be brought up like most people with work and you won't starve, this wil...