**SHOP TUTORIAL MATERIALS BELOW**
Learn to make the quintessential statement piece for one-of-a-kind necklaces and bracelets using headpins, beads and chain to create texture and movement for your jewelry pieces. A fun technique for bead stringers who are ready to take their skills to the next level.
For more about headpins: https://youtu.be/j-PHT2eMEMI
-Round Nose Pliers: https://christinewhitestyle.com/collections/tools/products/round-nose-pliers-zebra-handle
-Wire Cutters: https://christinewhitestyle.com/collections/tools/products/designer-wire-cutter
brittney trayah haha! You are correct!! I had to come up with a fancier name for them for a video & sharing them with the world. But yes, we still call these “babies” around the shop 😂 thank you for watching!!
Cherelyn thank you so much for watching and your kind comment! I can put together a kit with the beads and findings for you if you like. I hope to have all kits available on my site in time. Feel free to email me at : Christine (@) christinewhitestyle.com 😊🌸
I should have asked you this the other day. Does it matter what gauge the headpin wire is? Any recommendations on what size beads to use...or what the size difference between the two beads should be?! I just want to have mine turn out as great as yours!!!
Sarah Pettijohn great question! I’m using 24 gauge in the video! They are thin and great for beginners because the don’t require as much elbow grease to turn. BUT- thinner headpins tend to have smaller heads, something to consider based on your bead and hole size. So usually when I make a larger cluster, I go up to 22 or 20 gauge. There’s no formula for size difference between the beads- you can have a lot of fun experimenting here. 🤗
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.