**SHOP TUTORIAL PRODUCTS BELOW**
One of the hottest trends in necklaces! No need to spend big at your favorite boutique when it can be so simple to create the style you love with beautiful crystal beads and stunning charms. I'll show you the tricks to stringing and finishing in a matter of minutes. see more on crimping here: https://youtu.be/8A1Syvi0xOk
-Stringing Wire: https://christinewhitestyle.com/collections/wire-and-stringing-materials/products/beadalon-stringing-wire-19-strand-018-diameter-30-foot-spool-bright
-Lobster Claw: https://christinewhitestyle.com/collections/findings/products/small-electroplated-lobster-claws-brushed-gold-4
-Jump Ring: https://christinewhitestyle.com/collections/findings/products/6mm-open-jump-ring-brushed-gold-20-pieces
-Bead Strands: https://christinewhitestyle.com/collections/bead-strands
-Crimping Plier: https://christinewhitestyle.com/collections/tools/products/crimping-plier
-Wire Cutter: https://christinewhitestyle.com/collections/tools/products/designer-wire-cutter
Hi-I have watched your crimping video but still have a question. When I use crimp beads & the tool that crimps them, I always feel like its not super secure. I try to kinda pull at it to see if its securely in place but it almost always moves (the crimped bead AFTER being crimped)...so I always put a few dabs of G-S hypo cement around the crimp & try to get some down in the surrounding beads. What could I be doing wrong that the crimped beads can move when they should be stationary on the bead stringing wire? I can’t possibly squeeze the little tool any harder! I make sure to use the correct size bead crimper! I just don’t know what the problem is!!!!
Laurie E great question! This is something a lot of people struggle with! Make sure your first contact with the crimp is not anywhere in those little grooves. You want a perfectly flat, even gold metal square after your first step. No rough edges or open areas where the wire can pull straight out. If you are having trouble obtaining this, it’s probably best to use a flat, chain-nosed pliers and squeeze the crimp firmly rather than using crimping pliers.
One other thing to consider- base metal and plated crimps are not always your friend. They can be flimsy and come undone easily. Sterling and gold filled crimp tubes are not much more $$ but make a world of difference. I also recommend “tornado crimps” for folks who are having trouble. It’s a super heavy duty crimp that requires simple flattening.
This article has been motivated by a response I gave to a problem raised on an Oracle developer forum. Our requirement is to produce a report that details customer spending for each month of the year. Our database only records actual spend, so for any given month, data for dormant or idle customers will have to be generated.
First, well create a mock CUSTOMER_ORDERS table with sparse data to represent customer spending. To keep the example simple, well denormalise the customer name onto the orders table.
a sparse report.
With our customer orders data as sparse as it is, a monthly report for purchases by customer would look as follows.
adding the missing months.
We can see from the data that we are missing most months of the year for our two customers. Remember that our requirement is to show a report for every month in 2004 for every customer. First we will build a "time dimension" set (using subquery factoring) and outer join it to our orders table.
We can see that this hasnt quite worked. We have the zero sums and the year-months, but we are missing customer names. This is because we outer joined to CUSTOMER_ORDERS on the year-months, so any customer columns would show as NULL for deficient rows. Until PARTITION OUTER JOIN appeared in Oracle 10g, we couldnt "invent" data easily , though the next section shows that it is possible in prior versions.
data-densification without partition outer join.