text:
- HubPages»
- Fashion and Beauty»
- Jewelry
Unique Silver Accessories - Troll Bead Collectibles - Trollbeads
One-of-a-kind, personalized silver bracelets...
Silver is perhaps one of the most versatile of the precious metals. Fashioned into rings, bracelets, necklaces, and earrings, sterling is easily worked into intricate and delicate creations. Its subtle luster compliments almost any gemstone or any outfit.
My mother had several charm bracelets in silver and one in gold. Young ladies of my generation, once they reached a suitable age, were often gifted with silver charms on their birthdays or at Christmas to "build" their bracelets. My sisters and I each dutifully collected charms for years. Mine sat in my jewelry box most of the time, too fancy to be worn every day.
As well, the musical tinkle of the tiny, delicate charms, so perfect on my mother's arm, nearly drove me to distraction on my own. I have always liked the idea of collecting unique "somethings" on a silver bracelet - just so long as the "somethings" would be quiet.
Troll Beads Bracelets from trollbeadbracelets.comClick thumbnail to view full-size
Sterling Silver Bracelet Chain
Unique, collectible beads...
About two years ago, I discovered Trollbeads, and have been collecting them ever since, slowly building my first bracelet. In the process, I have learned several things about these delightful new collectibles.
Combining sterling silver with an amazingly varied and beautifully unique array of glass beads and semi-precious stones, the unique designs of the gifted Trollbeads artisans will please the most discerning eye for collectible silver accessories.
Each Trollbead bracelet collection begins with the delicate yet strong, woven sterling silver chain on which the beads will be strung. So smooth and supple it is a delight to wear on its own, the chain provides a smooth base on which the beads slide with never a hitch.
Sterling Silver Clasps
Delightful variety...
The clasps come in a wide variety of styles, from plain to intricate filigree.
You can choose from among several styles of filigree or florals to a crystal accented clasp.
For a bit more, you can have a clasp shaped as a Teddy bear, an elephant, or a fish.
I have opted for a basic catch, but I do rather like the silver fish.
Once I have completed my bracelet, I will see which clasp will suit it best.
I am also considering a second bracelet with just the plain chain and a fancy clasp.
Created in Denmark, these delightful beads and accessories are now available from licensed dealers in Canda and the United States.
My collection so far...
Every bead has a name...
When I purchased my first hand-blown glass bead, I discovered that each bead has a name and a story attached to it.
Some of the names are based on mythology, some are derived from well-known fairy and folk tales,
Though many are created for each name, every single bead is a unique expression of the glass blowers art.
My first two beads were Red China and Green Rainbow. The lady at the jewelry store shared each bead's unique origin and story.
Red China, with its base of deep red, accented by a swirling melange of electric blues and greens all shot through with touches of gold and pure white, was inspired by the beautiful, traditional, red, Chinese lacquer ware.
Green Rainbow is reminiscent of the woodlands. When the fog billows over the forest and the elves dance on gallows hill, you may see the green rainbow glowing in the sky over the land of the trolls.
Alabaster, an amber bead so named for its light color, is like an ancient alabaster statue bathed in the golden light of a Mediterranean afternoon.
Next came Silver Mountain and Golden Cave, whose creator, glass artist Anders Martin Bruun, likened them to an Aladdin's cave of delights.
Each bead created to be Black Flower Mosaic has its own character.
Each one is a separate piece of an exquisite Persian
flower mosaic cast in black with a shiny shadow of dichroic glass embedded at intervals around the bead.
Orange Steel, the newest bead in my collection, contains gossamer-fine stainless steel threads within the golden glass core for a completely unique effect.
The silver beads...
Not just spacer beads...
Each of the silver beads is beautifully crafted as well. My first silver bead was the elephant, the centerpiece of the bracelet.
I first thought to find plain silver spacers to use between each bead or pair of beads - the plainer, the better, so as to not distract from the beads.
Each of the silver beads, though, is quite as lovely as their glass counterparts.
In the end, I decided to just look for beads that complemented the rest of the collection, and have been very pleased with the effect.
I now have my elephant, a lovely Forget-Me-Not cluster, a twisted knot, and an adorable ladybug - and not a plain silver spacer in the lot.
An Indian elephant carrying a tented seat on its back called a howdah. The venerable Asian elephant is still used for transport and processions all over India, and is highly respected in many eastern religions.
In Denmark the bright red Ladybug is said to bring good luck. Little children send them on their way with a gentle puff of breath, singing, "Mary Mary Ladybug, fly to the Lord above and ask for sunshine tomorrow."
The rhyme I learned as a child, the old English version, was a bit more urgent and dramatic: "Ladybug, ladybug, fly away home. Your house is on fire; your children alone."
The Forget-Me-Not is like a promise and a romantic memory of the beauty of spring, while the Lucky Knot, a variation on the Lover's Knot, symbolizes the cord that binds lovers together, knotted so that the love, or, in this case, the luck, cannot ever run out.
- Trollbeads Jewelry and Trollbeads Charms!
We custom design a fabulous line of contemporary awareness and mother's jewelry using sterling silver and 14 karat gold, combined with semi-precious and precious stones.
- Trollbeads Silver Gold Trollbeads Glass Stone Trollbead Bracelets Necklaces Trollbeads
Trollbeads one of a kind trollbeads jewelry. Mythology troll beads, astrology troll beads, fairy tales, fauna troll beads, flora troll beads, cultural diversity troll beads
- Trollbeads, official site for Canada
We invite you to explore the Trollbeads collection and read the stories behind the beads ... Trollbeads is proudly distributed in Canada by The Trendy Group ...
- FireGoddess Lampwork Beads & Jewelry
The Fire Goddess is Susan Barnes. She creates stunning, handmade lampwork beads, pewter jewelry, and embellishments, and has one of the widest selections of glass beads, lampworked pendants and sculpted glass buttons by any artist in the world.
- Pati Walton Lampwork Beads Murrine
These are handmade, one-of-a-kind pieces, no two are ever exactly alike. .... The Aquarium Bead. In this new video, Pati shares a wide variety of special ...
- Lampwork Beads Handmade by Artist Ellen Dooley
lampwork beads, lampwork, glass beads, handmade, glass, art glass, torchwork, flowers, blossoms, flower, pink, ruby, artist, kiln, annealed, artisan, bead maker, jewelry, handcrafted, bracelet, bangle
Also from Denmark, and available in North America from authorized dealers - Pandora's Box Beads
- Posh - Largest Pandora Jewelry Retailer in Canada
At Posh we offer the largest selection in Canada of Danish designed Pandora Charms, Bracelets and more
- Pandora Jewelry, Pandora Beads, Pandora Bracelets, Pandora Charms, Bead Bracelets.
Free Shipping on all orders! Authorized Pandora Gold Retailer - Offering hundreds of Pandora beads for your Pandora bead bracelet.
- Pandora Jewelry Charms at Chains-and-Charms.com
This trendy line of Danish jewelry combines versatility and a unique thread design to reflect each woman's style, mood, and personality
My kind of charm bracelet...
Though it is possible to purchase lovely bracelets like the ones pictured at the start of this article, I much prefer to select my own beads as I go along. It is such fun to pore over the display, trying to pick exactly the right bead to complement the rest of the collection, and I like the idea that my bracelet will be unlike any other.
As well, I find my tastes change as I go along. Different beads catch my eye from the ones that jumped out some months before. It is fun to compare the silver beads as well - to see which new silver bead will add just the right touch between the sparkling glass additions.
I must be part Whiskey Jack. Also known as Camp Robbers because of their attraction to shiny things, they will often leave a small stone or a leaf in place of the keys, bottle caps or metal trinket they take. I find though that, unlike the Whiskey Jack, I must exchange cash for my shiny baubles. Ah, well, such is life.
© 2010 RedElf
Red Elf, I definitely enjoyed your hub. I started collecting Trollbeads only in he last 2 months and absolutely love them. I have a full bracelet with all summer colors and am buying other beads as I see them and like tomswitchnout and off when I feel like. I also collect Pandora and have 2 full bracelets there too. Must so much fun.
Awesome Hub and very detailed about Trollbeads. I too collect Trollbeads and have written several Hubs on this topic. I absolutely love Trollbeads and your article really is very educational on this topic.
Great information about these bracelets that are so popular right now!
On the bracelets I'm making my friends are pretty simple, and I'm using the stretchy string so I make sure they fit. I've gathered a few things I made, but one of the purses I made I cannot find, it has antique crystal beads I can't find and it's driving me bonkers! I'm sure it (like a ring I have) I've put in a "safe place" and forgot which "safe place" it is lol. :) Thanks for the idea.. :)
Oh my uh.. I think I got instructions off the net, but some of it I just winged it on! lol But I'm making two bracelets right now, me and two friends are doing a round robin (but nobody else would join) But yeah I'll gather my things tonight! :)
I could write a book on beading! lol but I won't here! :) But I should get my camera out and start making a hub of some things I've made including beaded purses! I have 3 boxes, and 2 large "party tray" dishes with 4 projects going on them! I have one rule, not a plastic bead to my collection :) and silver is a MUST. I love the fish clasp!
Good hub, i like silver jewelry the most aswell!
I have seen these before. There are some great looking beads as well as some fun ones you can add on.
Tres elegant! Lovely collection RedElf - must be fun to create such beautiful bracelets.
I never heard of Troll beads before this hub--how very, very cool. I love the elephant silver spacer. Great stuff, as usual, Red Elf. Thanks!
Thanks Redelf! Are these the same as the Pandora bracelets that are all the rage on this side of the pond? They're beautiful. And I'd no idea they'd such a provenance.
Fascinating! I had seen the bracelets but now I have a greater appreciation. Very nicely done - super pictures and explanations and layout. You set the bar high! Keep up the great work.
A subject I nevr knew anything about it. Thank you for bringing to our attention. I enjoyed reading about it.


text:
Love the Chaise, what a difference!
Everyday I come in here and find something cool, your blog never disappoints!
Thanks for always providing inspiration!
Kat 🙂
The difference is like night and day – this deserves an award!
Nice upgrade! But I must know where you got that quilt on the bed…it's gorgeous! Can we see more? 🙂
I love it! I have the same style chaise and had a slipcover made for it … except this one shown here is more like what I wanted. My seamstress gave me a more modern-looking slipcover. But I'm so happy to see that what I really wanted CAN be done!!
That really does coordinate well with the rest of the room now.
Love it!!!
Copyright © 2017 Better After · Blogger to WordPress Migration by Linauer Designs · Log in
More Better After to love on Instagram!

subset: commoncrawl


text:
Sign Up for aResearch Consultation
Research &Course Guides
Page a Book
Course Reserves
Software at the Library
Explore Library Events
Support the Library
or browse databases: A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #
Actually, there is none. Hoya is a large genus of tropical plants in the Asclepiad family, native to Southeast Asia and Australia. The genus is named for Thomas Hoy, an 18th century English botanist who worked as the head gardener for the Duke of Northumberland.


text:
Status: Closed
Know more about this business than we do? Cool! Please submit any corrections or missing details you may have.Help us make it right
Be the first MLive.com user to add photos or videos of U-Tan
5 star
I LOVE this place! They are extremely clean and have wonderful service; Its very Inexpensive and I get the most for my money with out a doubt. I plan on getting a spray tan this week and I know I wont be let down!
University Tan U Tan is located at 5601 W Main St, Kalamazoo, MI. This business specializes in Tanning Salons and has 2 review(s) with a star rating of 4.5.
Home of the $4 tan!
check us out at www.UTanKalamazoo.com


text:
Know more about this business than we do? Cool! Please submit any corrections or missing details you may have.Help us make it right
107120attr:9 holerestaurant
Summer Breeze Golf: 9 Hole, Par 3 Course - Fremont Lanes w/Pro Shop & Restaurant - Beer Wine Liquor
Be the first MLive.com user to add photos or videos of Fremont Lanes & Summer Breeze Golf Course
Great Place
My husband bowls here with a few friends every Thursday,the food is good and priced average,and the service is great,but as far as it being for family they have a room that has arcade games in it,not really...
9 Number of Holes, 27 Par, 1148 Front Tee Yardage, 1148 Back Tee Yardage, Lampkin Grips


text:
~ 25th March Daily Challenge ~
View Single Post
March 24th, 2013, 01:44 PM
Fly away on my zephyr
Join Date: Feb 2006
Location: Manchester, UK
Posts: 66,539
Out for the day tomorrow, so I'm posting this challenge early.
For this challenge you will earn your team 2 points by making a get to know you thread on the DDC starting with one of the following question words - Who, Why, When, Where, What, How or Which?
Your thread can have one question or several in it, it's up to you. You must post the link or name of your thread in THIS post in order to get your 2 points. This must be done by the end of Monday 25th March.
I shall post the bonus November trivia sometime in the evening GMT so be on the lookout because only the first 3 to find & answer it will get points!!
View Public Profile
Visit Carwen*Angel's homepage!
Find all posts by Carwen*Angel


text:
What is Decoded Fashion?
We believe that technology is a key driver of creativity, innovation and customer engagement, and that the businesses that successfully manage to integrate technology across their operations will flourish in today's always-on, 24/7 world. We do this by connecting the world's leading fashion brands with emerging technologies, and by helping them discover top startups, new talent and business opportunities from around the globe.
Since 2012, Decoded Fashion events and competitions have been pushing brands to experiment. We bring our fashion and tech community together regularly throughout the year, hosting strategy summits in the US, Europe and Japan, as well as informal networking events – our DF Meetups – in 17 countries. We also produce white-labelled innovative events for the world's top brands, as well as 'pop-up' forums produced jointly with top festivals such as SXSW.
When is the Decoded Fashion Milan Summit?
Decoded Fashion Milan Summit 2017 is taking place on November 14-15.
Where can I get tickets, and will they be sent out to me by post?
Tickets can be booked through Eventbrite here. Our primary payment method is PayPal, however there are other options available e.g. invoice, BACS and credit/debit card by phone. All of our events are e-ticketed, so your ticket will be emailed to you automatically after you purchase. Please email email@example.com if you'd prefer a different payment method or if you experience any problems booking tickets.
Does Decoded Fashion accommodate attendees with special needs?
We are committed to making our events accessible to all individuals. Should you require any information or assistance prior to your arrival, please email us.


text:
Find out more information
Register or log on to view your bills online
Give us a call on
Find our more information
Find out more about how you can save water and save money.
That's why we have a dedicated team to help you save water and save money.
Changes for Large Business Customers
We treat all customers of our water and sewerage services fairly, whether their Retail service is provided by Welsh Water (via the Commercial Retail Team) or a third party Retailer. For more information please see our Compliance Code.
If you are a business customer, for more information please visit our business customer page.
For more information about the new market, eligibility criteria and advice about switching please visit www.open-water.org.uk.
We own and maintain all the pipes that bring clean water to you and take away your dirty water. Other water retailers can purchase water from our 'wholesale' business to sell on to their large customers. Our wholesale charges document (see below) explains how we charge for this service. Similarly, other companies with access to water resources are able to apply to transport water through our network to supply large customers. For more detail, see our Network Access Code, and Access Prices documents below. If you are a Retailer for a business customer in Welsh Water's area of operation and have a Wholesale service request, or are a Retailer who wants to enter a Wholesale Contract for Wholesale Services with Welsh Water or for other enquiries about accessing our network, please contact our Wholesale Service Centre:
Dŵr Cymru Welsh Water
Wholesale Service Centre
PO Box 3164
0800 260 5053 (24 hours)
Wholesale charges 2018-19
Wholesale charges 2017-18
Water trading documents
Hi, I'm Rita
We're finding an answer to your question
We're really sorry but we cannot deal with your request at the moment. Please check back and try again in a few minutes. We're sorry for any inconvenience this may have caused.
There are several questions that might be relevant to you, these are:
Sorry, we're not quite sure what you're asking .. please rephrase the question.
Alternatively, pick from some of our most popular FAQ's
Was this answer helpful?


text:
New York City really is one of my favorite places on earth. One day, I will live there. Hopefully that time will come next summer, after graduation, but we shall see.
Here are some photos from our day in the city. We mostly wandered around in Central Park for hours. We had our luggage with us and were dragging it around, so it was a pleasant way to spend the day. The last two photos are from Strawberry Fields.


text:
Cafe Bar
Whether it's for a sit down lunch with
friends, a takeaway snack, a full
graduation dinner or a birthday
celebration, everyone can enjoy the
atmosphere and exceptional
service at the Byre's Bar and Restaurant.
Throughout the day we serve a wide selection of food and beverages: from coffees to
cocktails; savoury snacks to sweet treats, there is something for every taste imaginable.
We can also cater for special dietary requirements (please contact us in advance to ensure
we can offer you a range of suitable menu choices). Have a look at our regularly updated
menus to browse through what we will have on offer.
The Bar is the perfect place for any social occasion and we host weekly bar events.
On Thursday evenings why not come along to our Jazz Club to hear local performers
showcase their talent? Starting at 9:30pm, this is the perfect opportunity to unwind
while sampling our extensive range of spirits, wine, cocktails and local beer.
Private Bookings
We are also able to cater for customers who wish to use our private hire service. We can seat up to 50 guests in our main restaurant area or cater for up to 200 guests with buffet style refreshments hosted in one of the Byre's spacious foyer areas. Our foyer spaces are modern and help to generate a special atmosphere for every occasion. These spaces are ideal for entertaining and mingling with your guests.
To book the restaurant, foyer or a more private studio space for your catered event or function, please call 01334 468807 or email our restaurant team: email@example.com
Bar & Restaurant Opening Hours
Monday: 10am – 9pm
Tuesday: 10am – 9pm
Wednesday: 10am – Late
Thursday: 10am – Late
(Live Jazz in the Bar from 9.30pm)
Saturday: 10am – Late
Sunday: 11am – 5pm
(Closing time – Show dependant )
Food Served
Monday – Saturday: 10am – 3pm
Sunday: 12 – 4pm
Pre-Theatre Meals: 5pm – show starts
Whether you are heading to a musical or a play in the lively Theatreland, the Byre Theatre restaurant offers a huge variety of lunches and pre theatre meals to suit any budget. Book in advance!
We also cater for group bookings and are a perfect setting for special occasions, for groups of 16 or more please contact us on 01334 46 8807 or E-mail firstname.lastname@example.com


text:
MOVIE SYNOPSIS [ General Audiences ] With production of USA, this 2014 film was directed by Mark Wojahn. You can watch Liz Miller online on TV cable or theaters with original audio in English at different dates. This film premiered in theaters in 2014.
Rating: 5 by 10 users./
Runtime: 6 minutes
Liz Miller.
Short film, Biographic.
6-minute film (full movie) directed by Mark Wojahn.
The original audio of Liz Miller has dialogues in Dolby Digital, it was produced in USA.
It premiered in cinemas or television in 2014.
Screenplay written by Mark Wojahn.
Mark Wojahn.
Mark Wojahn and Ace Allgood.
Composed by Richard Werbowenko.
Without commercial breaks, the full movie Liz Miller has a duration of 6 minutes; the official trailer can be watched in streaming on the Internet. You can watch this full movie free in EnglishDolby Digital in movie TV channels, renting the DVD or with VoD services (Video On Demand player, Hulu) and PPV (Pay Per View, Netflix).
See the page of this full movie, Liz Miller in FULLTV Movies.


text:
Combine the roasted pepper, onion, tomatoes, broth, cilantro, garlic, oregano, cumin, smoked paprika, and chipotle puree (if using) in a blender or food processor and puree until smooth.
Transfer the mixture to a skillet and simmer, stirring, for 3 minutes, or until the vegetables are softened and the mixture is fragrant.
Season with salt and black pepper. Use immediately or refrigerate for 3 or 4 days.
Get the Recipe for Huevos Sofrito here!
Featured in Cheryl Foberg's cookbook [Flavor First!][1] Courtesy of Cheryl Foberg, RD.


text:
Home :: Men's Diamond Jewelry :: Men's Diamond Rings :: Men's Diamond Ring
14K White Gold
0.14 cts.
MSD-182 :: Ask a Question
Product Selection
Thank You.
Thank you so much for all of your help. My husband's ring arrived a day before the wedding so we were happy. I was able to make a beautiful ring using the...
A Lot Of Love....
For Jonathon and everyone at Joshua's. We love our bands. I could not have asked for a better group of fine individuals to work with. You have given us a...
Matching Wedding Sets
Writing to inform you that I am MORE than pleased with the workmanship and quality of my order. You even called me to keep me up-to-date and made sure my...
Recently Viewed
Copyright © 2017 Joshua's Jewelry. Powered by WSC Cart


text:
Share via Email
The Hub
Editorial Staff • Edinburgh • 15 Aug 2010
WOS Rating:
The laughs come thick and fast, both from the general camaraderie and the pithy one-liners of the voiceover announcements. The ensemble, which also features Matt Green and Petra Massey as the workmates from hell, is wonderful, and the stressful working environment they portray translates into infectious joy among the audience. The vast number of people smiling as they left the auditorium left me in no doubt that The Hub is a delightful miniature gem at this year's festival.
- Miranda Fay Thomas
Share via Email
Want more stories like these?
No thanks, don't show this popup again.


text:
Know your catalogue codes?Quick Shop
June 2015 Newsletter
It's the peak time of year to be out in your gardens; the days are at their longest and everything is growing so fast. Be sure to keep plants well fed as well as well-watered. Your lawns will appreciate a high-nitrogen feed to encourage green growth and hungry plants like roses and clematis will really appreciate a general fertiliser feed.
This month BBC Gardeners' World Live, featuring RHS Flower Show Birmingham opens to the public 11-14 June, a show with so much on offer for gardeners, cooks and 'outdoorers' in general. We'll be there to see what's on, so be sure you will be too.
Enjoy the summer.
Patrick Wiltshire
Top jobs for June
Plant summer hanging baskets
You might be thinking about summer barbacues and entertaining guests. If you're opening up your well-tended garden, raise a few eyebrows with a haven of hanging baskets. Nothing like adding a dazzling display of colour and texture with patio bedding plants.
For hanging baskets you can go for instant colour like our Pre-Planted Sizzle Pink Basket for visual impact. Or create your own with colours to suit you- mix and match some of your favourite bedding plants.
When creating hanging baskets add sphagnum moss for a great spongy liner that retains moisture naturally and holds soil well. Plant in the sides of containers if possible as well as on top to create a lush cascade of flowers.
Add water-retaining gel to hold water and fertiliser to provide flowers with a good feed. For easy access to baskets, take advantage of a pulley system where you can easily and effortlessly bring down and raise up the basket.
Why not try a hanging basket of herbs? You can achieve a range of leaf and flower textures and bring the natural scent of herbs to head height.
Rid the lawn of dandelions and other broad-leaf weeds
It's so annoying to have your otherwise perfectly green lawn ruined by nuisance dandelions, and they seed so readily that the problem just gets worse and worse.
Nip the problem in the bud and apply Resolva Lawn Weedkiller. Its formula selectively kills plants with leaves rather than blades, so your grass is unaffected while the dandelions and other lawn weeds perish.
Apply the weedkiller on a clear day and a day that is forecast to be dry. Rain will dilute the chemical and reapplication may be needed. Similarly, avoid windy days. If wind blows the active chemicals onto flower beds, your prize plants may suffer.
Wear protective gloves and apply at the rate suggested on the packet. Follow these instructions and once again, you'll achieve an unblemished and lush lawn.
Prune back spring flowering shrubs
You'll notice that certain shrubs in your garden put up a lovely show of flowers in spring and now it's June, the flowers have faded and wilted.
Make sure the flowers come back next spring bigger and better by pruning shrubs like Forsythia and ornamental currants.
Just select the stems that flowered, and prune out these stems. Leave the stems that just produced leaves – as they will produce the flowers next spring.
Once you've done this, prune out any stems that spoil the overall shape of the shrub or stems that are dead or damaged. Apply a mulch of bulky compost or manure around the base of the plant, avoiding the trunk, and you'll have a plant ready to flower next spring, that will be tidy, healthy and won't be overcrowded with stems.
Introduce pondside plants and lilies to your pond
If you've got a pond and it's ready for some colour and texture to enhance it, now's the time to add some pond plants in and around the water.
You'll add colour to the pond as well as fresh scent from some flowers. You also provide vital shelter for fish and other aquatic animals. Pond-cleaning snails like to lay eggs on the undersides of lilies while fish like to retreat under the leaves from midday sun and cats.
Here are some pond plant suggestions for adding to your pond.
Lovely waterlilies
Nymphaea 'Colorado' for vibrant salmon-pink flowers
Nymphaea 'Almost Black' for evocative and darkest-red of flowers
Nymphaea virginalis a lily species with the purest white of flowers
Nymphaea 'Wanvisa' A really exotic looking lily – pink with cream specks
Pond plants for the edge
Lythrum salicaria for tall stems of purple flower, attract insects and lovely colour
Mentha aquatica – water mint for lovely aroma, globes of purple flowers
Lobelia fulgens 'Queen Victoria' regal by name, regal by nature; brilliant scarlet flowers on tall imposing stems
Oxygen-encouraging plants
Lagarosiphon major – submerge in your pond, and this plant will keep it oxygenated and help to keep it clear. It provides shelter too for aquatic wildlife.
Ceratophyllum demersum – hornwort provides a dense mat of oxygenated stems; more stems for a healthier water environment
Ranunculus aqualitis – water crowfoot offers oxygenating stems as well as pretty flowers. Great for all pond sizes.
Cut back the stems of wisteria as the flowers fade
Wisterias offer a shower of colour in May and early June, and decorate walls and fences beautifully. The flowers get more and more bold each year too so it's worth adding this gorgeous climber to your garden.
To get it looking at its best next year, prune the stems back after they have flowered. This will make it look tidy, get air circulating round its stems for a healthy growing environment and it will encourage more growth for next year.
Trim stems with secateurs to about six bud from where the stems start. This may seem like you are getting rid of a lot of green growth but rest assured, a good post-flower haircut will encourage the climber to grow bushier and stronger for next year.
After the trim you might want to tie in some of the remaining stems that protrude outwards. This post-flower trim is a good opportunity to cut out stems that are damaged or dead too, making your wisteria even healthier.
After the trim it's worth adding some bulky compost or manure as a feed to the base of the plant to keep the surrounding soil full of nutrients.
Plant of the month – Salvia 'Hot Lips'
Salvia 'Hot Lips' is a fantastic perennial to grow in your flower bed for a bright and vibrant display of red and white flowers in mid-to late summer and, if mild, well into autumn. Reaching up to 1m (3 1/3 ft), plant in the centre of your flowerbed for the best display. The leaves are scented too, and you can sometimes catch a fruity scent in the air when you're nearby.
Plant with other mid to late summer-flowering perennials like Rudbeckia and Helenium. These are all great bee-magnets bringing your garden to life in summer.
Height: up to 1m (3 ft)
Flowering period: May to October
Pest watch – Weeds
Weeds are pretty much inevitable in the summer garden. With so much sun and rain, often one following the other, it's the perfect weather for opportunistic weeds. And there are three main reasons why weeds spell trouble;
Weeds are very wired to good survival. They either have large taproots (like dandelions) to anchor them into the ground and take up nutrients in the soil or other roots that spread successfully in the soil. Either way they're built to stay unless you nip their growth in the bud.
They often provide perfect venues for pests to breed and lay eggs, and diseases to form and spread.
They are robust enough to take a great proportion of nutrients in the soil, and produce a dense canopy of leaves that take the limited amount of sunlight. Most significantly, they take up a fair bit of soil moisture too.
So apply a systemic weedkiller, whether you have pesky weeds in your lawn or they are cropping up in your flowerbed or veg plot. The active ingredient gets right into the 'veins' or the plants and transports the chemical from leaf tip to roots – a really effective means of killing weeds fast.
Be sure to apply weedkiller on a still, dry day so that the chemicals are not blown off the plants in the wind or diluted by rain. If it does rain shortly after applying weedkiller, you may need to reapply.
Visit BBC Gardeners' World Live at Birmingham from 11-14 June where you get the opportunity to see gardening and food experts like Monty Don and Mary Berry. There's a wealth of floral exhibits from nurseries around the UK, evocative Show Gardens and lots of inspiring things to see and do for the home and garden, all in one place at this central England show.
And be sure to take a trip to the RHS Hampton Court Palace Flower Show from 30 June- 5July. Set by the majestic Hampton Court Palace in Surrey, this is the world's largest annual flower show. With beautiful Show Gardens, plants to browse and buy and features located in handy zones Grow, Inspire and Feast, it's a great mid-summer event to visit.
Congratulations go to Burncoose Nurseries who entered Viburnum plicatum f. tomentosum Kilamanjaro Sunrise ('Jww5') into the RHS Chelsea Flower Show Plant of the Year 2015. The shrub, with beautiful lace-cap flowers in spring, was selected from a short list of 20 plants which included enchanting rose Susie.
Want instant impact for your gardens? Get our pre-planted hanging baskets like Sizzle Pink Pre-Planted Hanging Basket. Expertly grown in quality compost, enriched in plant food and containing a water-retaining gel, it leaves you to simply put up the basket and enjoy its long-lasting flowers. Or get our Buy 1 Get one free colour-theme basket and container collections – to suit your own tastes and match colours in the garden.
There's herbaceous perennials to suit all gardens. Some of our favourites for space-saving and glorious colour in summer include Penstemon 'Heavenly Blue', Monarda 'Scorpion', Campanula 'Iridescent Bells' and new and exclusive Salvia 'Kate Glen' with its colour-changing flowers and fresh leaves set against stems dark as night. They're all magnets for pollinating insects and all work perfectly in the flowerbed or as focal plants in containers. Why not give them a try?


text:
Eyelash Makeovers: Treatments to Make Your Lashes Stand Out
Women have been playing up their eyes since the days of the ancient Egyptians. In terms of makeup, there's eye shadow, eye liner, mascara and even false eyelashes. However, in the world of beauty things are always changing, including the way women are able to


text: The Home Depot in Auburn, Maine had an odd 1.4 ton pallet of pellets for sale, it looked factory rapped and not just a bunch of loose bags tossed together. The price was $419.00 and I'm not sure of the brand. is this something new from the mills or just a fluke? I like the idea myself, and hope this becomes a new standard. bill


text:
Nowadays, premature ejaculation is a perfectly normal problem and a lot of men confront with this situation. There are some individuals who cannot maintain the sexual act for more than 2-3 minutes, no matter how hard they try. According to a recent study, a woman will be fully satisfied after a 20 minutes intercourse, because that's when she starts having one orgasm or more. Unfortunately, a man who cannot last for more than 3 minutes cannot satisfy an average woman, and this can be a problem for their couple life. Thankfully, VigRX Delay Spray is the ideal solution to prevent your premature ejaculation and to fully satisfy any woman. In this VigRX delay spray review, we will tell you more about this product, and we will also explain you how to use it, for best results.
1) How To Use It?
VigRX Delay Spray functions as a smooth anesthetic, which makes your penile muscle relax, in order to prevent any premature ejaculation. This product is very simple to use and all you need to do is to apply up to 3 puffs, directly on the penis. After that, you should let it get absorbed, for at least 10 minutes. Normally, this product will help you last from 20 to 30 minutes, but if you use it for a long time, you will be able to last even longer.
2) Is It Safe?
VigRX Delay Spray it's being produced in a medical facility from the United States, which is accredited to manufacture such substances. The product is tested and it passed all the safety labels, without any negative manifestations. Even though the spray manifests different from one man to another, nobody experienced any negative side effects. Also, VigRX Delay doesn't cause any health issues, and we can say that it's safer than any potency pills, which are known to cause heart conditions.
3) Can I Combine VigRX Delay Spray With Other Similar Products?
Of course! VigRX Delay Spray is 100% safe and it won't negatively interact with other potency products. Still, it's advisable not to use this spray with other benzocaine based products. If you use too much benzocaine or if you apply more than 3 puffs of VigRX Delay Spray, then you won't enjoy the sexual act anymore and you might also lose your libido. Other than that, there is no restriction whatsoever and you can use VigRX Delay Spray with alcohol or any kind of substances.
4) Where Can I Purchase VigRX Delay Spray?
Lately, there are many private vendors who trade this product, but nobody can guarantee you quality or safety, if you purchase from them. The most advisable way to procure VigRX Delay Spray, is by purchasing from their official website. This way, you will know that you are getting the product from a reliable source and quality/safety is ensured. Another advantage of purchasing from the original site, is the fact that you can return the product for any reason, after up to 67 days, and you will receive a full reimbursement.
Final Thoughts
VigRX Delay Spray is the best treatment against premature ejaculation and it will surely do its job, in about 10 minutes. According to a study, 30% of the American men suffer from premature ejaculation. The problem is more common then you might think, so there is no reason for you to be worried or ashamed. What you need to do is take action and find a reliable and effective solution against premature ejaculation. Purchase VigRX Delay Spray today and get ready to revive the passion in your relationship.


text:
Discussion in 'Photoshopped, Captions, Tribute Pictures' started by Janie Tgirl, Dec 13, 2012.
Lol all real MEN are strong and BLACK
but you also need white men to masturbate in the corner while you get blacked don't you? Else what else is there for us?
Separate names with a comma.


text:
You've just added an item to your enquiry. When you're ready you can submit your enquiry here.
Set in the famous and historic red brick building, this hostel is steeped in over 100 years of history.
This place was once home to industrial machines and a thriving workforce, and the hostel still retains some of its original features and vibe. The bright and airy building is a two minute walk from East Side Gallery – the most decorated part of the Berlin wall – as well as five minutes from the huge and world-famous Watergate nightclub. There are also excellent transport links into the centre, with the Warschauer Strabe Underground Station just outside. The hostel is just as cool as its history, boasting a whole load of dorm and private rooms – many even feature a private bathroom and sweeping city views. There's even a shared kitchen, a breakfast buffet on offer each morning, an outdoor terrace, stylish lobby bar and 24 hour reception.


text:
Chy-an-Heyl offers self catering accommodation located on the outkskirts of the village of St Erth and just a short drive from the bustling town of St Ives. It's an excellent base for those wishing to explore the many attractions that Cornwall has to offer.
You can find this advert on our website www.theholidaycottages.co.uk by clicking on the details below:
Chy-an-Heyl St Erth, St Ives, Cornwall (Sleeps 1 - 4)
Our holiday home has been superbly equipped the kitchen has a gas cooker, fridge, washing machine, microwave, electric kettle and toaster.
We have a secluded south facing with garden furniture and BBQ. Lawn/flower beds and shallow stream at end of garden.
Our holiday home is located near St Ives and within easy reach of numerous beaches and places of interest, Chy-an-Heyl is a Granite & Cob cottage that was built in the mid 1800's.
The Holiday Cottages is an online user friendly directory for self catering accommodation in the UK and Ireland. To keep up to date with the properties on our website join us our social media websites below:
With over a decade of experience in promoting self-catering property, we at The Holiday Cottages try our best to ensure you our customers receive a personal and friendly service and an effective way to create business for your accommodation.
All bookings and enquiries go straight through to you, so click on our advertising link below and join us today:


text:
It looks like you've lost connection to our server. Please check your internet connection or reload this page.
log in
scroll to top
A History of Humanity in the Ancient World
Page 1 of 1
Continue to see the rest of the document →
Read full document
← View the full, formatted essay now!
Download this essay
Print this essay
Read full document
Get full access to this
document and many more!
Document details:
Words: 756


text:
3DOcean Cobra 3373461
3DOcean Cobra 3373461
3D Model \ Animals \ Reptiles and Amphibians
Serpent \ Skin \ Slitherin \ Snake \ Scales \ Prey \ Anaconda \ Cobra \ King \ Predator
3D Model - Cobra 3373461 by bizla @ 3DOcean
3D Model \ Animals \ Reptiles and Amphibians
3D File Formats Included: .blend (blender), .fbx (multi format), .obj (multi format); Animated: No; Created In: blender; Geometry: Polygons; Low-poly: No; Materials: Yes; Poly Count: 9749; Rigged: No; Textured: Yes; UV Layout: Yes.
Very high quality 3D model of a Cobra, king of all serpents.
High resolution texture included (4k)
Clean topology.
textures hand painted on.
main body seperated into lots of loop cuts for easy rigging.
does not come ready rigged.
any questions please ask.
And also please remember to rate model.
RIGGED Little Robot; Mitchell The Mouse RIGGED; Rudolph The Red Nosed Reindeer; Special Occesions Balloons; Metalic Balloons; Pastel Balloons; Viking Giro D'italia Racing Bike.
Keywords: adder, anaconda, cobra, king, predator, prey, scales, serpent, skin, slitherin, snake.
Download Link


text: Gear up for a wild weekend in Charleston! The Southeastern Wildlife Exposition is the largest wildlife, art and sporting event of its kind, showcasing more than 500 artisans, wildlife and nature experts and sporting demonstrations. Find us oohing and ahhing at the Birds of Prey Flight Demo, browsing exquisite art at the Fine Art Exhibit and enjoying BBQ bites from world-renowned pit masters and bluegrass tunes by the fire with The Bluestone Ramblers during this year's brand new event, the Lowcountry Social. Find your weekend essentials at Charleston's Indigo & Cotton then get ready to explore your wild side in the Lowcountry!


text:
RevoStock Dynamic Presentation 63426
After Effects Project \ Commercials \ Intros \ Action \ High Energy \ Opening Sequences \ Credits
After Effects Project - Dynamic Presentation 63426 by AEdude @ RevoStock
After Effects Project \ Commercials \ Intros \ Action \ High Energy \ Opening Sequences \ Credits
Sound: no; Loopable: no; Downloads: 74; Length: 00:36; Model Release: no.
Dynamic Presentation - is very easy to customize. Just replace the content in the footage-windows with your own clips or photos, change the text and you?ll get a very professional looking, dynamic presentation. When you don?t like the colors, even this is very easy to change, with any colours you like with a few clicks. The main comp is HD 1920x1080, comps for HD 1280x720, PAL and NTSC are included. I have attached a readme file with instructions.
If you like it, check out my other projects here.
This product is an Adobe After Effects project file. It requires Adobe After Effects version CS3 or higher as well as any plug-ins listed fellow: Required After Effects Plugins: None
Keywords: dynamic, fast, intro, flip, outro, action, camera, 3d, fly, company, presentation, young, hip, trendy, space, disco, feature, design.


text:
As the coming of every year, certain cosplay outfits will be seen more than others due to the popularity at the time. The following, in no particular order, are our popular cosplays predictions you will most likely see at a gaming, sci-fi, or cosplay convention near you!
Final Fantasy XV was released in the final quarter of 2016, and one of the games supporting characters has caught the attention of everyone's eye; the sexy mechanic, Cindy!
Wonder Woman is already a popular cosplay choice among many women. But, expect her to rise in even more popularity due to the new Wonder Woman movie coming out in June 2017!
The Power Rangers have a new movie coming out in the Spring of 2017! So, expect fans to cosplay as these characters this year. It's morphin' time!
Jack Sparrow is returning to the big screen in May of 2017, which will give fans another reason to cosplay him!
Expect Attack on Titan to gain new popularity among new fans, as well as old ones, with the release of Attack on Titan's long-awaited second season!
RWBY is still ever-popular, and will continue to be going into 2017, since the release of Volume 4 in 2016.
With both the Nintendo 3DS games and the anime of the same name, and the new look and feel of the popular characters, expect a few cosplayers to give them a shot!


text:
Alternative Title: "Grosser-Tiger und Kompass-Berg"
Learn about this topic in these articles:
children's literature
...should be made of Fritz Mühlenweg, a veteran of the Sven Hedin expedition of 1928–32 to Inner Mongolia and the author of Grosser-Tiger und Kompass-Berg (1950; Eng. trans., Big Tiger and Christian, 1952). A long, richly coloured narrative of a journey made by two boys, Chinese and European, through the Gobi Desert, it should stand as one of the finest adventure...


text:
Government Blocks 240 Websites Offering Escort Services
15/06/2016 1:34 PM IST | Updated 15/07/2016 8:27 AM IST
Prajakta Hebbar News Producer, HuffPost India
NEW DELHI -- The central government has banned websites offering escort services -- which are usually a front for prostitution -- acting on the recommendations of a committee set up by the Home ministry.
"The order to block 240 escorts websites was issued to internet service providers on Monday on recommendations made by an expert committee under the Ministry of Home Affairs," an IT ministry official said.
It usually takes some days for Internet Service Providers (ISP) to fully block the sites and, as of Wednesday afternoon, several popular escort websites on the banned list could still be accessed.
However, the move was criticised by some who called it directionless.
"Content of all the websites cannot be blocked. The order has been issued without going into the technical nitty-gritty around it. If a website changes the name or link slightly, it will again start working," an executive working with an ISP told PTI.
He added that the websites had listed phone numbers which could easily be used to track down culprits and control such activities.
Last week, the social service branch of Mumbai Police arrested a famous TV actress, often seen in the crime show Savdhaan India, and her accomplice, for their alleged involvement in a prostitution racket.
In August 2015, the government tried to block several online porn sites but had to backtrack after the move was widely criticised.
Get top stories and blog posts emailed to me each day. Newsletters may offer personalized content or advertisements. Learn more


text:
Please note: legislated requirements change from time to time so please be sure to seek further advice about your obligations before selling your own home.
The Office of Fair Trading Queensland provides information on their website for those who choose not to sell their home or property through an agent. This information confirms that any home owner in Queensland is well within their legal rights to sell their home privately.
The most important issue to cover is seeking legal advice regarding contracts. Your solicitor or lawyer will assist you with the current legal requirements.
The OFT Queensland suggests that Private Home Sellers follow these guidelines:
The Real Estate Institute of Queensland (REIQ) does not provide any specific advice for Home Owners who would rather sell privately, but some useful information may be obtained from their page '8 Steps to Selling Property'. It has been written to involve the services of a traditional agent, which of course is not mandatory.
It is important to note that the individual, State by State, Real Estate 'Institutes' (e.g. REIQ) are industry-based bodies who support Real Estate brokers/agents in the areas of training, advice, dispute resolution, Government advocacy, compliance and general support. Laws involving the transaction of property (contractual obligations etc) are set down in individual State Statutes and Acts – enacted by the State Governments and enforced by each of the State Offices of Fair Trading, Dept. of Commerce or Consumer Affairs etc.; not the Real Estate Institutes
We encourage you to visit the Office of Fair Trading website for updated or additional information about selling your own home, or contact them directly on 13 74 68
Selling in Other Australian States How to Sell Your Own Home Compare Member Options Questions? Contact us


text:
L.A. Braces For King Of Pop's Public Memorial
Thousands of Michael Jackson fans have descended on Los Angeles. A private funeral is expected to be held at Forest Lawn Cemetery, and a public memorial will be held at the Staples Center.
Michael Jackson: Full NPR Music Archive
RENEE MONTAGNE, host:
Today is the day for saying goodbye to Michael Jackson. It starts with a private service at a cemetery in the Hollywood Hills and it ends with a star-filled memorial at Staples Center in downtown L.A. Across the country, millions of Jackson fans will watch on television. As NPR's Carrie Kahn reports, only a lucky few will get into the arena.
CARRIE KAHN: Police have blocked off the streets for two square blocks around Staples Center, and the only way to get past the barricades is with a ticket and a wristband. One-point-six million entered a lottery to get them, fewer than 20,000 did.
(Soundbite of screaming)
KAHN: Squeals and screams came from cars yesterday at Dodgers Stadium as lucky recipients came to claim their tickets. Minar Garcia(ph), a local computer specialist, said he couldn't believe when he opened his email and got the notification.
Mr. MINAR GARCIA (Computer Specialist): When I saw mine said I was a winner, I was like, whoa. I almost fell out my seat.
KAHN: Jackson fan Sherry Howell(ph) said she was also a winner but she thought it was more important for her kids to go to the memorial. She says she gave them her tickets.
Ms. SHERRY HOWELL: I have a legacy inside me, and they need this. They need to see what music is built on and what it's about.
KAHN: Daniel Hernandez says he signed up for a ticket as a fluke but he's thrilled his name was drawn. After joking about maybe selling his ticket, the local wardrobe stylist says he feels like he's part of history.
Mr. DANIEL HERNANDEZ (Wardrobe Stylist): It's like, you know, when Princess Di died. You want to be part of the experience. I mean, it's a cultural experience that not a lot of people are going to be able to have.
KAHN: It's all those disappointed people who didn't win a ticket that have city officials in L.A. worried. Police have repeatedly told citizens and visitors to stay away from downtown. They've deployed 1,400 cops around Staples Center, and the big Jumbotron screen outside the auditorium will not be carrying the memorial, says Assistant Chief Earl Passenger.
Assistant Chief EARL PASSENGER (Los Angeles Police Department): There will be nothing to see. Yur best advice - our best advice is to stay at home and watch the ceremony from the comfort of your home.
KAHN: The Jackson family says the star-studded guest list includes Stevie Wonder, Mariah Carey, Usher and Kobe Bryant. Long-time Jackson friend Elizabeth Taylor will stay at home and grieve in private.
Meanwhile, the fight over who will control Jackson's estate continues to play out in an L.A. court. Yesterday, a judge took temporary control away from Jackson's mother and gave it to two men - one a family friend and the other an entertainment lawyer. Jackson named both as co-executors in his will. Attorney Howard Weitzman represents the men.
Mr. HOWARD WEITZMAN (Attorney): It's our obligation, our duty, our responsibility and our desire to do everything we can to carry out Michael Jackson's wishes, maximizing the assets of this estate and allowing his fans to continue to enjoy the great legacy that he brought to all of us.
KAHN: But Katherine Jackson, the singer's mom, says she's concerned about the two men holding all the keys to the kingdom.
For now, fans like Paul Black, an L.A. film student from Australia, just want to pay tribute to Jackson's life and his music.
Mr. PAUL BLACK (Film Student): It's really just about everybody coming together and saying goodbye and celebrating Michael's life and having some closure. And that means a lot to me and it means a lot to a lot of fans.
KAHN: Black was able to sign the huge white tribute board in front of Staples Center before police blocked off all the streets. Luckily, he'll be able to come back this morning to pay his respects to Michael Jackson again. He got one of the free lottery tickets.
Carrie Kahn, NPR News.
Copyright © 2009 NPR. All rights reserved. Visit our website terms of use and permissions pages at www.npr.org for further information.
NPR transcripts are created on a rush deadline by Verb8tm, Inc., an NPR contractor, and produced using a proprietary transcription process developed with NPR. This text may not be in its final form and may be updated or revised in the future. Accuracy and availability may vary. The authoritative record of NPR's programming is the audio record.


text:
On Saturday and Sunday, September 15 & 16, from 1-4 p.m, there will a
reception for the "Artists in Residence" at the Armory Northwest.
Come out and celebrate with us! We'll have a BBQ with drinks and
music too!
Five artists have occupied the large space on the NW corner of Fair
Oaks and Mountain throughout the summer; Stephanie Allespach, Chelsea
Dean, Michael Markowsky, Hataya Tubtim, and Nicola Vruwink). They
have all made new bodies of work and they look forward to sharing it
with the public!
965 North Fair Oaks Avenue, Pasadena, California 91103


text:
The information contained in this presentation has been collected from multiple documents and presentations. It is not intended to contain any legal advice. Please consult with your legal advisors for specific information that may apply to you and your company. AN. EDITORIAL. MOMENT.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
The information contained in this presentation has been collected from multiple documents and presentations. It is not intended to contain any legal advice. Please consult with your legal advisors for specific information that may apply to you and your company.
Insurance Companies collected from multiple documents and presentations. It is not intended to contain any legal advice. Please consult with your legal advisors for specific information that may apply to you and your company.
Who's to Blame?
The President signed the health care legislation into law on March 23, 2010.
The regulations defining the law are being written by HHS, DOL and IRS.
IRS & OSHA have monitoring responsibility.
CMS has responsibility for most of the implementation, including that of the Marketplace.
Grandfathered Plans
Exemption from rating restrictions based on age variation.
Ability to continue coverage based on class.
Exemption from implementing Essential Health Benefits (e.g. pediatric dental).
Increase Deductible up to 15%.
Increase Copays up to 15%.
Increase Coinsurance more than 15%.
Decrease employer contributions by more than 5%.
Most plans have lost "Grandfather" status.
Those who have retained status must provide a statement to participant that it believes it is a "Grandfathered" plan.
Do you have your documents?
Coverage for children must be available until the child reaches age 26.
Do you have proof of the notice to employees? (Penalty up to $100 per day).
The MLR is 85% for large group plans and 80% for individual and small group plans (50 and below).
Carriers will have to issue a premium rebate to individuals for plans that fail to meet the minimum MLR requirements.
51 or More Full-Time Employees
Effective starting January 1, 2015.
Employer must count all full-time employees and part-time employees on a full-time equivalent basis in determining if they have 50 or more employees.
Does the employer have collected from multiple documents and presentations. It is not intended to contain any legal advice. Please consult with your legal advisors for specific information that may apply to you and your company.
at least 50 full-time employees?
NOPlay or Pay Penalties Beginning in 2014
Does the employer offer coverage to all full-time employees?
Did at least one full-time employee receive a premium tax credit or cost-sharing subsidy through an Exchange?
$2,000 x number of full-time employees minus 30
Is the employee's required premium contribution for single coverage for the employer's lowest-cost plan 9.5% or less of the employee's household income?
Do any employees purchase coverage in an exchange and receive a premium tax credit or cost-sharing subsidy?
Lesser of $3,000 x number of employees receiving premium tax credits, or $2,000 x number of employees minus 30
Does the employer-sponsored plan provide minimum value?
Total number of full-time employees = 30.
Part-time employees = 40.
Total hours worked by each part-time employee in a calendar month = 20 hrs / week x 40 = 3,200 hrs.
3,200 / 120 = 27 Full-time-equivalent employees.
Total full-time and full-time-equivalent employees = 57.
Play or Pay penalties apply.
Employee hourly wage $9.50 per hour
$9.50 x 40 hours = $380.00
$380 x 9.5% = $36.10 per week
Employee cost of health insurance $156.43
Start tracking part-time hours now.
Start tracking full-time hours now.
Learn about the safe harbor for seasonal employees.
If employee is covered by spouse's plan there is no penalty to employer unless 50+ and employer does not provide coverage or provides unaffordable coverage.
Employers are not required to cover spouses. Definition of a dependent does not include the spouse.
1 to 50 Full-Time Employees
Minimum value - actuarial value threshold of 60%.
Small group plans in the bronze level of coverage meet minimum value requirements.
Beginning in 2014, summaries of benefits and coverage must indicate whether the plan meets applicable minimum value requirements.
Censuses must provide every dependent's date of birth and the quotes will be lined out with a rate for each belly button. So a quote (and the eventual billing) might look like this on a 3-person group:
John Brown $328.95 Employee
Joe Smith$358.23 Employee/Spouse/Children
Jane Smith (wife) $429.29
Danny Smith (12) $158.77
Jennifer Smith (14) $158.77
Joey Smith (22) $253.97
Susie Smith (24) $260.09
Bobby Jones $598.98 Employee/Spouse
Anna Jones (wife) $555.23
(The Exchange)
Smaller provider networks.
Smaller hospital network.
No out of network benefits on some plans.
Gatekeeper plans (no open access).
PCORI Tax-$2.00 per covered individual-Self Admin HRA, per each employee and each dependent.
Reinsurance Tax-$63.00 per year per each employee and each dependent. Funds large claims in the individual market.
HIT Tax- $8B divided by premiums collected in prior year 2014. $15B 2015, $18B 2016- Paid by insurers to help fund health care reform.
All are pass through taxes.
Medicare Tax increase for high income earners an additional 0.9 to employees earning over $200,000 ($250,000 joint filers).
DOL ran a contest for the best software to inform employees about labor laws.
Award winner announced on November 4.
$14M effort to educate employees.
Many employers have said they will move employees to 1099 status.
The IRS is on to this and will be conducting audits.
An employee can contact IRS and ask about their status and you could receive an audit notice.
Engage an independent contractor for a year or more.
Be very careful with this!!
You are not an independent contractor if you perform services that can be controlled by an employer (what will be done and how it will be done). This applies even if you are given freedom of action. What matters is that the employer has the legal right to control the details of how the services are performed.
Guaranteed Issue.
State Exchanges/Federal Exchange.
Modified Community Rating (Groups 50 or fewer).
Redefines Small Group at 1-100 in 2016.
Employer Mandate.
Waiting Periods 90 Days Max.
Full Time Employee for health insurance purposes-30 hours per week.
There is no requirement to pay the health insurance for part time employees.
Employers who issue 250 or more W-2s are required to list the value of the health insurance on the W-2.
Employers will report employees and the hours worked each month. 2015.
Exempt employees can be calculated at 8 hours per day, 40 hours per week, or actual hours worked.
Form 1095-C.
Information must also be provided to each employee.
Flexible Spending Accounts (FSA)-Over the counter drugs are not eligible. $2,500 cap.
Developed and provided by the insurance company.
Delivered during Open Enrollment.
At a Qualifying Event.
60 days prior to a plan change during the plan year.
When an employee qualifies for coverage during the plan year.
Upon request.
Employee Notice Requirement.
Employers must issue a notice to employees about the Health Insurance Marketplace (Exchanges) availability and premium assistance by October 1, 2014.
No penalty.
Distributed by October 15.
Distributed to all employees age 65 and older.
States the company health plan has drug coverage equal to or better than Medicare Part "D".
Online verification to CMS within 60 days of renewal.
No stand alone, except for retirees.
Some will and force their employees to the Exchange.
In some cases, the penalties are lower than the cost of coverage, but what about the soft cost of competition?
Keeps current plan design in place until December 1, 2014.
Avoids age rated plans for all groups under 50.
Avoids community rates.
Avoids PPACA plan designs.
Employer liability limited to the monthly premiums.
Monthly claims reports.
If plan develops a surplus the employer can receive a refund.
If plan runs in a deficit, no deficit recovery.
Places the insurance buying decision in the hands of the employee.
Must still comply with affordability.
Wide range of options for the employee.
Must be equal to all.
Employer Allowance $300
Medical -$250
Dental -$25
Vision -$10
Total -$285
Employee +$15
You will be exposed to every concept you can imagine.
Some old concepts, some new.
Some will survive, and some will cause the employer bigger problems.
Caveat Emptor (let the buyer beware).
Select a trusted advisor.
CMS.gov-search "minimum value calculator"


text:
Get Ready, Maybelline Has More New Products
5 varieties available
Christian Dior Diorific Lipstick
4.61 / 5 based on 251 Reviews
Product Description
A satin-smooth lipstick that moisturizes and protects your lips -Perfect balance between wear and comfort -Provides stain-free long-wearing maximum color-true intensity depth and radiance Product Line: Christian Dior - Lip Color - Diorific Lipstick (New Packaging) Product Size: 3.5g/0.12ozsee more...
Top Questions See all 3 Q&A
- How pigmented and long wearing are these? Fav shades? Satin or ma...1 Answers
- I have been testing different dior lipstick for a few weeks, and ...1 Answers
- I love pink shade and its packaging is awesome is... Be the first to answer!
Christian Dior Diorific Lipstick
Reviews (251)
Media (8)
Review for: Rouge Long Wearing Color
I am thrilled with this lipstick. It is a beautiful formulation, that is hydrating and incredibly long wearing. I put this one (lightly, mind you), and went out to a very messy, long dinner. There is transfer, as this is not meant to be a smudge-proof lipstick. When I saw it on my napkin, I assumed by the time I left the table there would be nothing left. Not so! It still looked great. I definitely needed a reapplication, but it looked good enough to walk around and not feel uncomfortable with the state of my lips. I'm an official convert. The formula is far superior to similarly priced lipsticks that I've been buying
I have the Noir Flash shade which I stole from my mom when I was visiting. I believe the shade (a perfect deep purple) is discontinued so I'll focus on the formula. It glides on very easy but I don't find it to be particularly long-lasting. It's a cream formula though so it's to be expected. The packaging is very glam - the gold makes it look luxurious and the spheres on each side are unique. It isn't the most convenient shape to carry though and I like to bring it with me for touchups.
This is one of my favorite lipstick formulas! It's so light, comfortable, easy to apply, and wears well for a very long time. The colors are just gorgeous. I wish they would do a full permanent line of them! The packaging is a little goofy, to be honest, but I don't mind because the actual lipstick is so fantastic. I will definitely buy more of these if they release another collection for holiday!
Ladies, what's better than a lipstick that doesn't rub off after every bite?? The application of this lipstick is amazing. It leaves your lips feeling smooth and kissable and doesn't leave them feeling dry like most long lasting lipsticks. It allows them to breath!!! The color payoff is so worth the price! Def checking out the other colors. Just take my money!!!
Where do I begin with this brand. Christian Dior is fantastic when it comes to lipsticks. The Christian Dio Long Wearing True Color Lipstick says it all. The color does in fact stay all day and won't move anywhere while your going on with your day! The colors are also wonderful! My personal favorite is the light nude pink tiny which also moisturizes my lips!
Review for: 008 Mystic Mauve 3.5G
I've really been interested in Dior cosmetics lately. Their lipsticks and their airbrush foundations are two of my favorite products. The lipstick covers nicely and evenly with great color. It leaves your lips feeling soft, not dry. The packaging is so classic. I would definitely recommend it and plan on buying it again!
These lipsticks are worth the money and they actually last like a liquid lipstick, I use to be a lipstick junkie until I decided to give this a try and let me tell you they have replaced all my liquid lipsticks, I can go a full 5 hours and actually being able to retouch it without feeling nasty and without it cracking
Review for: 008 Mystic Mauve 3.5G
Aside from the adorable product details this lipstick is out of this world! Dior has done it again with an amazing formula for our lips! I love the smooth consistency this lipstick has when applied and the COLOR is insanely on point! Coverage is nice and even without even having to try. This is an absolute MUST HAVE!
This is the most AMAZING lipstick I've ever tried! my mom gave me this and i fell in love with it. The colors are just gorgeous. I wish they would do a full permanent line of them! the lipstick is so fantastic. I will definitely buy more of these if they release another collection for holiday! i loved the packaging
Love this lipstick! I love the color and I also love the packaging it comes in. I am a first time user, and I love how the colors look too as well as it leaves my lips feeling nice and soft. I bought this product online. It is very easy to apply and I will definitely recommend this product to family and friends.
How pigmented and long wearing are these? Fav shades? Satin or matte finish?
I have been testing different dior lipstick for a few weeks, and I want to buy one of them. I think this is the better one, would you recommended me this?
I love pink shade and its packaging is awesome is any one tried
See All Photos & Videos


text:
You can now avail subsidy from the Central Govt. on purchase of your first house under "Pradhan Mantri Awas Yojna". For more details click below
About Aadhar:
Aadhar Housing Finance Ltd. (AHFL) is promoted by Dewan Housing Finance Ltd.(DHFL) group with equity participation from International Finance Corporation (IFC), a member of the World Bank Group, is the largest global development institution focused exclusively on the private sector in developing countries. The company Operates under Housing Finance license and is subject to the rules and regulations of National Housing Bank (NHB). The company is driven by independent functioning and management structure, with adherence to the highest standards of Corporate Governance. With the experience and guidance of two major organisations, DHFL and IFC, Aadhar has become an entity to reckon with in a short span of time.
The Focus:
Aadhar has set up its operations in 13 states namely Uttar Pradesh, Madhya Pradesh, Chhattisgarh, Orissa, Jharkhand, Bihar, West Bengal, Gujarat, Rajasthan, Maharashtra, Punjab, Haryana and Uttarakhand. These states, as per Census 2011, account for 72% of the total Indian population. While there has been significant increase in the per capita income in these states, the lower and middle income groups, with income levels between Rs. 60,000 to Rs.6,00,000 per annum, have not fully enjoyed the benefits of this progress. They have been under-serviced for years by most institutions providing housing finance. Aadhar focuses on these segments specifically comprising of salaried, self-employed and agricultural income based population. To ensure that the focus does not shift from this group, the maximum home loan limit has been fixed at Rs. 25 lakhs. This channelized approach would result in dedicated, undiluted attention to this segment which would mean faster and greater growth for the segment thus impacting the nation as a whole.
About Dewan Housing Finance Ltd. (DHFL):
For over 30 years, DHFL has pioneered lending to people who find it impossible to get a housing loan on fair terms. Over the years, DHFL has gained strong expertise in catering to the needs of Lower and Middle Income segments. Having started as a privately funded company with modest means in 1984, DHFL has over a period of 30 years given loans to over a million families, and today has its presence in more than 350 locations across India. DHFL brings its requisite knowledge & expertise, proven systems and processes which is helpful in giving a strong footing for this new initiative.
About International Finance Corporation (IFC):
IFC is a World Bank arm which fosters sustainable economic growth in developing countries by financing private sector investment, mobilizing capital in the international financial markets, and providing advisory services to business and governments. IFC's goal is to improve lives, especially for the people who most need the benefits of growth. IFC as a partner provides deep understanding about this segment as they have been working extensively in India, to cater to varied needs to this segment. They also provide Aadhar access to International knowledge and best practices.
Please select State & City.
© Copyright 2013 Aadhar Housing Finance Ltd. | Privacy Policy


text:
- Inicio
- Revisar estado de solicitud
- Cultura y beneficios de Amazon
- Ubicaciones
- Equipo
- Categorías de empleo
- Ayuda
- Español (Europeo)
Respecto de Orléans
City of Art and History
Just 120km southwest of Paris, Orléans is an attractive city located on the banks of the Loire River, in the Loiret country, Centre region. The second largest city in the middle Loire valley, with around 250,000 residents, it's famous for its ties with Joan of Arc, the maid of Orléans.
The city is steeped in history, but alongside its many world-famous landmark attractions like French renaissance mansions and gothic cathedrals, you'll find some stunning examples of contemporary architecture in the surrounding suburbs. There's also plenty of choice when it comes to restaurants, cafes and bars.
Orléans and the surrounding Loire valley have been declared by UNESCO as a 'patrimony of humanity' in recognition of their great beauty. Anyone who enjoys dramatic natural landscapes, historic towns and villages, and stunning chateaux won't be disappointed.
Our Fulfillment Center
Our Fulfillment Center is in the city of Saran, a few kilometers from Orléans. This vast building of 70,000m² - the size of ten football pitches – was inaugurated by Amazon CEO Jeff Bezos during his visit to France in 2007.


text:
- Please select a date to see the proper prices!
- Meal can be requested on the spot
Best offer
40.50 € / person / night, no meal
Description of the accommodation:
Rooms, services Bed & Breakfast Garibaldi Trapani would be pleased to host you for a few days trip or a longer holiday in Italy. Guests looking for accommodation in Trapani are welcome to book six nicely furnished rooms at the hotel. Should you be arriving by car, parking will be available nearby. Car rental service and organized city tours will help you discover the most important attractions. Nearby bike rental, bowling, water ski, volleyball, diving, sailing, surfing and boat rental opportunities will provide an excellent chance to spend your leisure time actively. Airport transfer is provided upon preliminary notice. In the safe your valuables may be the safely secured. If you have a suitable portable device, you can connect to the Internet via a wireless network (WiFi) available at the hotel. If you wish to learn more about the exact scope of services provided by Bed & Breakfast Garibaldi Trapani (including those available for an extra fee) or about the equipment of the rooms, you can find the complete list on the information sheet below.
Payment Depending on the selected date, room and price, you may need to provide credit card guarantee or advance bank card payment to finalize your reservation.
Arrival, opening hours The earliest time of check-in is 10:00, the latest time of check-out is 11:00. You will be able to speak with the personnel in Italian and English languages.
Bed & Breakfast Garibaldi Trapani rooms Rooms
- Please select a date to see the proper prices!
Accommodation services
Free WiFi in shared places
Relaxation: Bowling, Bike rental at the accommodation
Organized sightseeing nearby, Car rental nearby, Water skiing nearby, Volleyball facility nearby, Scuba diving nearby, Sailing nearby, Surfing nearby, Boat rental nearby
Default services: Pet friendly, Safe deposit box, Roof garden
Airport transfer
Hairdryer, Desk in the room, Mini-bar


text:
Hotel Suites in Alexandria, VA at Holiday Inn Express & Suites Alexandria
Alexandria, VA suites by Holiday Inn Express Alexandria - Fort Belvoir deliver our promise to you: effortless relaxation at a price you can afford. Our rooms are always clean, fresh and appointed with the comforts of home and conveniences of the office.
Guest Rooms in Alexandria, VA
An excellent choice for everyone from business travelers to vacationing couples to families. Choose from either one king bed or two queen beds, each featuring soft triple-sheeted bedding and our signature selection of pillows. Our deluxe Alexandria hotel rooms come complete with a 32" LCD TV with HD programming, free high-speed Wi-Fi, spacious bath and a refrigerator for your snacks and drinks. It's comfort that satisfies whether enjoying a weekend trip or an extended stay
Suites in Alexandria, VA
Upgrade to one of our extra-spacious suites for even more to love. In addition to a much larger space and sitting area to help you stretch out and relax, our fine Alexandria, VA suites feature a hospitality station with microwave, refrigerator and wet bar. Stretch out on your comfy king bed and enjoy an in-room HD movie, or stay in touch with family and friends using the complimentary high-speed Wi-Fi.
Alexandria, VA Whirlpool Tub Suites
Looking to kick back & relax? If you're planning a special getaway in Alexandria, Virginia, consider reserving one of our king whirlpool tub suites offering the luxury of an in-room jetted hot tub. Additionally, these suites include amenities such as a separate living area, mini-refrigerator, microwave & wet bar.
Don't miss out on this great romantic idea for anniversaries & Valentine's Day! Ask about our Romance Package!
Planning an Extended Stay?
Holiday Inn Express & Suites Alexandria offers the perfect home base for your extended stay travels. Learn more about our cozy extended stay accommodations before booking your trip!
More on Extended Stays
Room Amenities
Whatever accommodation best suits your needs, every room at Holiday Inn Express & Suites Alexandria come fully equipped for a satisfying stay:
- 100% Non-Smoking Accommodations
- Free High-Speed Internet Access
- 32-inch LCD HD TV
- Premium HD Programming
- Free Local Calls
- Keurig Coffee Maker
- iHome
- Comfortable Work Desk with Lighting
- In-room Stereo
- Microwave (suites only)
- Mini-refrigerator
- Wet Bar (suites only)
- Separate Living Area with Pull Out Sofa(suites only)
- Iron/Ironing Board


text:
Results 1 to 1 of 1
09-01-03, 07:48 #1Registered User
- Join Date
- Sep 2003
- Posts
- 2
Unanswered: Job calling Store Proc Loop exits after first iteration
SQLSERVER 2000 Sp3, Windows 2000 AS
I have written a stored procedure which uses a while loop to run though a backup file and generates the Restore commands and brings a DR database up to date. The transaction file is appended to during the day on the Production system. The TRN file is copied to DR and the proc reads through applying the files it requires. The TRN file is appended to, so if an earlier run already applied the file, it is skipped having displayed an error about the log being too early - this is fine as it whips though a get to the files that are relevant and applies those. I run this procedure in QA without a problem. I have set up a Job to automate this process, but am finding that the Stored Procedure exits after trying to apply the first file which is not require (as it's too early). This situation seems to cause the job to exit out, whereas in QA the error is igorned and the loop continues?
ALTER PROCEDURE APPLY_TRN @db_name char(10), @trn_file char(500), @undo_file char(500), @cmd char(500) OUTPUT
DECLARE @cnt numeric
SET @cnt = 1
--Apply up to 5 days worth of TRN's
WHILE (@cnt < 240)
SET @cmd = 'RESTORE LOG ' + rtrim(@db_name) + ' FROM DISK = ''' + rtrim(@TRN_FILE) +
'''WITH FILE = ' + convert(char(4), @cnt) +
', STANDBY = ''' + rtrim(@UNDO_FILE) + ''''
SET @cnt = @cnt + 1
PRINT @cnt
DECLARE @cmd_output char(500)
EXECUTE APPLY_TRN @db_name = 'PRT4PRD',
@trn_file = 'D:\MSSQL2000EE\MSSQL$NBSCMCAPP143\BACKUP\4PRD\PRT 4PRD.TRN',
@undo_file = 'D:\MSSQL2000EE\MSSQL$NBSCMCAPP143\UNDO\PRT4PRD_UN DO.LDF',
@cmd = @cmd_output OUTPUT
PRINT @cmd_output
Msg 4326, Sev 16: The log in this backup set terminates at LSN 7684000000033300001, which is too early to apply to the database. A more recent log backup that includes LSN 7702000000017200001 can be restored. [SQLSTATE 42000]
Msg 3013, Sev 16: RESTORE LOG is terminating abnormally. [SQLSTATE 42000]
Instead of ignoring this, it aborts. Can I bypass this behaviour?


text:
When new invasive species reach an area we can minimize their impact through early detection and rapid response. There are invasive species that are known to cause large impacts elsewhere in the Midwest, but are not widely distributed or present in Minnesota. By finding and treating invasive plant populations while they are small, we have a better chance of controlling the population and preventing the species from spreading to new waterbodies.
Criteria for early detection target species are non-native, invasive plants with limited distribution in Minnesota that are assessed as high risk. Please report the location of an invasive aquatic plant.


text:
Profile Created for Self
28 years/ 5Ft. 8In. (172.5 cm)
Not Specified
Never Married
Not Specified
Lives in Any
Detailed profile
About MI-416195
I am a simple guy who speaks Bengali and I belong to a family which has induced a great amount of values and respect for elders. I am a very thoughtful boy and I don't believe that things like caste creed or religion should be taken into consideration while searching your soul mate. I am a boy with good built and 5Ft. 8In. 172.5 cm height.
All Rights Reserved - MatrimonialsIndia.Com (2000)
Web Design by WeblinkIndia.NET


text:
With less than 24 hours before we leave Organ Pipe National Monument, I wanted to post a quick video to give readers an idea of what the area is like.
This is Living In Tin's second visit to Organ Pipe within the last two months. After our first visit here I didn't feel I had "all" the information for potential visitors coming to the area. But with a little more time here we'll have a very good article on visiting Organ Pipe before the end of February.
Of course, sharing a sneak peek never hurts, right? And with that, on to the video. As always, make sure to set the quality to HD, just so you can enjoy a clearer picture!
Submit a comment
You must be logged in to post a comment.


text:
- Locations & Hours:
- Redwood City 650.367.8181
- Take A Tour!
Pine Wood Homestead 62" TV Console in Tobacco Leaf Finish
- Your Price: $799.99
- Retail: $1,008.00
- You Save: $208.01
Pine Wood Homestead 62" TV Console in Tobacco Leaf Finish. This tv stand features 2 textured glass doors with adjustable shelf, two storage drawers and wide sound bar or media opening. There is electrical cord access in back panel. There is ample storage for multiple electronic devices. This piece is rough sawn for a rustic texture. Available in other finishes and door styles. Fully assembled. No particle board. Manufacturer: Sunny Designs
Rough hewn pine wood & veneers
Tobacco Leaf Weathered Finish
- Fully assembled
- Rough hewn wood
- Weathered finish
- Textured glass
- Adjustable shelves
No custom. Other finishes available.
More about Sunny Designs
Sunny Designs is a manufacturer and wholesale distributor of furniture and accessory items. Our goal is to provide the best value and satisfaction possible for our customers. Sunny Designs has manufacturing facilities in Indonesia and China and is headquartered in California.


text:
Places So Awesome To Work At, You'll Want To Quit Your Current Job Right Now.
These employers have spared no expense in creating inspiring, lavishly decorated environments. Plus gyms, spas, game rooms, music rooms, day care, + more!
1. White Mountain Office
This incredible office is literally inside a mountain. It is located in Sweden.
It houses an internet provider and has thousands of servers too.
2. Level 5
Level 5 is a very popular video game developer company located in Japan.
They designed the offices to be more like a rich loft than any typical company.
Almost all of the floors offer lower lighting and amazingly comfortable seating.
3. Kui You Film Productions
This company is based in China and the name itself means "Friend Of The Sunflower".
The designers went with that theme, hence putting in lush green trees everywhere.
There goal was to attract more clients and guests.
The beautiful green scenery has succeeded in this goal.
4. Selgas Cano Architecture Office
This office was designed by the architect himself.
The space is situated in Madrid and is absolutely stunning.
5. Google
You wouldn't expect anything less from the incredible internet search engine Google.
Google looks a lot different than our typical office, with a theater.
An incredible slide.
Oh hey, how about a band while you work.
Or an amazing reading lounge.
Oh you want to work out, how about while looking out at the city.
Or play some hoops with your co-workers.
Can't go wrong with inflatable chairs.
And privacy inside a honeybee comb.
6. Inventionland Offices
These offices are like nothing you have ever seen before.
The company designs over 2000 products a year and their office in Pittsburgh is the headquarters of them all.
Sign up for the Grabberwocky daily email, see everything first!
Powered by WPNewsman


text:
London, Jan 7: English Premier League giants Arsenal FC are all set to offer contract extensions to two of their star players Santi Cazorla and Per Mertesacker.
All leagues special site
Santi Cazorla and Per Mertesacker are two of the most experienced players in the Gunners squad. Taken into consideration their expertise on the field, the club has decided to offer a contract renewal.
Santi Cazorla is one of the most underrated players of this generation. The midfielder has been at the club since 2012 and has been one of their most loyal servants.
A creative attacking midfielder, Cazorla has great versatility which makes him a utility player for the club.
Mertesacker too has been a great servant for the club who provides a much-needed stability in Arsenal defense alongside Laurent Koscielny.
Age has somewhat slowed him down and Arsenal had bought Shkodran Mustafi last summer, but the German veteran is still a great backup option for Arsene Wenger.
Speaking on extending the contracts of the two players, Arsene Wenger said: "We have an option on both of them and I think we will take it.
"The priority first is as football players but as well for their mental guidance.
"We need to have a balance between youth and experience and they are important in that as well."
Arsenal will take on Preston North End FC tonight, January 7 in an FA Cup third round clash.
OneIndia News


text:
When: Tue., Sept. 18, 6 p.m. 2012
Raleigh sprawls, Durham renovates and Chapel Hill preserves its turf. Amid these generalizations are the interstitial folds of the landscape you drive, bike or walk through every day. Los Angeles artist Ruben Ochoa dreams within these urban folds, creating sculpture and site-specific installation work from construction materials such as concrete, pipe and rebar. Both critical and propositional, his work opens the connections between society, architecture and the human scale of sculpture. He's shown in the 2008 Whitney Biennial and the 2004 California Biennial at the Orange County Museum of Art. —Chris Vitiello
Price: free


text:
Precision Private Wealth is financial planning firm which specialises in assisting property investors take a holistic approach to managing their greater financial picture, through providing advice for superannuation, SMSF and insurance requirements.
Which lenders will consider only half debt in joint ownership?
Discussion in 'Property Finance' started by albanga, 3rd Dec, 2015.


text:
Results 1 to 4 of 4
Thread: MSSQL of MS Access' "LAST"
10-17-02, 14:20 #1Registered User
- Join Date
- Oct 2002
- Posts
- 24
Unanswered: MSSQL equivalent of MS Access' "LAST"
Hi Folks,
I am translating an Access query to SQL but having a hard time!
The LAST function works fine in Access but barfs in MSSQL. Is there an equivalent? Here is a snip of the code that works great in Access:
SELECT DISTINCT Last(Customers.custLastName) AS LAST1, Last(Customers.custFirstName) AS FIRST1, Last(Customers.custAddr1) AS SHIP1, etc etc.
The output just takes the last of a bunch of almost identical entries, ie only one customer per line even though they make many orders.
DISTINCT still seems to grab all of the entries in the db. Do I need to expand on this?
Last edited by DataWho; 10-17-02 at 14:27.
10-17-02, 16:50 #2SQL Consultant
- Join Date
- Apr 2002
- Location
- Toronto, Canada
- Posts
- 20,002
try using MIN() instead
10-18-02, 13:44 #3Registered User
- Join Date
- Oct 2002
- Posts
- 24
Hmm much better but still not complete!
Hi Rudy,
Thanks for helping with this, but I have a new problem now. If I use the MIN() function, I get one result per name (good) but some fields do not match up (bad). Here's what I mean:
The only way to get a working result is to use this query
SELECT DISTINCT MIN(sfCustomers.custLastName) AS LAST1, MIN(sfCustomers.custFirstName) AS FIRST1, MIN(sfCustomers.custAddr1) AS SHIP1, MIN(sfCustomers.custAddr2) AS SHIP2, MIN(sfCustomers.custCity) AS CITY1, MIN(sfCustomers.custState) AS PROV, MIN(sfCustomers.custZip) AS ZIP1, MIN(sfCustomers.custPhone) AS PHONE, MIN(sfCustomers.custCountry) AS CONTACT1, MIN(sfCustomers.custEmail) AS NOTES, MIN(sfCustomers.custLastName) AS [LAST], MIN(sfCustomers.custFirstName) AS [FIRST], MIN(sfCustomers.custAddr1) AS ADD1, MIN(sfCustomers.custAddr2) AS ADD2, MIN(sfCustomers.custCity) AS CITY, MIN(sfCustomers.custZip) AS ZIP, MIN(sfCustomers.custCountry) AS CONTACT, MIN(sfOrders.orderDate) AS [DATE], MIN(sfOrderDetails.odrdtOrderId) AS IDENT, MIN(sfOrderDetails.odrdtProductID) AS ITEM, MIN(sfOrderDetails.odrdtQuantity) AS Q, MIN(sfProducts.prodName) AS [DESC], MIN(sfProducts.prodPrice) AS PRICE
FROM sfCustomers, sfOrderDetails, sfProducts, sfOrders
WHERE (((sfOrders.orderCustId)=sfCustomers.custID) And ((sfOrderDetails.odrdtOrderId)=sfOrders.OrderID) And ((sfOrderDetails.odrdtProductID)=sfProducts.prodID ))
GROUP BY sfOrders.orderCustId;
However, the fields aren't from the same record! If I use just a MIN() on the first column, I get the error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Column 'sfCustomers.custFirstName' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
I'm confused! How do I get just the one record, but with the full info from the one record?
Thanks by the way, I'm really in a bind here!
10-18-02, 14:39 #4SQL Consultant
- Join Date
- Apr 2002
- Location
- Toronto, Canada
- Posts
- 20,002
start with the GROUP BY
you are grouping by orders, i.e. you will get one row per order
assuming each order belongs to only one customer, you can bring in customer info along with order info and still get one row per order
but what about products ordered? presumably there can be multiple products on an order, so which (single) product did you want to pick? remember, you are asking for only one row per order