tag:blogger.com,1999:blog-46252472874796000242024-03-04T20:23:56.635-08:00 Wanderlust CoderComputer/web site programmer that loves design. Hasher, foodie, drinker, and world traveler. Yelper to boot.Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.comBlogger44125tag:blogger.com,1999:blog-4625247287479600024.post-15437137150498581372017-05-04T07:47:00.001-07:002017-05-04T07:47:44.288-07:00Cinnamon Bourbon Peach Upside Down Spice Cake<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQFD8aWAWyBaJfn1QIlBVk05wKWM98Uszhfi5Vuxhxzan4iKkEXqvPu6VLG5lkCwmK1RqUPuFWnfMIqX0sPk-5V7McC5ymTge6Vk1ztyph804eGc9mO6Z-fp0DnnGbi4YD-kMiNSzD77Y/s1600/Upsidedown+copy.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="213" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQFD8aWAWyBaJfn1QIlBVk05wKWM98Uszhfi5Vuxhxzan4iKkEXqvPu6VLG5lkCwmK1RqUPuFWnfMIqX0sPk-5V7McC5ymTge6Vk1ztyph804eGc9mO6Z-fp0DnnGbi4YD-kMiNSzD77Y/s320/Upsidedown+copy.png" width="320" /></a></div>
I made a cinnamon bourbon peach upside down spice cake for my roommate's birthday and had a few people asking for the recipe. Like most things I make, I kind of throw a lot of stuff together. That being said...I thought I would type this one up using a couple of cheats. One big cheat will be using a boxed yellow cake. <br />
<br />
I have to say this cake is by far 1000 times better than the normal pineapple upside down cake. I hope you enjoy it as much as we did.<br />
<br />
<b>Cake Layer Ingredients:</b><br />
<br />
1 Table spoon ground cinnamon<br />
peach juice to substitute for water (optional)<br />
<br />
Prepare the box cake per instructions on the box. Instead of using water for the box cake, I substituted with the peach juice from my canned peaches. Please note I didn't use the canned peaches in syrup. BLAH. I actually used peaches canned in juice. After the cake was all mixed up, I added the cinnamon to tie in the the flavors of the cinnamon bourbon aka Fireball that I was adding to the bottom layer. <br />
<br />
<b>Bottom Layer Ingredients:</b><br />
<b><br /></b>
1/2 cup melted butter<br />
1 cup brown sugar<br />
1 shot (I used 2) Cinnamon Bourbon aka Fireball<br />
1 can sliced chopped peaches (in juice not syrup)<br />
<br />
<b>Directions: </b><br />
<br />
Preheat the oven per the box cake instructions.<br />
<br />
Mix the box cake per instructions given, substitute peach juice for the water that is required. Add the Table spoon of cinnamon and set aside.<br />
<br />
Spray the pan you are using (I used 9 x 13).<br />
<br />
Spread around the chopped peaches.<br />
<br />
Sprinkle the brown sugar all over the peaches. <br />
<br />
To the melted butter, add the Cinnamon Bourbon and combine. Pour this over the brown sugar and peaches.<br />
<br />
To this, pour over the mixed cake batter. <br />
<br />
Bake it per the instructions on the box for the pan you choose.<br />
<br />
I served with vanilla ice cream. I hope you enjoy.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjD2UYWWz-W0KSsTrAATjV0NvHBEUfNJRAPABRqi4kWOTkC4u4lZ8lBAJaRJrkjMn40HyMXW3IT6wlKFrcPupdwtzqOL0XkfLpoBupIwge12fMGbLmUHrD-wHNpIAnkpsUJxevLHhbwzKQ/s1600/peach+upsidedown+cake.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="294" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjD2UYWWz-W0KSsTrAATjV0NvHBEUfNJRAPABRqi4kWOTkC4u4lZ8lBAJaRJrkjMn40HyMXW3IT6wlKFrcPupdwtzqOL0XkfLpoBupIwge12fMGbLmUHrD-wHNpIAnkpsUJxevLHhbwzKQ/s320/peach+upsidedown+cake.jpg" width="320" /></a></div>
<br />
<br />
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif; font-size: 15px; line-height: 1.3;">If you like this post and want to see more, follow me on my website </span><a href="http://www.chadcompton.com/" style="font-family: "helvetica neue", arial, helvetica, sans-serif; font-size: 15px; line-height: 1.3;" target="_blank">www.chadcompton.com</a>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Or if you prefer...</span><br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://www.instagram.com/chad.compton/" rel="nofollow" target="_blank"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmQCxEy9yF84Atcay2V8TI_nhB995wFqyZWM7Fx0QJ20_zEwKT9Jhvg2HR_1uIc9cdU4IUa0lQiipbp8Abqx08OWvR6D0NCAGOUeBrMdSNonRUEtlcgVvEukik0mgbyEWRTQEm_n_fjSI/s1600/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" rel="nofollow" target="_blank"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWqsS7yzQIkqFImvtKvdAs1o5gLd4xtXg09dTFqhx2NGgkuZgRLILOQohw5Dz_GaLXQA-SsI-IdHcGMSjLhAEMhjwIOq9vnfErfz0Chl-Ywvpu_mVYRucGCKVf0_CmopxvaW4G6ZKvHz4/s1600/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" rel="nofollow" style="margin-left: 1em; margin-right: 1em;" target="_blank"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlcXt7epHaQv8JxCsc2hl-MOFuVrjwyhSNsxgf6ldjCOnv6mDJ0DWen1xnZ6yXunSC16cq_GoO3uZmsrh50ISgpxWenz-IdAbaThSXU6sZ-B2F43Z5v3O4AGEoBJAmlEq_dTvzCFFzKEY/s1600/twitter.png" /></a>
<a href="https://github.com/rccompton" rel="nofollow" target="_blank"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQWeOjAs82eU-ZufYCNQlWAq_MigNUQRG_emmekbDA9ardDrMoVxBlzKLTiSNfYHOgyFR8HENs8_diOlkQGmv4wzMJFTG1KRZWHTByE-xtRHQQ8a7Kw1afgwQQFSgZwxzKQeLobd8MvV8/s1600/GitHub.png" /></a>
<a href="https://bitbucket.org/ccompton/" rel="nofollow" target="_blank"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEik2PK3VZM0ypewu7zjboItNb1xwzModraS379j96hQVD8BJHu-Jc1yyTtFWb8wUFzl8zngPy8fnso9vO6Hp7ibjiHvyycbP9_e2zSBHftfMICI_T1HeuTt83bJsyZ7jngy5BH3VqabLJw/s1600/BitBucket.png" /></a></div>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0tag:blogger.com,1999:blog-4625247287479600024.post-23537549350363466922017-01-24T07:27:00.000-08:002017-04-06T08:01:55.865-07:00SQL DATEADD() Function<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgebKLRG2Fe_ojJkdRdfMWjN4lEhDzyR2EuWNjcEPcRZBuumwM0PfXv7kA6Nn2xAf7H3REgNw-rp7IVX-lbdCvf_Rdhk20S2SIQPrnyYlPr5Qc9I70pVQ3_tvovCuuQyEQZgurU9tOGB7E/s1600/24.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgebKLRG2Fe_ojJkdRdfMWjN4lEhDzyR2EuWNjcEPcRZBuumwM0PfXv7kA6Nn2xAf7H3REgNw-rp7IVX-lbdCvf_Rdhk20S2SIQPrnyYlPr5Qc9I70pVQ3_tvovCuuQyEQZgurU9tOGB7E/s320/24.png" width="320" /></a></div>
It has been quite a while since I have provided a tip for you guys/gals, but now I am back on the wagon. I will be posting on a regular basis. I have also decided to stop numbering the tips from this day forward. That being said...<br />
<br />
Yesterday I ran across a problem where I had to check to see if a certain file called 'Test' was received within the last two years. <br />
<br />
To accomplish this, I used the DATEADD() Function which adds or subtracts a specific time interval from a given date.<br />
<br />
<br />
<span style="background-color: white; color: #242729; font-family: "arial" , "helvetica neue" , "helvetica" , sans-serif; font-size: 15px;"><b>Syntax:</b></span><br />
<pre class="lang-sql prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; font-family: consolas, menlo, monaco, "lucida console", "liberation mono", "dejavu sans mono", "bitstream vera sans mono", "courier new", monospace, sans-serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><span style="color: blue;">
</span><div style="font-family: "Times New Roman"; font-size: medium; white-space: normal;">
<b style="color: blue;">DATEADD (datepart, number, date)</b></div>
<span style="color: blue;"><span class="pln" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;"><b>
</b></span></span></pre>
<h3 style="background-color: white; box-sizing: inherit; font-family: "Segoe UI", Arial, sans-serif; font-size: 24px; margin: 10px 0px;">
</h3>
<div>
The datepart can be broken down by year (yy, yyyy) , quarter (qq, q) , month (mm, m), dayofyear (dy, y), day (dd, d), week (wk, ww), weekday (dw, w), hour (hh), minute (mi, n), and second (ss, s) just to name a few.</div>
<br />
<span style="background-color: white; color: #242729; font-family: "arial" , "helvetica neue" , "helvetica" , sans-serif; font-size: 15px;"><b><br /></b></span>
<span style="background-color: white; color: #242729; font-family: "arial" , "helvetica neue" , "helvetica" , sans-serif; font-size: 15px;"><b>Example Code:</b></span><br />
<pre class="lang-sql prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; font-family: consolas, menlo, monaco, "lucida console", "liberation mono", "dejavu sans mono", "bitstream vera sans mono", "courier new", monospace, sans-serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><span style="color: blue;"><span class="kwd" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;">
</span></span><div style="font-family: "Times New Roman"; font-size: medium; white-space: normal;">
<span style="color: blue;"><b>Select * from Table where DocumentType = 'Test' </b></span></div>
<div style="font-family: "Times New Roman"; font-size: medium; white-space: normal;">
<span style="color: blue;"><b>and DateReceived >= DATEADD (yy, -2, GETDATE())</b></span></div>
<span style="color: blue;"><span class="pln" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;"><b>
</b></span></span></pre>
<span style="background-color: transparent; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif; font-size: 15px; line-height: 1.3;">If you like this post and want to see more, follow me on my website </span><a href="http://www.chadcompton.com/" style="background-color: transparent; font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif; font-size: 15px; line-height: 1.3;" target="_blank">www.chadcompton.com</a>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Or if you prefer...</span><br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://www.instagram.com/chad.compton/" rel="nofollow" target="_blank"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmQCxEy9yF84Atcay2V8TI_nhB995wFqyZWM7Fx0QJ20_zEwKT9Jhvg2HR_1uIc9cdU4IUa0lQiipbp8Abqx08OWvR6D0NCAGOUeBrMdSNonRUEtlcgVvEukik0mgbyEWRTQEm_n_fjSI/s1600/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" rel="nofollow" target="_blank"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWqsS7yzQIkqFImvtKvdAs1o5gLd4xtXg09dTFqhx2NGgkuZgRLILOQohw5Dz_GaLXQA-SsI-IdHcGMSjLhAEMhjwIOq9vnfErfz0Chl-Ywvpu_mVYRucGCKVf0_CmopxvaW4G6ZKvHz4/s1600/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" rel="nofollow" style="margin-left: 1em; margin-right: 1em;" target="_blank"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlcXt7epHaQv8JxCsc2hl-MOFuVrjwyhSNsxgf6ldjCOnv6mDJ0DWen1xnZ6yXunSC16cq_GoO3uZmsrh50ISgpxWenz-IdAbaThSXU6sZ-B2F43Z5v3O4AGEoBJAmlEq_dTvzCFFzKEY/s1600/twitter.png" /></a>
<a href="https://github.com/rccompton" rel="nofollow" target="_blank"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQWeOjAs82eU-ZufYCNQlWAq_MigNUQRG_emmekbDA9ardDrMoVxBlzKLTiSNfYHOgyFR8HENs8_diOlkQGmv4wzMJFTG1KRZWHTByE-xtRHQQ8a7Kw1afgwQQFSgZwxzKQeLobd8MvV8/s1600/GitHub.png" /></a>
<a href="https://bitbucket.org/ccompton/" rel="nofollow" target="_blank"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEik2PK3VZM0ypewu7zjboItNb1xwzModraS379j96hQVD8BJHu-Jc1yyTtFWb8wUFzl8zngPy8fnso9vO6Hp7ibjiHvyycbP9_e2zSBHftfMICI_T1HeuTt83bJsyZ7jngy5BH3VqabLJw/s1600/BitBucket.png" /></a></div>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0tag:blogger.com,1999:blog-4625247287479600024.post-59387285972814427412016-08-25T09:52:00.003-07:002016-08-25T09:52:43.549-07:00Update SQL Keep Characters to the Left<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhrdlHj-huUVSWrjNTXYz5HHl2CZMmO5SEBTyKvZO61JMtmpPZm3IHfeKQ1f8sxdaa_Y7H9MP-pVUDDPgce5oFKwFHCn2BhhSxDYE_3YEFZCfEnUXzYxGGLmH7KGiZJYNIBxMa2p2u7uJ0/s1600/24.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhrdlHj-huUVSWrjNTXYz5HHl2CZMmO5SEBTyKvZO61JMtmpPZm3IHfeKQ1f8sxdaa_Y7H9MP-pVUDDPgce5oFKwFHCn2BhhSxDYE_3YEFZCfEnUXzYxGGLmH7KGiZJYNIBxMa2p2u7uJ0/s320/24.png" width="320" /></a></div>
Today I ran across an issue with an SQL table that received an injection that inserted bad data at the end of certain fields in all of the records. I had to write some code that would find the bad data and strip it off of the end of the good data. After writing the code, I thought I would share with those interested. <br />
<br />
<b>Example:</b><br />
<br />
In this specific example, the tblNews table received a SQL Injection that inserted a long strand of bad data at the end of the Body field. Lucky for me, the Injections all started with '<div style='. That specific hunk of characters is what I used to track them all down. I first created a query to pull all the records to see what I was looking at. Then typed an Update statement that removed all the characters to right of '<div style='.<br />
<br />
<b>Initial Pull:</b><br />
<br />
<br />
<div style="line-height: 1.3;">
</div>
<br />
<pre class="lang-sql prettyprint prettyprinted" style="-webkit-text-stroke-width: 0px; background-color: #eff0f1; border: 0px; color: black; font-family: consolas, menlo, monaco, "lucida console", "liberation mono", "dejavu sans mono", "bitstream vera sans mono", "courier new", monospace, sans-serif; font-size: 13px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; line-height: normal; margin: 0px 0px 1em; max-height: 600px; orphans: 2; overflow: auto; padding: 5px; text-align: start; text-indent: 0px; text-transform: none; widows: 2; width: auto; word-spacing: 0px; word-wrap: normal;"><span style="color: blue;"><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px; white-space: inherit;">
<b>SELECT * from tblNews</b></span><b><span class="pln" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;">
</span><span class="pln" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;">where Body like '%<div style=%'</span></b><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px; white-space: inherit;"><b>
</b>
</span></span></pre>
<b>Update Code:</b><br />
<br />
<pre class="lang-sql prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; font-family: consolas, menlo, monaco, "lucida console", "liberation mono", "dejavu sans mono", "bitstream vera sans mono", "courier new", monospace, sans-serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><span style="color: blue;"><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px; white-space: inherit;">
<b>UPDATE tblNews</b></span><b><span class="pln" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;">
</span><span class="pln" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;">Set Body = LEFT (Body, CHARINDEX('<Div style=', Body) - 1)
where Body like '%<div style=%'</span></b><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px; white-space: inherit;"><b>
</b>
</span></span></pre>
<div style="line-height: 1.3;">
<br /></div>
<span style="background-color: transparent; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif; font-size: 15px; line-height: 1.3;">If you like this post and want to see more, follow me on my website </span><a href="http://www.chadcompton.com/" style="background-color: transparent; font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif; font-size: 15px; line-height: 1.3;" target="_blank">www.chadcompton.com</a>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Or if you prefer...</span><br />
<a href="http://www.instagram.com/chad.compton" target="_blank"><img src="http://www.chadcompton.com/images/social/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" target="_blank"><img src="http://www.chadcompton.com/images/social/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/twitter.png" /></a>
<a href="https://github.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/github.png" /></a>
<a href="https://bitbucket.org/ccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/bitbucket.png" /></a>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0tag:blogger.com,1999:blog-4625247287479600024.post-87069114673413503022016-06-28T06:00:00.000-07:002016-06-28T06:00:58.192-07:00Concatenate 2 Integers Into 1 Varchar (SQL)<div style="background-color: white; border: 0px; clear: both; color: #242729; font-family: Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 15px; line-height: 19.5px; margin-bottom: 1em; padding: 0px;">
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjj5AjHZh4kq9b18y4lZ_cH0LjfVQ0bl6xOcpkLxierhVQe0jugXJ__JiwU-SYxuNH55FsgDhwv5IOgWJy5hntbrSGzqiCVbQsJn9SVlqv-vyrXNke0se9Y9sA4JCZ2ngHQY3gZ0jM5aoI/s1600/23.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjj5AjHZh4kq9b18y4lZ_cH0LjfVQ0bl6xOcpkLxierhVQe0jugXJ__JiwU-SYxuNH55FsgDhwv5IOgWJy5hntbrSGzqiCVbQsJn9SVlqv-vyrXNke0se9Y9sA4JCZ2ngHQY3gZ0jM5aoI/s320/23.png" width="320" /></a></div>
Yesterdays Just A Tip Felt so good, I thought I would do it again today. Twice in one week. You guys & gals get a great tip, while I get another notch under my belt. Win. Win. <br /><br />Today's coding issue involves 2 Integer fields that need to be concatenated into 1 big field and that field needs to be Varchar. To accomplish this, you will need to Cast each Integer as a Varchar then concatenate them.</div>
<div style="background-color: white; border: 0px; clear: both; font-family: arial, "helvetica neue", helvetica, sans-serif; font-size: 15px; line-height: 19.5px; margin-bottom: 1em; padding: 0px;">
<div style="color: #242729;">
For Example, in an SQL table called tblPetOwners you have 2 fields (OwnerNumber & PetNumber) which are Integers and wish to join them with an '&' in between them. To do this, you have to CAST them both as Varchar before concatenating them. Below is the best way I have came across to accomplish this task and I show you the data in the table, the code itself, followed by the results.</div>
<div style="color: #242729;">
<br /></div>
<div style="color: #242729;">
Table tblPetOwners Data:</div>
<div style="color: #242729;">
<br /></div>
<div style="color: #242729;">
</div>
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 1.3; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
</div>
<br />
<pre class="lang-sql prettyprint prettyprinted" style="-webkit-text-stroke-width: 0px; background-color: #eff0f1; border: 0px; color: black; font-family: consolas, menlo, monaco, "lucida console", "liberation mono", "dejavu sans mono", "bitstream vera sans mono", "courier new", monospace, sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; margin: 0px 0px 1em; max-height: 600px; orphans: auto; overflow: auto; padding: 5px; text-align: start; text-indent: 0px; text-transform: none; widows: 1; width: auto; word-spacing: 0px; word-wrap: normal;"><table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; color: #242729; font-family: arial, "helvetica neue", helvetica, sans-serif; width: 232px;"><colgroup><col style="width: 71pt;" width="94"></col><col style="width: 55pt;" width="74"></col><col style="width: 48pt;" width="64"></col></colgroup><tbody>
<tr height="19" style="height: 14.4pt;"><td class="xl65" colspan="2" height="19" style="height: 14.4pt; width: 126pt;" width="168"><u><b><span style="color: blue;">OwnerNumber</span></b></u></td><td class="xl65" style="width: 48pt;" width="64"><span style="color: blue;"><b><u>PetNumber</u></b></span></td></tr>
<tr height="19" style="height: 14.4pt;"><td align="right" height="19" style="height: 14.4pt;">223122</td><td></td><td align="right">543224</td></tr>
<tr height="19" style="height: 14.4pt;"><td align="right" height="19" style="height: 14.4pt;">643233</td><td></td><td align="right">235432</td></tr>
<tr height="19" style="height: 14.4pt;"><td align="right" height="19" style="height: 14.4pt;">332342</td><td></td><td align="right">654523</td></tr>
</tbody></table>
<span style="color: blue;"><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px; white-space: inherit;">
</span></span></pre>
</div>
<div style="background-color: white; border: 0px; clear: both; color: #242729; font-family: Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 15px; line-height: 19.5px; margin-bottom: 1em; padding: 0px;">
Example Code:</div>
<pre class="lang-sql prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; font-family: consolas, menlo, monaco, "lucida console", "liberation mono", "dejavu sans mono", "bitstream vera sans mono", "courier new", monospace, sans-serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><span style="color: blue;"><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px; white-space: inherit;">
<b>SELECT</b></span><b><span class="pln" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;"> CAST</span><span class="pun" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;">(OwnerNumber</span><span class="pln" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;"> </span><span class="kwd" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;">AS</span><span class="pln" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;"> VARCHAR</span><span class="pun" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;">(</span><span class="lit" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;">10</span><span class="pun" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;">)</span><span class="pln" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;"> </span><span class="pun" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;">)</span><span class="pln" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;">
</span><span class="pun" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;">+ </span><span class="str" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;">' & ' </span><span class="pun" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;">+</span><span class="pln" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;">
CAST</span><span class="pun" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;">(PetNumber</span><span class="pln" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;"> </span><span class="kwd" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;">AS</span><span class="pln" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;"> VARCHAR</span><span class="pun" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;">(</span><span class="lit" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;">10</span><span class="pun" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;">)</span><span class="pln" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;"> </span><span class="pun" style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;">)</span></b><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px; white-space: inherit;"><b> OwnerAndPet, OwnerNumber, PetNumber
FROM tblPetOwners
</b>
</span></span></pre>
<div style="line-height: 1.3;">
<span style="background-color: transparent; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif; font-size: 15px; line-height: 1.3;"><br />Results Data:</span><br />
<span style="background-color: transparent; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif; font-size: 15px; line-height: 1.3;"><br /></span>
<pre class="lang-sql prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; font-family: consolas, menlo, monaco, "lucida console", "liberation mono", "dejavu sans mono", "bitstream vera sans mono", "courier new", monospace, sans-serif; font-size: 13px; line-height: normal; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; font-family: "Times New Roman"; width: 457px;"><colgroup><col style="width: 143pt;" width="191"></col><col style="width: 55pt;" width="74"></col><col span="3" style="width: 48pt;" width="64"></col></colgroup><tbody>
<tr height="19" style="height: 14.4pt;"><td height="19" style="height: 14.4pt; width: 143pt;" width="191"><u style="color: #242729; font-family: arial, "helvetica neue", helvetica, sans-serif;"><b><span style="color: blue;">OwnerAndPet</span></b></u></td><td style="width: 55pt;" width="74"></td><td class="xl65" colspan="2" style="width: 96pt;" width="128"><u style="color: #242729; font-family: arial, "helvetica neue", helvetica, sans-serif;"><b><span style="color: blue;">OwnerNumber</span></b></u></td><td class="xl65" style="width: 48pt;" width="64"><u style="color: #242729; font-family: arial, "helvetica neue", helvetica, sans-serif;"><b><span style="color: blue;">PetNumber</span></b></u></td></tr>
<tr height="19" style="height: 14.4pt;"><td height="19" style="height: 14.4pt;">223122 & 543224</td><td></td><td align="right">223122</td><td></td><td align="right">543224</td></tr>
<tr height="19" style="height: 14.4pt;"><td height="19" style="height: 14.4pt;">643233 & 235432</td><td></td><td align="right">643233</td><td></td><td align="right">235432</td></tr>
<tr height="19" style="height: 14.4pt;"><td height="19" style="height: 14.4pt;">332342 & 654523</td><td></td><td align="right">332342</td><td></td><td align="right">654523
</td></tr>
</tbody></table>
</pre>
<div>
<br /></div>
<span style="background-color: transparent; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif; font-size: 15px; line-height: 1.3;">If you like this post and want to see more, follow me on my website </span><a href="http://www.chadcompton.com/" style="background-color: transparent; font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif; font-size: 15px; line-height: 1.3;" target="_blank">www.chadcompton.com</a></div>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Or if you prefer...</span><br />
<a href="http://www.instagram.com/chad.compton" target="_blank"><img src="http://www.chadcompton.com/images/social/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" target="_blank"><img src="http://www.chadcompton.com/images/social/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/twitter.png" /></a>
<a href="https://github.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/github.png" /></a>
<a href="https://bitbucket.org/ccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/bitbucket.png" /></a>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0tag:blogger.com,1999:blog-4625247287479600024.post-72759217562743715202016-06-27T07:48:00.002-07:002016-06-27T08:08:08.992-07:00Union & Count Together in A SQL Query<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxpiFt_UtcdMCaumrGYP7Uy7M3bXpATSMNvGRRGf4a21tELVwQM3_jHtep9TVU2yfxTFkUW-QD9XeqlcxRWAVxu5RTLq7P_1DZXYy_zd_SC9PmdyHgt0yrTdyrfPAvx-_Y9OPMKiCAxBE/s1600/22.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxpiFt_UtcdMCaumrGYP7Uy7M3bXpATSMNvGRRGf4a21tELVwQM3_jHtep9TVU2yfxTFkUW-QD9XeqlcxRWAVxu5RTLq7P_1DZXYy_zd_SC9PmdyHgt0yrTdyrfPAvx-_Y9OPMKiCAxBE/s320/22.png" width="320" /></a></div>
I know it has been a while since I have given you a good tip...So without further ado.<br />
<br />
Today I had a situation where I needed to give a count of items that were across a couple of tables and involved a few unions in SQL. Since my query took up about 2 pages, I figured I would make a simple version for all you folks out there reading this. I hope it helps.<br />
<br />
For Example, let us say you have two tables ( Results & ArchivedResults) and were needing to get a count on them both. Let us also assume you didn't use a JOIN because of the different criteria in each SQL statement. Based off those results you need to get a count. Below is how this can be accomplished.<br />
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 15px; line-height: 21.4286px; margin-bottom: 10.5px;">
<br />
Example Code:</div>
<pre class="notranslate" style="background: rgb(242, 241, 255); border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: normal; word-wrap: break-word;"><span style="color: #333333; font-family: "menlo" , "monaco" , "consolas" , "courier new" , monospace;"><span style="line-height: 18.5714px; white-space: pre-wrap;">SELECT PullResults.Name, COUNT(*)
FROM (SELECT Name FROM Results
UNION ALL
SELECT Name FROM ArchivedResults) as PullResults
GROUP BY Name
ORDER BY Name</span></span></pre>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 15px; line-height: 21.4286px; margin-bottom: 10.5px;">
<br /></div>
<div style="line-height: 1.3;">
<span style="background-color: transparent; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif; font-size: 15px; line-height: 1.3;">If you like this post and want to see more, follow me on my website </span><a href="http://www.chadcompton.com/" style="background-color: transparent; font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif; font-size: 15px; line-height: 1.3;" target="_blank">www.chadcompton.com</a></div>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Or if you prefer...</span><br />
<a href="http://www.instagram.com/chad.compton" target="_blank"><img src="http://www.chadcompton.com/images/social/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" target="_blank"><img src="http://www.chadcompton.com/images/social/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/twitter.png" /></a>
<a href="https://github.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/github.png" /></a>
<a href="https://bitbucket.org/ccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/bitbucket.png" /></a>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0tag:blogger.com,1999:blog-4625247287479600024.post-89057920808785445702016-05-24T14:14:00.001-07:002016-05-24T14:14:27.658-07:00SUM Using Group By (SQL)<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjA36ssRw2Brit2IgADPGTy0mEZ31hVvrOmIPXw415ZHU0uN1ZDgqFoESEcDrOFK_Kp0Z9l6b2MvDWMePDAwBrXjLKImjyTLHJy-U0daq5jF8OCBoExTjFwoZEBNI5czDjatcQ_mNG9po0/s1600/20jat.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjA36ssRw2Brit2IgADPGTy0mEZ31hVvrOmIPXw415ZHU0uN1ZDgqFoESEcDrOFK_Kp0Z9l6b2MvDWMePDAwBrXjLKImjyTLHJy-U0daq5jF8OCBoExTjFwoZEBNI5czDjatcQ_mNG9po0/s320/20jat.png" width="320" /></a>
<br />
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 21.4286px; margin-bottom: 10.5px;">
At some point, you will be required to use the <a href="http://www.techonthenet.com/sql/group_by.php" style="background-color: transparent; box-sizing: border-box; color: #336699; text-decoration: none;">SQL GROUP BY clause</a> with the SQL SUM function. My time to use this was today and I thought I would create this post to help anyone else that may be needing to accomplish the same.</div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 21.4286px; margin-bottom: 10.5px;">
For example, you could also use the SQL SUM function to return the name of the department and the total sales (in the associated department).<br />
<br />
Example Code:</div>
<pre class="notranslate" style="background: rgb(242, 241, 255); border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 13px; line-height: 1.42857; margin-bottom: 10.5px; overflow: auto; padding: 10px; white-space: pre-wrap; word-break: normal; word-wrap: break-word;">SELECT department, SUM(sales) AS "Total sales"
FROM order_details
GROUP BY department;</pre>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 21.4286px; margin-bottom: 10.5px;">
Because you have listed one column in your <a href="http://www.techonthenet.com/sql/select.php" style="background-color: transparent; box-sizing: border-box; color: #336699; text-decoration: none;">SQL SELECT statement</a> that is not encapsulated in the SQL SUM function, you must use the <a href="http://www.techonthenet.com/sql/group_by.php" style="background-color: transparent; box-sizing: border-box; color: #336699; text-decoration: none;">SQL GROUP BY clause</a>. The department field must, therefore, be listed in the SQL GROUP BY section.</div>
<div style="line-height: 1.3;">
<span style="background-color: transparent; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif; font-size: 15px; line-height: 1.3;">If you like this post and want to see more, follow me on my website </span><a href="http://www.chadcompton.com/" style="background-color: transparent; font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif; font-size: 15px; line-height: 1.3;" target="_blank">www.chadcompton.com</a></div>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Or if you prefer...</span><br />
<a href="http://www.instagram.com/chad.compton" target="_blank"><img src="http://www.chadcompton.com/images/social/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" target="_blank"><img src="http://www.chadcompton.com/images/social/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/twitter.png" /></a>
<a href="https://github.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/github.png" /></a>
<a href="https://bitbucket.org/ccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/bitbucket.png" /></a>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0tag:blogger.com,1999:blog-4625247287479600024.post-22204728274024752532016-04-26T08:30:00.001-07:002016-04-26T08:30:53.872-07:00AVG Function (SQL)<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8VotxpMd7qQHPvSclgXpquO9CrCzjN6A3yApTyF4qO43ABpMs4s_UBehJ08Nn0fTEnDypy7T76NOiTk_1zNwp6yBabYbgY-Hn6H5aObY7Tfp8fOABo2tK49IqhKahGFoJlnq_jew1FWs/s1600/21jat.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8VotxpMd7qQHPvSclgXpquO9CrCzjN6A3yApTyF4qO43ABpMs4s_UBehJ08Nn0fTEnDypy7T76NOiTk_1zNwp6yBabYbgY-Hn6H5aObY7Tfp8fOABo2tK49IqhKahGFoJlnq_jew1FWs/s320/21jat.png" width="320" /></a></div>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Over the last couple of coding posts I have showed you how to use the SUM function. This being said, I thought I would show you how to use the AVE function in SQL. </span><br />
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"></span><br />
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Use the AVG() Function to get the average of a of a specific numeric column. Below is an example of it being used.</span><br />
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><b>SQL AVG Example:</b></span><br />
<div class="post-text" itemprop="text" style="background-color: white; border: 0px; line-height: 1.3; margin: 0px 0px 5px; padding: 0px; width: 560px; word-wrap: break-word;">
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; clear: both; margin-bottom: 1em; padding: 0px;">
<div style="color: #222222;">
<br /></div>
<pre class="lang-sql prettyprint prettyprinted" style="-webkit-text-stroke-width: 0px; background-color: #eeeeee; border: 0px; color: #393318; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; margin: 0px 0px 1em; max-height: 600px; orphans: auto; overflow: auto; padding: 5px; text-align: start; text-indent: 0px; text-transform: none; widows: 1; width: auto; word-spacing: 0px; word-wrap: normal;"><code style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px; white-space: inherit;"><span style="color: blue; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><b><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">
SELECT AVG</span><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">(</span><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">ColumnName)
</span><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">FROM</span><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;"> </span><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">TableName;
</span><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">
</span></b></span></code></pre>
<div style="color: #222222;">
<br />
<div style="line-height: 1.3;">
<span style="background-color: transparent; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif; font-size: 15px; line-height: 1.3;">If you like this post and want to see more, follow me on my website </span><a href="http://www.chadcompton.com/" style="background-color: transparent; font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif; font-size: 15px; line-height: 1.3;" target="_blank">www.chadcompton.com</a></div>
</div>
</div>
</div>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Or if you prefer...</span><br />
<a href="http://www.instagram.com/chad.compton" target="_blank"><img src="http://www.chadcompton.com/images/social/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" target="_blank"><img src="http://www.chadcompton.com/images/social/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/twitter.png" /></a>
<a href="https://github.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/github.png" /></a>
<a href="https://bitbucket.org/ccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/bitbucket.png" /></a>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0tag:blogger.com,1999:blog-4625247287479600024.post-74686705920672577212016-04-06T10:25:00.005-07:002016-04-06T12:53:51.434-07:00Markers Mark Tour<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDpoTaXUQSgSjrpXEOM5pdYO5otEeYRPtcaJqOllOl4IIgvthIpCuQ1w6aC_HVUmUYTHI-VktXS7AxIx7zPZZ0la2UwxAhw-2WtkRES-V-wLVwPylowtGONo9f-YYTpSEsaGLjljyn928/s1600/MakersMarkTour.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="213" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDpoTaXUQSgSjrpXEOM5pdYO5otEeYRPtcaJqOllOl4IIgvthIpCuQ1w6aC_HVUmUYTHI-VktXS7AxIx7zPZZ0la2UwxAhw-2WtkRES-V-wLVwPylowtGONo9f-YYTpSEsaGLjljyn928/s320/MakersMarkTour.png" width="320" /></a></div>
<b style="color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 17.9999px;">Please Note this tour was done with <a href="http://www.yelp.com/" target="_blank">YELP</a> of Lexington, therefore your experience will not be exactly the same. </b><br />
<b style="color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 17.9999px;"><br /></b>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgc2sdejU3GdDkyAPP55JQyuJBUyItHLOe47CtXyNgqZJQReKZvb9pOFDXCtSa0tbNrrQ9he7poFXn1fda_xVd8sv0kM-Kh3YHIb9rnfQmJodKz4Ln-KaEG28hPnkkw5ZPY71twAnHBpT0/s1600/22.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="177" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgc2sdejU3GdDkyAPP55JQyuJBUyItHLOe47CtXyNgqZJQReKZvb9pOFDXCtSa0tbNrrQ9he7poFXn1fda_xVd8sv0kM-Kh3YHIb9rnfQmJodKz4Ln-KaEG28hPnkkw5ZPY71twAnHBpT0/s320/22.jpg" width="320" /></a><br />
<span style="background-color: white; color: #333333; font-family: "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 17.9999px;">This was an Official Yelp Event (OYE) put on by Heather P our Lexington's Great Yelp Community Ambassador. I swear these events keep getting better and better.</span><br />
<span style="background-color: white; color: #333333; font-family: "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 17.9999px;"></span><br />
<span style="line-height: 17.9999px;">This specific event started out with a meet up in Isle 35 at Keenland where we were greeted with Bloody Marks (aka bloody mary's made with good old Makers Mark) and North Limestone Doughnuts provided by Jacklyn E., our lovely tour guide from <a href="https://www.makersmark.com/" target="_blank">Makers Mark</a>. This was truly a perfect tailgate breakfast before we hopped on the <a href="http://mintjuleptours.com/" target="_blank">Mint Julep Tour</a> bus and were on our way to Loretto, the home of <a href="https://www.makersmark.com/" target="_blank">Maker's Mark Distillery</a>. </span><br />
<span style="line-height: 17.9999px;"><br /></span>
<span style="background-color: white; color: #333333; font-family: "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 17.9999px;">The trip itself was mostly through the beautiful country side down small winding roads most of which is part of the Kentucky Bourbon Trail. <a href="http://mintjuleptours.com/" target="_blank"> Mint Julep Tours</a> provided us with a great driver and the perfect tour guide leader (Bob and John). They pointed out great tid bits and facts about the local area as we drove through the small towns. They also pointed out great destination places along the way, like the man with 500+ riding lawn mowers outside his house. I have to admit as a geeky road trip kid, that was a great stop. lol. We also learned about bourbon on the way with the help of Jacklyn. Great facts before we even got to <a href="https://www.makersmark.com/" target="_blank">Maker's Mark</a>.</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjLMVZ0SUju5pLDbJtFv2j416TVn_m88RNrrl8LBXc9zGC-w7R2BjkZjQZ22v6COhx_CV2MZ_TDEYURquoFSVSHeEdl_SD_FWXpWJFiN9qumZmO0WKOHa0MMPqvEOVwntkeCq7SGkNuKs/s1600/19.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjLMVZ0SUju5pLDbJtFv2j416TVn_m88RNrrl8LBXc9zGC-w7R2BjkZjQZ22v6COhx_CV2MZ_TDEYURquoFSVSHeEdl_SD_FWXpWJFiN9qumZmO0WKOHa0MMPqvEOVwntkeCq7SGkNuKs/s320/19.jpg" width="179" /></a></div>
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 17.9999px;" />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1_sq8buZKR6o5eJnTZ7gPsprRPOlxRJ7qNtRcT-quQCWtzdMcEyE94CswtHHF2pAOovI4oZFdl4Zfofs2mwi1SSKMO-7rzc8EqYQC6tu56a3T-lY-J2sWxMqy7MjhlP1bwyTve6FvF4I/s1600/20160218_105709.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="112" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1_sq8buZKR6o5eJnTZ7gPsprRPOlxRJ7qNtRcT-quQCWtzdMcEyE94CswtHHF2pAOovI4oZFdl4Zfofs2mwi1SSKMO-7rzc8EqYQC6tu56a3T-lY-J2sWxMqy7MjhlP1bwyTve6FvF4I/s200/20160218_105709.jpg" width="200" /></a><span style="background-color: white; color: #333333; font-family: "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 17.9999px;">Once we arrived at <a href="https://www.makersmark.com/" target="_blank">Maker's Mark Distillery</a>, we grabbed some tasty Maker's Mark Bourbon Coffee and started our Distillery tour. This is where Jacklyn shined. She was so knowledgeable of Maker's Mark history and the bourbon making process, it was amazing. Being on a special tour, we got to go into a couple buildings that most tours will not allow. The actually Distilling Building was one and the Quality Control Area was the other. </span><br />
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 17.9999px;" />
<span style="background-color: white; color: #333333; font-family: "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 17.9999px;">In the Distilling Building, we got to see the mill that does all the corn and grain grinding for every batch of bourbon that gets made. We got to see and taste the 1 day mash that was bubbly and sweet (Odd I know). Then sampled one that was more bitter and corny (BLAH), video proof below. We saw the White dogs which is the liquid at 120 and 130 proof which we also got to sample. Be aware this isn't on the normal tours. </span><br />
<span style="background-color: white; color: #333333; font-family: "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 17.9999px;">Next room was the labeling building. Every label on every bottle is printed and then cut on an old repurposed printing press. This cutter only cuts a max of 4 sheets at a time. A time consuming process but well worth the effort.</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgt7v65UPm_S2WwRPiEvEq4zgzHJ8fPDyCIqNPLCqfXp-Gi77cU3rjOW5Syyxz2mZgBE0TpVl9D4Ei7V_BJ3OwE8Fk8e8Rm8uv0AraI_BTJLHE9UehDvWuLdLOB2T9gyUQoSicwhD4EEfU/s1600/2.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgt7v65UPm_S2WwRPiEvEq4zgzHJ8fPDyCIqNPLCqfXp-Gi77cU3rjOW5Syyxz2mZgBE0TpVl9D4Ei7V_BJ3OwE8Fk8e8Rm8uv0AraI_BTJLHE9UehDvWuLdLOB2T9gyUQoSicwhD4EEfU/s320/2.jpg" width="320" /></a></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-nY6ltoiAIc1mkQk_Yjdo4p1DiK5nWSZWtj2vpO6V_8-yw4SiQlzNEkAvH3bnex4xwcCQdWWOO-jet1Onvb0rH5p6myWCU-jtFyvCXF8MWN4DjM_azToep-TBexC23QqHSUrxPKUkE40/s1600/20160218_112440.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-nY6ltoiAIc1mkQk_Yjdo4p1DiK5nWSZWtj2vpO6V_8-yw4SiQlzNEkAvH3bnex4xwcCQdWWOO-jet1Onvb0rH5p6myWCU-jtFyvCXF8MWN4DjM_azToep-TBexC23QqHSUrxPKUkE40/s200/20160218_112440.jpg" width="112" /></a><br />
<span style="background-color: white; color: #333333; font-family: "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 17.9999px;">The super secret Quality Control Building was next. These ladies in here are like CSI of the booze world. Very impressive. They do samplings of all the batches at many stages of the process. They also keep one bottle of every batch for referencing. They have 25 workers that sniff, sip and sample bourbon every morning. Those lucky people. What a job. This was also the place where Maker's 46 was invented. </span><br />
<span style="background-color: white; color: #333333; font-family: "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 17.9999px;">The storage barn was next. There we got to see the inside of a barrel and learned how the rotate the casts manually by hand from upper levels of the barn to the lower level. They don't use climate control facilities here. It takes average of 6 years or so to get the flavor profile that makes Maker's Mark so special. There isn't an exact day per say, the bourbon will tell them when its ready by its flavor. At that point is is diluted with their distilled water to get the proof they require. Unless you are lucky enough to buy Straight Cast (like I did). </span><br />
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 17.9999px;" />
<span style="background-color: white; color: #333333; font-family: "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 17.9999px;">The Bottling/Dipping building was next stop on our tour, a few of the videos are listed below. There we saw the empty bottles move from cleaning to filling and sealing. Then hand dipped in the signature red wax after the label has been slapped on. It was a fancier version of the beer scene from Lavern and Shirley opening scene. It was really impressive. </span><br />
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 17.9999px;" />
<span style="background-color: white; color: #333333; font-family: "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 17.9999px;">Then we arrived at the tasting room. Here we got to sample 5 different bourbons (2 which aren't normally on the tastings). Under Mature, Fully Mature, Over Mature, Maker's 46, Cast Straight. Jacklyn rocked out here as well. She explained to us how we should sniff the bourbons before sipping. Basically how to experience bourbon with all our senses. I loved it. Each bourbon tasted like bourbon, but had different hints of flavors and smells. Pretty neat. They gave us Maker's Mark distilled water also. WHO KNEW? Freakin Water from their Super Secret Limestone Lake. </span><br />
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 17.9999px;" />
<span style="background-color: white; color: #333333; font-family: "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 17.9999px;">Next we helped our selves to Bourbon Balls as we walked into the Beautiful hall filled with hand blown glass made by Stephen Rolfe Powell. It is so beautiful. Hundreds of unique, brightly colored glass lines this ceiling in this hall way. So stunning. There are also hidden angels in here as well. I forgot what their meaning was.</span><br />
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 17.9999px;" />
<span style="background-color: white; color: #333333; font-family: "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 17.9999px;">The gift shop was the last stop on our Maker's Mark Distillery Tour. We were given a bottle of Maker's and got all gussied up and were able to dip our own bottles in the signature red wax. Such a great experience. Here we also shopped and bought other goodies. I got Round Ice trays and Maker's 46 Straight Cast (which I also got to dip).</span><br />
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 17.9999px;" />
<span style="background-color: white; color: #333333; font-family: "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 17.9999px;">Then we hopped on the bus and headed home. Lunch boxes provided by Joe's Deli. (no more room) Thanks ALL. Keep a look out for my next article about touring Wild Turkey.</span><br />
<span style="background-color: white; color: #333333; font-family: "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 17.9999px;"><b><br /></b></span>
<span style="color: #333333; font-family: "helvetica neue" , "helvetica" , "arial" , sans-serif;"><span style="background-color: white; font-size: 14px; line-height: 17.9999px;"><b>Video Snipits:</b></span></span><br />
<iframe allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/-tvjzBjbsNY" width="560"></iframe>
<iframe allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/AQzU8JXnc0U" width="560"></iframe>
<iframe allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/83__76y95_o" width="560"></iframe>
<iframe allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/rkJE8NeaCoE" width="560"></iframe>
<iframe allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/6HgsU7ERHuM" width="560"></iframe>
<iframe allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/sOIAuW95tj8" width="560"></iframe>
<iframe allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/_y2L5P5yxNo" width="560"></iframe>
<span style="color: #333333; font-family: "helvetica neue" , "helvetica" , "arial" , sans-serif;"><span style="background-color: white; font-size: 14px; line-height: 17.9999px;"><br /></span></span>
<span style="background-color: white; color: #333333; font-family: "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 17.9999px;"><br /></span>
<span style="color: #333333; font-family: "helvetica neue" , "helvetica" , "arial" , sans-serif;"><span style="background-color: white; font-size: 14px; line-height: 17.9999px;">
<b>Random Pictures Below:</b></span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuFyidE5H_5kb78_U_5fSG0P6ZJ-W5q36mQgiLcnp4TKmrwzy94DjjRVbjNnTkwrUHSXZLYkc4lj96yOwNE2-Gec1oFJOsJm95nMegIJAMEcsA2WHT7RDnVImarM5LDF0O8sS8ZxtzJQ0/s1600/25.jpg" imageanchor="1"><img border="0" height="111" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuFyidE5H_5kb78_U_5fSG0P6ZJ-W5q36mQgiLcnp4TKmrwzy94DjjRVbjNnTkwrUHSXZLYkc4lj96yOwNE2-Gec1oFJOsJm95nMegIJAMEcsA2WHT7RDnVImarM5LDF0O8sS8ZxtzJQ0/s200/25.jpg" width="200" /></a>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmun6jH3gtmguSOei_fM_UY6TFXsLKs81sp89SQyKDJ4fZ0WDGp8oVFx6XlkdjK8tRE4dsnkIK3mTvSvR6sj07qmA6JcZZZfxTBNvCenfAlsau-GRwkK5bHqYKwP6GzlYXN9zNNJMw6WQ/s1600/20160218_103406.jpg" imageanchor="1">
<img border="0" height="112" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmun6jH3gtmguSOei_fM_UY6TFXsLKs81sp89SQyKDJ4fZ0WDGp8oVFx6XlkdjK8tRE4dsnkIK3mTvSvR6sj07qmA6JcZZZfxTBNvCenfAlsau-GRwkK5bHqYKwP6GzlYXN9zNNJMw6WQ/s200/20160218_103406.jpg" width="200" /></a>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsDsFL9uA9JpxWC_ePAMsCy4__1XbUSDb5NreAtg5lyC3-u2hZ_acC-sJoEvwlDcNcaUxIDgZNYY1TQGIr9YlKRWsso_0q5cDG7dODJdCx6rNho28RedChH9_kz6L-c2gQOhMJfS2oR18/s1600/20160218_110924.jpg" imageanchor="1"><img border="0" height="112" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsDsFL9uA9JpxWC_ePAMsCy4__1XbUSDb5NreAtg5lyC3-u2hZ_acC-sJoEvwlDcNcaUxIDgZNYY1TQGIr9YlKRWsso_0q5cDG7dODJdCx6rNho28RedChH9_kz6L-c2gQOhMJfS2oR18/s200/20160218_110924.jpg" width="200" /></a></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgU6xT5qHRUxVLS8pNixIbZOj5zClvGeOJk5NfN1sudlK0zbiDmeRSyt6d1X1OW77lYfLFQBKgLjNN2PujQSZ-u4QRLB_a1Hc_mlmTmwxZ0Es6uFHnUI5alf8J_I-7dEQRaQrfalQPn-88/s1600/20160218_115847.jpg" imageanchor="1">
<img border="0" height="112" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgU6xT5qHRUxVLS8pNixIbZOj5zClvGeOJk5NfN1sudlK0zbiDmeRSyt6d1X1OW77lYfLFQBKgLjNN2PujQSZ-u4QRLB_a1Hc_mlmTmwxZ0Es6uFHnUI5alf8J_I-7dEQRaQrfalQPn-88/s200/20160218_115847.jpg" width="200" /></a>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOn7qLHddGyJX7T3hLxDgJmWIiFPeGt65Mb5PfUB8Pghrg8meztLpmiGZqOa8z_JIQ6MMF87NKwYQ8IvO5aLCDi3VjWKIVvyv4W9NkAkRoY955_V4AlJw0Gzc5XCeRxrV6Fy7Hums1iPg/s1600/20160218_122023.jpg" imageanchor="1">
<img border="0" height="112" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOn7qLHddGyJX7T3hLxDgJmWIiFPeGt65Mb5PfUB8Pghrg8meztLpmiGZqOa8z_JIQ6MMF87NKwYQ8IvO5aLCDi3VjWKIVvyv4W9NkAkRoY955_V4AlJw0Gzc5XCeRxrV6Fy7Hums1iPg/s200/20160218_122023.jpg" width="200" /></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyRp1gg28-5FfDNsjdqDGOMcLwcewelgyV-nmh8xyQjFaRGwFJC3d03bahn9pG_ZIqGba4OEpUB7rapOepfQ4gyeiKBDB6c2FlTzbX-snBILk0jM57VxtUOVyxjMVEALIxczOXRnnea88/s1600/20160218_114954.jpg" imageanchor="1">
<img border="0" height="112" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyRp1gg28-5FfDNsjdqDGOMcLwcewelgyV-nmh8xyQjFaRGwFJC3d03bahn9pG_ZIqGba4OEpUB7rapOepfQ4gyeiKBDB6c2FlTzbX-snBILk0jM57VxtUOVyxjMVEALIxczOXRnnea88/s200/20160218_114954.jpg" width="200" /></a>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBGjNcQ7lFecbhBeQifNyKBl68eMW7i3rDDhywIUjXj52fYdDhT_-zS7XUhwo9LsZIbW1uKLUterheuTb9iXy34kiIjJIyZ7B0_FZSfvEmW_itKccQtZmNGV04g5hBdPqBeLEwB0Br9t0/s1600/20160218_104333.jpg" imageanchor="1"> <img border="0" height="112" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBGjNcQ7lFecbhBeQifNyKBl68eMW7i3rDDhywIUjXj52fYdDhT_-zS7XUhwo9LsZIbW1uKLUterheuTb9iXy34kiIjJIyZ7B0_FZSfvEmW_itKccQtZmNGV04g5hBdPqBeLEwB0Br9t0/s200/20160218_104333.jpg" width="200" /> </a>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhy1HJOw_nKUpJpgthrMnXT6DkTHjV74eGRlWvBB-mu9sBxDGW-lfWLU9xQm0bgKFJBgCOvi38I51fpKyjySPhirVSnjqpWUgZE9-ETrz3OBePipaC2c8-nMOjGqzXkQ32zBw49Eun0emk/s1600/20160218_104704.jpg" imageanchor="1"><img border="0" height="112" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhy1HJOw_nKUpJpgthrMnXT6DkTHjV74eGRlWvBB-mu9sBxDGW-lfWLU9xQm0bgKFJBgCOvi38I51fpKyjySPhirVSnjqpWUgZE9-ETrz3OBePipaC2c8-nMOjGqzXkQ32zBw49Eun0emk/s200/20160218_104704.jpg" width="200" /></a>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmun6jH3gtmguSOei_fM_UY6TFXsLKs81sp89SQyKDJ4fZ0WDGp8oVFx6XlkdjK8tRE4dsnkIK3mTvSvR6sj07qmA6JcZZZfxTBNvCenfAlsau-GRwkK5bHqYKwP6GzlYXN9zNNJMw6WQ/s1600/20160218_103406.jpg" imageanchor="1"></a>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmun6jH3gtmguSOei_fM_UY6TFXsLKs81sp89SQyKDJ4fZ0WDGp8oVFx6XlkdjK8tRE4dsnkIK3mTvSvR6sj07qmA6JcZZZfxTBNvCenfAlsau-GRwkK5bHqYKwP6GzlYXN9zNNJMw6WQ/s1600/20160218_103406.jpg" imageanchor="1"></a>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEilyz2GaR5xwVUwE9OT4dcfxGreHtIl_O07v0gAHHRNQNanmtZpi5GmNvJcgdNskQmZKiFer1t5bf_LcsyhVWO8nvUtt6TMO1Fv5orNW1lxLZGNrufW8k3fUJwxIDB3u6v4LRokHD8z6YY/s1600/20160218_122000.jpg" imageanchor="1">
<img border="0" height="112" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEilyz2GaR5xwVUwE9OT4dcfxGreHtIl_O07v0gAHHRNQNanmtZpi5GmNvJcgdNskQmZKiFer1t5bf_LcsyhVWO8nvUtt6TMO1Fv5orNW1lxLZGNrufW8k3fUJwxIDB3u6v4LRokHD8z6YY/s200/20160218_122000.jpg" width="200" /></a>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSckUdW0fgil9Hexb936pbHrvEJgBT8ZU_UqO-8I8LQusra9YQMC2Y89-hgSAD6UY6e6XKqapIWL1k_KLLwkbAVAsRDxgfGGb1Gg0yRIwsyPGnzys7sMOvtohSPofgSsA4oook-3CNWz8/s1600/20160218_121815.jpg"><img border="0" height="112" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSckUdW0fgil9Hexb936pbHrvEJgBT8ZU_UqO-8I8LQusra9YQMC2Y89-hgSAD6UY6e6XKqapIWL1k_KLLwkbAVAsRDxgfGGb1Gg0yRIwsyPGnzys7sMOvtohSPofgSsA4oook-3CNWz8/s200/20160218_121815.jpg" width="200" /></a>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBkvCkPkT9hAa7WzRI8seM2GER0qnZfcXw8K23L05272PJJHvWhDNeirlEVW46WM2rZAAe39XN9_UtyRcfzUWMoMGwx0oNYBdbO6hstr2kINeUeuWIJMe8Lz82ne5ew9XguvF-IHyb1Jk/s1600/20160218_122017.jpg" imageanchor="1"> </a>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBkvCkPkT9hAa7WzRI8seM2GER0qnZfcXw8K23L05272PJJHvWhDNeirlEVW46WM2rZAAe39XN9_UtyRcfzUWMoMGwx0oNYBdbO6hstr2kINeUeuWIJMe8Lz82ne5ew9XguvF-IHyb1Jk/s1600/20160218_122017.jpg" imageanchor="1"><img border="0" height="112" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBkvCkPkT9hAa7WzRI8seM2GER0qnZfcXw8K23L05272PJJHvWhDNeirlEVW46WM2rZAAe39XN9_UtyRcfzUWMoMGwx0oNYBdbO6hstr2kINeUeuWIJMe8Lz82ne5ew9XguvF-IHyb1Jk/s640/20160218_122017.jpg" width="200" /></a> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsx80k8twAwhyphenhyphenKEGqkh5bsavRcc4vBMhvSgI5H_tXgafGbjDhz97050_7ayZpFAzbnNjmot3I4s2OETJjQv6MrYMJSygdYXOkgD_UbR01-DgzCKKsYkhvvzf9qiTO3BXQ6gZzUUP_71VU/s1600/20160218_154014.jpg">
<img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsx80k8twAwhyphenhyphenKEGqkh5bsavRcc4vBMhvSgI5H_tXgafGbjDhz97050_7ayZpFAzbnNjmot3I4s2OETJjQv6MrYMJSygdYXOkgD_UbR01-DgzCKKsYkhvvzf9qiTO3BXQ6gZzUUP_71VU/s200/20160218_154014.jpg" width="112" /></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvYeDpWvUc3whYt_q7Dio_MW5lN-Wt796bnagGiwMit4yS3wKgIgTSCfTFEd8hOkuXd0jlD4JZSr0x7l7vCPNt8IAdeo6w4vexElPtwDHfIf0JMFF0FUYhxvdgyw8txhKR4fNpgfs0r8M/s1600/20160218_121735.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvYeDpWvUc3whYt_q7Dio_MW5lN-Wt796bnagGiwMit4yS3wKgIgTSCfTFEd8hOkuXd0jlD4JZSr0x7l7vCPNt8IAdeo6w4vexElPtwDHfIf0JMFF0FUYhxvdgyw8txhKR4fNpgfs0r8M/s200/20160218_121735.jpg" width="112" /></a></div>
<span style="background-color: transparent; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif; font-size: 15px; line-height: 1.3;">If you like this post and want to see more, follow me on my website </span><a href="http://www.chadcompton.com/" style="background-color: transparent; font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif; font-size: 15px; line-height: 1.3;" target="_blank">www.chadcompton.com</a>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Or if you prefer...</span><br />
<a href="http://www.instagram.com/chad.compton" target="_blank"><img src="http://www.chadcompton.com/images/social/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" target="_blank"><img src="http://www.chadcompton.com/images/social/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/twitter.png" /></a>
<a href="https://github.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/github.png" /></a>
<a href="https://bitbucket.org/ccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/bitbucket.png" /></a>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0tag:blogger.com,1999:blog-4625247287479600024.post-55132149532285261382016-01-04T09:36:00.001-08:002016-01-04T09:36:28.115-08:00 SUM Using A Formula (SQL)<h2 style="background-color: white; box-sizing: border-box; color: #535353; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 19px; line-height: 1.1; margin-bottom: 10.5px; margin-top: 30px; text-transform: uppercase;">
</h2>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 21.4286px; margin-bottom: 10.5px;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEim8XOcF69BwwHDxewFsf78bYKsspPGA2Kql9ARII_gCKepYTR7KpH5eripbMGCXwKfaCe_KPfKIMQmTWM9EISVYkwXIsTb63iwDkIzKCF-sp752y7HtxlvA37SnMuCckPJxJP2iUNA86s/s1600/19jat.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEim8XOcF69BwwHDxewFsf78bYKsspPGA2Kql9ARII_gCKepYTR7KpH5eripbMGCXwKfaCe_KPfKIMQmTWM9EISVYkwXIsTb63iwDkIzKCF-sp752y7HtxlvA37SnMuCckPJxJP2iUNA86s/s320/19jat.png" width="320" /></a><span style="font-family: 'helvetica neue', arial, helvetica, sans-serif;">Today I was asked to pull some data and give a total difference of two different columns in a table in SQL. Then I realized that not everyone would have came across this. Even though in the past I have showed you how to use the <a href="http://chadcomptonblog.blogspot.com/2015/11/sum-function-sql.html" target="_blank">SUM Function in SQL</a>. This time I thought I would go one step further and show you how to get a SUM while using a formula in SQL.</span><br /><span style="font-family: 'helvetica neue', arial, helvetica, sans-serif;"><br /></span><span style="font-family: 'helvetica neue', arial, helvetica, sans-serif;">Use the SUM() Function to get the total of a specific numeric column. With that being said, the Sum function doesn't need to be a single field. In this case, you can use a formula. Kind of like, getting total Profit by subtracting Expense (Column1) from Total Sales (Column2). Below is the specific syntax to use.</span><br /><span style="font-family: 'helvetica neue', arial, helvetica, sans-serif;"><br /></span><span style="font-family: 'helvetica neue', arial, helvetica, sans-serif;"><b>SQL SUM Example:</b></span><br />
<div class="post-text" itemprop="text" style="border: 0px; line-height: 1.3; margin: 0px 0px 5px; padding: 0px; width: 560px; word-wrap: break-word;">
<div style="border: 0px; clear: both; margin-bottom: 1em; padding: 0px;">
<div style="color: #222222;">
<br /></div>
<pre class="lang-sql prettyprint prettyprinted" style="background-color: #eeeeee; border: 0px; color: #393318; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><code style="border: 0px; margin: 0px; padding: 0px; white-space: inherit;"><span style="color: blue; font-family: 'helvetica neue', arial, helvetica, sans-serif;"><b><span class="kwd" style="border: 0px; margin: 0px; padding: 0px;">
SELECT </span><span class="pln" style="border: 0px; margin: 0px; padding: 0px;"> SUM(</span><span class="kwd" style="border: 0px; margin: 0px; padding: 0px;">Column1 - Column2)
</span><span class="kwd" style="border: 0px; margin: 0px; padding: 0px;">FROM</span><span class="pln" style="border: 0px; margin: 0px; padding: 0px;"> </span><span class="kwd" style="border: 0px; margin: 0px; padding: 0px;">TableName;
</span><span class="pln" style="border: 0px; margin: 0px; padding: 0px;">
</span></b></span></code></pre>
<div style="color: #222222;">
<br style="font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 16.9px;" /><div style="font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 1.3;">
<span style="font-family: 'helvetica neue', arial, helvetica, sans-serif;"><span style="font-size: 15px; line-height: 19.5px;">Please note, you can also preform groupings while using this function as well. I will show you those at a later date.</span></span></div>
</div>
</div>
</div>
</div>
<br />
<div class="post-text" itemprop="text" style="background-color: white; border: 0px; line-height: 1.3; margin: 0px 0px 5px; padding: 0px; width: 560px; word-wrap: break-word;">
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; clear: both; margin-bottom: 1em; padding: 0px;">
<div style="color: #222222;">
<div style="line-height: 1.3;">
<span style="background-color: transparent; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif; font-size: 15px; line-height: 1.3;">If you like this post and want to see more, follow me on my website </span><a href="http://www.chadcompton.com/" style="background-color: transparent; font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif; font-size: 15px; line-height: 1.3;" target="_blank">www.chadcompton.com</a></div>
</div>
</div>
</div>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Or if you prefer...</span><br />
<a href="http://www.instagram.com/chad.compton" target="_blank"><img src="http://www.chadcompton.com/images/social/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" target="_blank"><img src="http://www.chadcompton.com/images/social/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/twitter.png" /></a>
<a href="https://github.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/github.png" /></a>
<a href="https://bitbucket.org/ccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/bitbucket.png" /></a>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0tag:blogger.com,1999:blog-4625247287479600024.post-83147102095360277232015-12-28T07:31:00.005-08:002015-12-28T07:40:41.666-08:00Boost & Sanitize<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1g9oxthLBpG9vsiXlMzsPCVyeLKzRY4XqQleiTG3TLl6M0UL9K6fp2AScDq7PRz45o1t27_cj9KVR_zuEQ5VjrtJNlx5eXpwK8ZJWHrt-7KbeNnOAmIy-4XGfZupZCmF9Cr3kcPZ2iig/s1600/sanitize.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="213" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1g9oxthLBpG9vsiXlMzsPCVyeLKzRY4XqQleiTG3TLl6M0UL9K6fp2AScDq7PRz45o1t27_cj9KVR_zuEQ5VjrtJNlx5eXpwK8ZJWHrt-7KbeNnOAmIy-4XGfZupZCmF9Cr3kcPZ2iig/s320/sanitize.png" width="320" /></a></div>
While traveling on a plane,sanitize often and take immunity boosters. In my opinion, planes and most public places are cesspools. I take every precaution as I possibly can while getting from point A to point B. I bring hand sanitizing gel with at least 60% alcohol in a 2 ounce container so I can put it in my carry on. I use a bit of sanitizer before I eat or drink. I also use it after I wash my hands and get back to my seat after using the airplane lavatory. <br />
<br />
To also help avoid germs while on a plane, I use Clorox wipes on the seat arms and tray to make sure to kill as many germs that I may come in contact with as possible. I also take Airborne immunity booster the entire time while traveling and a few days before my trip. Taking just a few precautions should allow you to travel and not contact too many nasty germs.<br />
<br />
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif; font-size: 15px; line-height: 1.3;">If you like this post and want to see more, follow me on my website </span><a href="http://www.chadcompton.com/" style="font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif; font-size: 15px; line-height: 1.3;" target="_blank">www.chadcompton.com</a>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Or if you prefer...</span><br />
<a href="http://www.instagram.com/chad.compton" target="_blank"><img src="http://www.chadcompton.com/images/social/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" target="_blank"><img src="http://www.chadcompton.com/images/social/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/twitter.png" /></a>
<a href="https://github.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/github.png" /></a>
<a href="https://bitbucket.org/ccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/bitbucket.png" /></a>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0tag:blogger.com,1999:blog-4625247287479600024.post-45743208384573833372015-12-07T12:51:00.000-08:002015-12-07T12:51:03.305-08:00Blow Away Germs<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgp53t8yFwlUm0o-ro-bvYjigyN80lxP10xbW_dbxScc-IZgj1UY-xGbSqKmor03DWhh1sR1ou0M-KPDSkL5LanQ8n0Vf0o9hUWGM1rQu-aGhX_3oRJavRwQp9Iy6NzzQy1B-8EmqRR1EI/s1600/AdjustingYourVent.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="213" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgp53t8yFwlUm0o-ro-bvYjigyN80lxP10xbW_dbxScc-IZgj1UY-xGbSqKmor03DWhh1sR1ou0M-KPDSkL5LanQ8n0Vf0o9hUWGM1rQu-aGhX_3oRJavRwQp9Iy6NzzQy1B-8EmqRR1EI/s320/AdjustingYourVent.png" width="320" /></a></div>
While traveling on a plane, blow away germs using your vent that is usually located directly above your head. While most planes are equipped with advanced air filters that remove 99 percent of the dust and microbes in the recycled air, but it isn't a perfect system. If you are a frequent flyer, then your chances on catching something while traveling are increased. As a passenger, there is something you can do to help fight that last 1 percent. By adjusting the vent to blow directly into your lap, you should create enough of an air current to knock away any infectious germs that may be floating into your personal space. In my opinion, every little bit helps. Keep checking back for more helpful Travel Tips from the Wanderlust Coder.<br />
<br />
<span style="background-color: transparent; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif; font-size: 15px; line-height: 1.3;">If you like this post and want to see more, follow me on my website </span><a href="http://www.chadcompton.com/" style="background-color: transparent; font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif; font-size: 15px; line-height: 1.3;" target="_blank">www.chadcompton.com</a>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Or if you prefer...</span><br />
<a href="http://www.instagram.com/chad.compton" target="_blank"><img src="http://www.chadcompton.com/images/social/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" target="_blank"><img src="http://www.chadcompton.com/images/social/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/twitter.png" /></a>
<a href="https://github.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/github.png" /></a>
<a href="https://bitbucket.org/ccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/bitbucket.png" /></a>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0tag:blogger.com,1999:blog-4625247287479600024.post-32825297077768945552015-11-30T17:13:00.000-08:002015-11-30T17:34:22.239-08:00Turkish Bath (All My 2000 Parts Scrubbed)In the last little bit, I have read blog after blog of people who travel and tell others about while making a living. I am looking for helpful hint on what I need to do on my blog to get readers/followers. I finally realized, I am not going to try and force it. I will write things that I experience and may even actually buy a new domain and reinvent myself. <br />
<br />
I have been traveling for a while, but recently just started blogging to go with it. I am not actually a writer, but I am a damn good story teller. With that said, I have read an article where it said to taste local culture when you travel and blog/write about it. The article also went on to say that if you could experience something that made you feel uncomfortable or something, then you are going about it the right way. (I think the article in question was from <a href="http://www.bloggingfromparadise.com/free-but-uncomfy/" rel="nofollow" target="_blank">Blogging In Paradise - How To Do Freeing But Uncomfortable Stuff.</a> Taking that to heart I thought I would do something completely out of your comfort zone while traveling.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiCgy7ecJ8Q6-5m_4S9GWl189sr6vAhqoOZbWNWK2SlZXTFL44NRNVyHIH8oKV-BKaLjI3I4fAQel4KxW8IaxWzMUTyauTqzYThrLae0f83AUSQJPnMDwdH-NyZzSvA76I6u4FQS_kzxE/s1600/TurkishBath.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="213" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiCgy7ecJ8Q6-5m_4S9GWl189sr6vAhqoOZbWNWK2SlZXTFL44NRNVyHIH8oKV-BKaLjI3I4fAQel4KxW8IaxWzMUTyauTqzYThrLae0f83AUSQJPnMDwdH-NyZzSvA76I6u4FQS_kzxE/s320/TurkishBath.png" width="320" /></a></div>
Well, it lead me to the story you are about to hear anyways. Please note, that I don't really have a personal filter and I don't sugar coat things like most people. During my last trip to the Philippines, I decided to have a massage. This is something a lot of people enjoy, but for me it is kind of odd. I am not a fan of strangers touching me or massages in general. <br />
<br />
This certain day, my partner said, "Lets go get massages." He gets them all the time and loves them. He always asks me, but I normally decline.<br />
<br />
On this specific day while thinking of the article I just read about getting out of my comfort zone, I said, "Sure that sounds nice." <br />
<br />
With that said, he made us appointments for later on that day. He then said, "I have a surprise for you."<br />
<br />
I said, "what is it?" <br />
<br />
He said, "I set you up with a 1.5 hour massage and then a hour Turkish Bath."<br />
<br />
I had no idea what that was. I guess he was tired of me saying I needed to experience something new and strange that took me out of my comfort zone and took charge. Kind of like the mommy bird kicking her kids out of the nest, if you will. I am kind of glad he did. That lead this new experience.<br />
<br />
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: right; margin-left: 1em; text-align: right;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgcYyOtr5LkitGf9ZGgqIi6P69P2yTvBsKKpOQAMkQht9quc3aKwSXWJxFV-HKVdR3zK1qQsIYmqce3IXRDt8gibGPg6cbiWaIHGlWLKvwmEz5adH0x1tQ_CBAriEuVjQVwxvyLSrm0A4Y/s1600/91518.jpg" imageanchor="1" style="clear: right; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgcYyOtr5LkitGf9ZGgqIi6P69P2yTvBsKKpOQAMkQht9quc3aKwSXWJxFV-HKVdR3zK1qQsIYmqce3IXRDt8gibGPg6cbiWaIHGlWLKvwmEz5adH0x1tQ_CBAriEuVjQVwxvyLSrm0A4Y/s1600/91518.jpg" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Kind of like the faucet in the bath section.</td></tr>
</tbody></table>
I was left in a low lit room down a dark quite hall and was told to remove my clothes and lay down. Then the guy came in and proceeded to massage the knots out of my neck/back. It actually wasn't that bad. The hour and half went by super fast. I swear I almost fell asleep. Then he said to leave all my stuff there in the room and gave me a tiny towel to cover my junk. At that point, we walked on down the hall where I was put in a steam room by myself and asked to get up on this marbled table. It wasn't the most comfy table, but it was hot and steamy. <br />
<br />
After about 10 minutes of laying in the steam filled room, a guy came in that I really don't think could speak English. He proceeded to pull a hose out of the ceiling which almost reminded me of the ones in big restaurants (one pictured to the right) and started hosing me off with this hot/warm water. I was thinking to myself that this whole bath isn't that bad at all. <br />
<br />
He made sure to get every area of my body soaking wet. It was awkward filling, but not too unbearable. Then he started soaping me up. He was using like a hand sponge, but it wasn't too soft. I think it was part sand paper and it is meant to scrub all the dead skin off. To be quite honest, I think it also took quite a bit of living skin off as well. This man scrubbed on me for 30 minutes or more. Every one of my 2000 parts. No crack or crevasse went untouched or scrubbed or lathered. I would have to say, at times it actually hurt. It is a wonder if I wasn't actually bleeding in spots. At least he was more gentle when he was lathering up my family jewels and all my super sensitive areas. Thank goodness for that. I had to say a little prayer or two hoping that he didn't get that sponge caught on any of my many body piercings. That wouldn't have been a fun time at all. I could just see him ripping out a nipple ring or my prince albert and not batting an eye as I screamed in pain.<br />
<br />
I know they say no pain - no gain, but damn...That really did hurt at times, almost felt like a bad road rash. I was just counting down to the moment that he was going to rinse me off and send me on my way. After it was all said and done, I have never felt so clean in my life. That last full body rinse was so nice and soothing. <br />
<br />
I was then escorted to the room where I was massaged while wearing nothing at all and dried off with a towel laying on the bed for me. Either way, when it was all over and my skin shiny and red, it was a great memory. It is an experience that I am going to remember for a long time. I am truly glad I did it. Who knows, I my do it again next time I had back to Philippines. That is if my skin grows back on all my 2000 parts by then. LOL.<br />
<br />
<br />
<br style="background-color: white; color: #444444; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2000007629395px;" />
If you like this post and want to see more, follow me on my website <a href="http://www.chadcompton.com/" target="_blank">www.chadcompton.com</a><br />
Or if you prefer...<br />
<a href="http://www.instagram.com/chad.compton" target="_blank"><img src="http://www.chadcompton.com/images/social/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" target="_blank"><img src="http://www.chadcompton.com/images/social/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/twitter.png" /></a>
<a href="https://github.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/github.png" /></a>
<a href="https://bitbucket.org/ccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/bitbucket.png" /></a>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0tag:blogger.com,1999:blog-4625247287479600024.post-19687165017790269812015-11-10T05:48:00.000-08:002015-11-10T05:48:34.449-08:00SUM Function (SQL)<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5qBiffk2JoCw-cI9-VtTCG59vfrQeO07zUF7ExYa6lAgb6bQGNu9nDjxzy5-Cu9iPlqeG5WezIv8xs56vfN7b3WLHHKPSr5M287p6TnUxfC_AhIFUSy9bPUSmz4SsWnQWkTH1ebf_i8M/s1600/18jat.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5qBiffk2JoCw-cI9-VtTCG59vfrQeO07zUF7ExYa6lAgb6bQGNu9nDjxzy5-Cu9iPlqeG5WezIv8xs56vfN7b3WLHHKPSr5M287p6TnUxfC_AhIFUSy9bPUSmz4SsWnQWkTH1ebf_i8M/s320/18jat.png" width="320" /></a></div>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Today I was asked to pull some data and give a total of a specific column in a table in SQL. I then realized that not everyone would have came across this. </span><br />
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">With that said, I thought I would type up this little blog to explain and show it to you.</span><br />
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Use the SUM() Function to get the total of a specific numeric column. Below is the specific syntax to use.</span><br />
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><b>SQL SUM Example:</b></span><br />
<div class="post-text" itemprop="text" style="background-color: white; border: 0px; line-height: 1.3; margin: 0px 0px 5px; padding: 0px; width: 560px; word-wrap: break-word;">
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; clear: both; margin-bottom: 1em; padding: 0px;">
<div style="color: #222222;">
<br /></div>
<pre class="lang-sql prettyprint prettyprinted" style="-webkit-text-stroke-width: 0px; background-color: #eeeeee; border: 0px; color: #393318; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; margin: 0px 0px 1em; max-height: 600px; orphans: auto; overflow: auto; padding: 5px; text-align: start; text-indent: 0px; text-transform: none; widows: 1; width: auto; word-spacing: 0px; word-wrap: normal;"><code style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px; white-space: inherit;"><span style="color: blue; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><b><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">
SELECT </span><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;"> SUM(</span><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">ColumnName)
</span><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">FROM</span><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;"> </span><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">TableName;
</span><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">
</span></b></span></code></pre>
<div style="color: #222222;">
<br />
<div style="line-height: 1.3;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><span style="font-size: 15px; line-height: 19.5px;">Please note, you can also preform formulas and groupings while using this function as well. I will show you those at a later date.</span></span></div>
<div style="line-height: 1.3;">
<span style="background-color: transparent; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif; font-size: 15px; line-height: 1.3;"><br /></span></div>
<div style="line-height: 1.3;">
<span style="background-color: transparent; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif; font-size: 15px; line-height: 1.3;">If you like this post and want to see more, follow me on my website </span><a href="http://www.chadcompton.com/" style="background-color: transparent; font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif; font-size: 15px; line-height: 1.3;" target="_blank">www.chadcompton.com</a></div>
</div>
</div>
</div>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Or if you prefer...</span><br />
<a href="http://www.instagram.com/chad.compton" target="_blank"><img src="http://www.chadcompton.com/images/social/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" target="_blank"><img src="http://www.chadcompton.com/images/social/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/twitter.png" /></a>
<a href="https://github.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/github.png" /></a>
<a href="https://bitbucket.org/ccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/bitbucket.png" /></a>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0tag:blogger.com,1999:blog-4625247287479600024.post-15172252359554553072015-10-06T09:16:00.000-07:002015-10-08T18:15:07.351-07:00Multiple Random Selected Rows From A Table (SQL)<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6DY4oFYSFoOp6dmCecX4ePa5iHJhDkjZK3O4ijeSacNA2Df-HddHCgntfyZNKlUGqi03ntCqXN9aiueiQwLD0Ge3ELpFeVVCbwk2_UuzVuOEB7ux138EjeybbJE_WQhipGisb-3A-KIU/s1600/JAT17.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6DY4oFYSFoOp6dmCecX4ePa5iHJhDkjZK3O4ijeSacNA2Df-HddHCgntfyZNKlUGqi03ntCqXN9aiueiQwLD0Ge3ELpFeVVCbwk2_UuzVuOEB7ux138EjeybbJE_WQhipGisb-3A-KIU/s320/JAT17.png" width="320" /></a></div>
This weekend I was asked to pull random sample of 40 rows. I was thinking that was super easy, but then they put a kink in the request. They wanted the 40 random rows with 20 from type 'A' and 20 from type 'B' from a specific table (TableName) in Microsoft SQL Server. The first was 20 random people where ColumnName = 'A' and the second was 20 random people where ColumnName = 'B'. <br />
<br />
Using <a href="http://chadcomptonblog.blogspot.com/2015/09/tip-16-sql-to-select-random-rows-from.html" target="_blank">SQL To Select Random Rows From A Table</a> as a stepping off point. I have altered the code below to use multiple random SELECT with a UNION in SQL to accomplish the task. Easy as pie. <br />
<br />
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; clear: both; color: #222222; margin-bottom: 1em; padding: 0px;">
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif; line-height: 1.3;"><b>Microsoft SQL Server:</b></span></div>
<pre class="lang-sql prettyprint prettyprinted" style="-webkit-text-stroke-width: 0px; background-color: #eeeeee; border: 0px; color: #393318; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; margin: 0px 0px 1em; max-height: 600px; orphans: auto; overflow: auto; padding: 5px; text-align: start; text-indent: 0px; text-transform: none; widows: 1; width: auto; word-spacing: 0px; word-wrap: normal;"><code style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px; white-space: inherit;"><span style="color: blue; font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><b><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">SELECT * FROM
(SELECT TOP 20 * FROM TableName
WHERE ColumnName = 'A'
ORDER BY NEWID())
A
Union
SELECT * FROM
(SELECT TOP 20 * FROM TableName
WHERE ColumnName = 'B'
ORDER BY NEWID())
B
</span></b></span></code></pre>
<div style="background-color: white; color: #222222; line-height: 20.8px;">
<br /></div>
<span style="background-color: transparent; font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif; font-size: 15px; line-height: 1.3;">If you like this post and want to see more, follow me on my website </span><a href="http://www.chadcompton.com/" style="background-color: transparent; font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif; font-size: 15px; line-height: 1.3;" target="_blank">www.chadcompton.com</a>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Or if you prefer...</span><br />
<a href="http://www.instagram.com/chad.compton" target="_blank"><img src="http://www.chadcompton.com/images/social/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" target="_blank"><img src="http://www.chadcompton.com/images/social/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/twitter.png" /></a>
<a href="https://github.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/github.png" /></a>
<a href="https://bitbucket.org/ccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/bitbucket.png" /></a>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0tag:blogger.com,1999:blog-4625247287479600024.post-64146060536450481282015-09-22T05:28:00.000-07:002015-10-08T18:08:26.015-07:00SQL To Select Random Rows From A Table<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_CL2Bkx8cjfC9Xeb_1j58ZSauo8IVeC9fHrnhcRNru5qoLAU9284YIWu649XWgHdgGKWhWiaJiJybrcheV2iiXRpIOFDVsSPRXmiA2bHqDBJv9214Y37G0-6wQCCs1t5nm7kS1J1RelA/s1600/16jat.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_CL2Bkx8cjfC9Xeb_1j58ZSauo8IVeC9fHrnhcRNru5qoLAU9284YIWu649XWgHdgGKWhWiaJiJybrcheV2iiXRpIOFDVsSPRXmiA2bHqDBJv9214Y37G0-6wQCCs1t5nm7kS1J1RelA/s320/16jat.png" width="320" /></a></div>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Today I was asked to randomly pull random 25 records from a database table for a client. It took me a minute or so to remember how to accomplish this. With that being said, I thought I would type it up for everyone to be able to benefit from it. </span><br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">I know there are a lot of ways to select random records or rows from a database table, but in this quick article I will show you the Microsoft SQL Server and MySQL syntax required to accomplish the end goal.</span><br />
<div class="post-text" itemprop="text" style="background-color: white; border: 0px; line-height: 1.3; margin: 0px 0px 5px; padding: 0px; width: 560px; word-wrap: break-word;">
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; clear: both; margin-bottom: 1em; padding: 0px;">
<div style="color: #222222;">
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span></div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; clear: both; color: #222222; margin-bottom: 1em; padding: 0px;">
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif; line-height: 1.3;"><b>Microsoft SQL Server:</b></span></div>
<pre class="lang-sql prettyprint prettyprinted" style="-webkit-text-stroke-width: 0px; background-color: #eeeeee; border: 0px; color: #393318; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; margin: 0px 0px 1em; max-height: 600px; orphans: auto; overflow: auto; padding: 5px; text-align: start; text-indent: 0px; text-transform: none; widows: 1; width: auto; word-spacing: 0px; word-wrap: normal;"><code style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px; white-space: inherit;"><span style="color: blue; font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><b><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">SELECT</span><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;"> </span><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">TOP</span><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;"> </span><span class="lit" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">25</span><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;"> </span><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">ColumnName</span><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;"> </span><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">FROM</span><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;"> </span><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">TableName</span><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">
</span><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">ORDER</span><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;"> </span><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">BY</span><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;"> NEWID</span><span class="pun" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">()</span></b></span></code></pre>
<div style="color: #222222;">
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><span style="line-height: 1.3;"><br /></span><span style="line-height: 1.3;"><b>MySQL:</b></span></span></div>
</div>
<pre class="lang-sql prettyprint prettyprinted" style="background-color: #eeeeee; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><code style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px; white-space: inherit;"><span style="color: blue; font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><b><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">SELECT</span><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;"> C</span><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">olumnName</span><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;"> </span><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">FROM</span><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;"> </span><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">TableName</span><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">
</span><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">ORDER</span><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;"> </span><span class="kwd" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">BY</span><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;"> RAND</span><span class="pun" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">()</span><span class="pln" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">
LIMIT </span><span class="lit" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin: 0px; padding: 0px;">25</span></b></span></code></pre>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; clear: both; color: #222222; margin-bottom: 1em; padding: 0px;">
<span style="background-color: transparent; font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif; font-size: 15px; line-height: 1.3;">If you like this post and want to see more, follow me on my website </span><a href="http://www.chadcompton.com/" style="background-color: transparent; font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif; font-size: 15px; line-height: 1.3;" target="_blank">www.chadcompton.com</a></div>
</div>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Or if you prefer...</span><br />
<a href="http://www.instagram.com/chad.compton" target="_blank"><img src="http://www.chadcompton.com/images/social/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" target="_blank"><img src="http://www.chadcompton.com/images/social/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/twitter.png" /></a>
<a href="https://github.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/github.png" /></a>
<a href="https://bitbucket.org/ccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/bitbucket.png" /></a>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0tag:blogger.com,1999:blog-4625247287479600024.post-58253218740837981492015-09-15T08:13:00.000-07:002015-10-08T18:09:42.934-07:00Embed Blogger Feed Into A Website<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpnGn_4ZFbecnZwEIcRChFcss8H4G3sdl1A_d9xYJ9wV704Ihg09-BPKT0-LtfVFVz6IBz1Jm6sZ7-cVCTy1SjUoT67KXUMUg1TUxUUuqCNHktSYIec2dElrc00KWwjF9nLH45VLBk-FY/s1600/15jat.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpnGn_4ZFbecnZwEIcRChFcss8H4G3sdl1A_d9xYJ9wV704Ihg09-BPKT0-LtfVFVz6IBz1Jm6sZ7-cVCTy1SjUoT67KXUMUg1TUxUUuqCNHktSYIec2dElrc00KWwjF9nLH45VLBk-FY/s320/15jat.png" width="320" /></a></div>
Again I come to you with some knowledge that may help you keep your website up-to-date with another one of your social media feeds. This way you have constant changing information appearing on your site without having to hand enter it each time or even knowing how to code. Anytime you can do link social media to a site, I would suggest to do it. With that said, lets get started.
<br />
<br />
This article will give you the information you need to be able to embed a Blogger feed directly into a website. There is a "quick/dirty" way and a "customized" way to do this. At this time, I will be giving you the "quick/dirty" way to directly embed a Blogger feed into a website. At a later date, I will give you the completely "customized" way.
<br />
<br />
<b style="font-size: x-large;"><span style="color: orange;">4 Simple Steps To Add A Blogger Feed To A Site:</span></b><br />
<br />
<br />
<li><b>Go To The Blogger RSS Feed You Wish To Embed</b><br />Type the URL into a web browser.</li>
<li><b>Edit the Code Below </b>Replace "<span style="color: orange;"><b>chadcomptonblog</b></span>" below with the Blogger Site name you wish to embed.<br /><br />
<div class="code notranslate" style="background-color: #f1f1f1; border: 1px solid rgb(221, 221, 221); box-sizing: border-box; color: #444444; font-family: Consolas, 'courier new'; font-size: 15px; line-height: 21.4286px; margin: 0px 0px 12px; padding: 9.76563px; width: auto; word-wrap: break-word;">
<div style="box-sizing: border-box; font-size: 14px;">
<div style="font-size: medium;">
<iframe src ="http://<span style="color: orange;"><b>chadcomptonblog</b></span>.blogspot.com/" width="100%" height="400"></div>
<div style="font-size: medium;">
<p>Your browser does not support iframes.</p></div>
<div style="font-size: medium;">
</iframe> </div>
</div>
</div>
</li>
<li><b>Copy/Paste the Code Above Onto Your Website</b>The code should be placed where ever on the page you wish the Blogger Feed itself to appear.</li>
<li><b>Save your New Code to Your Site</b></li>
After adding your new code to your site where you want it, save it and upload it if necessary.<br />
<br />
<br />
If you like this post and want to see more, follow me on my website <a href="http://www.chadcompton.com/" target="_blank">www.chadcompton.com</a><br />
Or if you prefer...<br />
<a href="http://www.instagram.com/chad.compton" target="_blank"><img src="http://www.chadcompton.com/images/social/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" target="_blank"><img src="http://www.chadcompton.com/images/social/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/twitter.png" /></a>
<a href="https://github.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/github.png" /></a>
<a href="https://bitbucket.org/ccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/bitbucket.png" /></a>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0tag:blogger.com,1999:blog-4625247287479600024.post-53576354915180304032015-09-08T05:50:00.000-07:002015-09-08T05:50:43.373-07:00Benefits of Probiotics<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkvQvDFHZxfsicDs08Wp0uPt1H9EOH9MDB88mH7blLxza-7pN5ieqVSUmXYX9qwcZX3geqQAViTJppaQh5757HMk1emDO9rERksHQezkPPe1VfjT2mrVK2VO82ZiI36uIX4HAF4UYeDPI/s1600/probiotics.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="213" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkvQvDFHZxfsicDs08Wp0uPt1H9EOH9MDB88mH7blLxza-7pN5ieqVSUmXYX9qwcZX3geqQAViTJppaQh5757HMk1emDO9rERksHQezkPPe1VfjT2mrVK2VO82ZiI36uIX4HAF4UYeDPI/s320/probiotics.png" width="320" /></a></div>
During my travels, somewhere along the way, I have picked up the habit of drinking probiotics as a breakfast shot. I usually drink them in a little shot drink made by the company Yukult. I never really knew why I did it, but I like the tart taste of it and was told it was good for me. Not until today did I know exactly why it was good for me.<br />
<br />
Probiotics are live bacteria and yeasts that are consumed daily to help balance the digestive system and maintain overall health. Probiotics can be found in other foods such as kefir, sauerkraut, sourdough bread, pickles, tempeh, miso, plain unflavored yogurt, kimchi, kombucha tea,<br />
dark chocolate, and microalgae.<br />
<br />
Usually bacteria is thought of as something that causes colds and other diseases, but the human body is full of both good and bad. The "good" or "helpful" bacteria are referred to as probiotics and can help prevent and treat a wide variety of ailments. Below are just a few benefits that I have ran across in my studies.<br />
<br />
<h3 style="background-color: white; color: #444444; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; margin: 0px; position: relative;">
<span style="color: #f54c00;">Digestive Benefits</span></h3>
<hr color="#f54c00" style="color: #444444; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2000007629395px;" />
<br />
The human digestive tracts are filled with thousands of different types of living bacteria. This bacteria help us break down and absorb nutrients from the foods we eat. These bacteria can die or are killed when we take medicines such as antibiotics. Probiotics can be used to repopulate the digestive tract with these healthful bacteria we need. <br />
<div>
Probiotics have been known to help people suffering with irritable bowel syndrome (IBS) and other intestinal symptoms such as abdominal pain, bloating, diarrhea, cramps, and constipation. For this reason, most people use probiotics for overall digestive management and weight maintenance.<br />
<br />
<br />
<h3 style="background-color: white; color: #444444; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; margin: 0px; position: relative;">
<span style="color: #f54c00;">Allergy</span></h3>
<hr color="#f54c00" style="color: #444444; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2000007629395px;" />
<br />
Still being researched, but interesting to find out. When infants received probiotics in-vitro, they had higher levels of tissue inflammation. This is thought to trigger the immune system and reduce allergy incidence. There is also a 30 percent reduction of instance of childhood eczema in these infants.<br />
<br />
<h3 style="background-color: white; color: #444444; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; margin: 0px; position: relative;">
<span style="color: #f54c00;">Immunity</span></h3>
<hr color="#f54c00" style="color: #444444; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2000007629395px;" />
<br />
One of the main functions of healthful bacteria is to stimulate immune responce. Consuming enough probiotics, a person can help maintain a healthy immune system by increasing the production from lymphcytes which will boost the immune system.<br />
<br />
<h3 style="background-color: white; color: #444444; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; margin: 0px; position: relative;">
<span style="color: #f54c00;">Heart Health</span></h3>
<hr color="#f54c00" style="color: #444444; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2000007629395px;" />
<br />
Probiotics have been known to lower cholesterol by breaking up bile salts and decreasing cholesterol from being absorbed into the body.<br />
<br />
<h3 style="background-color: white; color: #444444; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; margin: 0px; position: relative;">
<span style="color: #f54c00;">Oral Health</span></h3>
<hr color="#f54c00" style="color: #444444; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2000007629395px;" />
<br />
Probiotics kills bactera that causes tooth decay and lessens the effects of gingivitis. Daily doses of this healthy bacteria will also reduce bleeding gums.<br />
<br />
<h3 style="background-color: white; color: #444444; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; margin: 0px; position: relative;">
<span style="color: #f54c00;">Urinary Health</span></h3>
<hr color="#f54c00" style="color: #444444; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2000007629395px;" />
<br />
Regular probiotics can help prevent urinary tract infections by maintaining a higher population of healthy bacteria on the tract's adherence sites. It also has been found to prevent yeast infections and bacterial vaginosis in women as well.<br />
<br />
<br /></div>
If you like this post and want to see more, follow me on my website <a href="http://www.chadcompton.com/" target="_blank">www.chadcompton.com</a><br />
Or if you prefer...<br />
<a href="http://www.instagram.com/chad.compton" target="_blank"><img src="http://www.chadcompton.com/images/social/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" target="_blank"><img src="http://www.chadcompton.com/images/social/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/twitter.png" /></a>
<a href="https://github.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/github.png" /></a>
<a href="https://bitbucket.org/ccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/bitbucket.png" /></a>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0tag:blogger.com,1999:blog-4625247287479600024.post-44900930413441163262015-09-03T05:34:00.000-07:002015-10-08T18:10:01.234-07:00Embed Pinterest Feed Into A Website<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDPFmjF5zr8DmbAKI5B6YxzDxIqyV1378ITSm5LHHKE25Y0re54wogVC2qcG-gHFaHVC4FTRNsCuwkCUKX3VWEXDoUG1bq4xPf8OX_ASDs6By7bVOWeH2NY3t3_VrL947FEpzDiNbTkqM/s1600/14jat.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDPFmjF5zr8DmbAKI5B6YxzDxIqyV1378ITSm5LHHKE25Y0re54wogVC2qcG-gHFaHVC4FTRNsCuwkCUKX3VWEXDoUG1bq4xPf8OX_ASDs6By7bVOWeH2NY3t3_VrL947FEpzDiNbTkqM/s320/14jat.png" width="320" /></a></div>
Once again, I come to you with some knowledge that may help you keeping your website up-to-date with another one of your social media feeds.<br />
<br />
This article will give you the information you need to be able to embed a Pinterest feed directly into a website. This way you have constant changing information appearing on your site without having to hand enter it each time or even knowing how to code. Anytime you can do link social media to a site, I would suggest to do it. With that said, lets get started.<br />
<span style="color: red;"><b></b></span>
<span style="color: red;"><b></b></span>
<span style="color: red; font-size: large;"><b>5 Simple Steps To Add A Pinterest Widget To A Site:</b></span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8ULIEuA9WekUJUBAJKGLapDlShf3Z-sKltRziqELCM0vq3ltEjMoDzBjDUYW9aFIe9mtRIn_tyM_MJ2Ce5VhMpXlRbJ2ztYbjXZKJ6JWBp6GpTzamvbJpMUwYnVRg-SbwzUbhdY_XWuY/s1600/pinterst.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8ULIEuA9WekUJUBAJKGLapDlShf3Z-sKltRziqELCM0vq3ltEjMoDzBjDUYW9aFIe9mtRIn_tyM_MJ2Ce5VhMpXlRbJ2ztYbjXZKJ6JWBp6GpTzamvbJpMUwYnVRg-SbwzUbhdY_XWuY/s1600/pinterst.png" /></a></div>
<br />
<br />
<li><b>Go to the Pinterest Widget Builder Page</b><br /><a href="https://business.pinterest.com/en/widget-builder#do_embed_user" target="_blank">https://business.pinterest.com/en/widget-builder#do_embed_user</a></li>
<br />
<br />
<br />
<br />
<li><b>Copy/Paste the Pinterest Page Website Address</b><br />
in the box that is labeled Pinterest User URL.</li>
<br />
<br />
<br />
<br />
<li><b>Pick Desired Settings</b><br />
You can customize with the following feed types: Square, Sidebar, Header, Roll Your Own.</li>
<br />
<br />
<br />
<br />
<li><b>Copy/Paste the Code</b><br />
This code should be placed where ever on the page you wish the Pinterest Page Website itself to appear.</li>
<br />
<br />
<br />
<br />
<li><b>Save your New Code to Your Site</b><br />
After adding your new code to your site where you want it, save it and upload it if necessary.</li>
<br />
<br />
Please note, you can also chose to add a specific board to your site or a specific pin. The code to accomplish this is located on this page as well. Just change the options on the side. That might be a later date article as well.<br />
<br />
If you like this post and want to see more, follow me on my website <a href="http://www.chadcompton.com/" target="_blank">www.chadcompton.com</a><br />
Or if you prefer...<br />
<a href="http://www.instagram.com/chad.compton" target="_blank"><img src="http://www.chadcompton.com/images/social/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" target="_blank"><img src="http://www.chadcompton.com/images/social/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/twitter.png" /></a>
<a href="https://github.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/github.png" /></a>
<a href="https://bitbucket.org/ccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/bitbucket.png" /></a>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0tag:blogger.com,1999:blog-4625247287479600024.post-19429303667295194242015-08-29T13:17:00.001-07:002015-08-29T13:17:16.553-07:00Earn Money While Shopping With Ibotta<div class="separator" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em; text-align: center;">
<a href="https://ibotta.com/r/aylmtel" target="_blank"><img alt="" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSx5MCYizKsqLCPqFd-2V9vT20O_xuvx_p7zEtXI5Ml3S3JD7LG8Sh0ITa4VcMiMJxHpvHf5L2O-Meeh7yVOGAyGT2u3PXbyjR2wX6MZdZZdUcqBDIxie-ryt4RkVjx7gvlGfCU77VsFI/s1600/ibotta.jpg" title="" /></a><span id="goog_257960149"></span><span id="goog_257960150"></span><a href="https://www.blogger.com/"></a></div>
A friend of mine introduced me to the app called <a href="https://ibotta.com/r/aylmtel" target="_blank">Ibotta</a>. She said you really earn money while shopping for things you normally buy like milk, eggs, veggies, or even clothing. I was very skeptical and ended up downloading the app onto my phone. After toying around with it for a while, I realized it really was legit. This is a great way for me to earn extra money. As many of you know, I am a traveler and never know where I will end up at any given time. This app travels with me and don't require me to carry paper coupons. I love it. It also links in with my frequent shopper cards from many of the stores I frequent.<br />
<br />
Once you download the program and create a login, you just need to browse the available rebates either by category or specific store. Some of the Categories and Stores I have listed below. You click on the item you wish to buy, watch a short 10 to 30 second video, view a recipe, or answer a few questions about a product to unlock the rebate. It is as simple as that. At this time, the rebate will be added to your Shopping List. <br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZhsBDQbiGWUF0ASSJ6-svCBrOw-ZFg-cTCZAMMDH8j2TxNkTc4qzXpa8VXLNulUVpbNfS6god80hjiJrUNrIorawC6yYRQEFufGSFoMmYkPjlb1kITilS8qEbzVXLYHSSP7qCStwp2GE/s1600/Ibotta-Any-Brand.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZhsBDQbiGWUF0ASSJ6-svCBrOw-ZFg-cTCZAMMDH8j2TxNkTc4qzXpa8VXLNulUVpbNfS6god80hjiJrUNrIorawC6yYRQEFufGSFoMmYkPjlb1kITilS8qEbzVXLYHSSP7qCStwp2GE/s320/Ibotta-Any-Brand.jpg" width="320" /></a></div>
They have mostly name brand items on their rebate list but there are a lot of product types that they refer to as Any Brand Rebates. They consist of onions, milk, eggs, tomatoes, bread, frozen pizza, frozen veggies, and ice cream just to name a few. I have also noticed that these rebates pop up on a weekly or bi weekly basis to use. So just because you use it once, don't mean it will not come up available again. <br />
<br />
Once you go shopping and buy the items on your shopping list, you just scan their UPC code and scan or take a picture of your receipt and CHING! You just made free money. Who doesn't like free money? EXACTLY!<br />
<br />
You can also join Teams if you are invited to join like with this link here I provided. This will allow you to join my team. Then we get extra money for being on teams. It is a win win. <br />
Once you earn enough money in your rebates, you can either cash out, send to paypal, or get gift cards from a huge selection of participating businesses. <br />
<br />
The categories you can pick from are Back to School, Grocery, Apparel, Beauty & Wellness, Electronics, Restaurants, Sports & Fitness, Home & Office, Babies & Kids, Arts & Crafts, Pets, Specialty & Gifts, Automotive, Travel, Beer, Wine & Spirits. Some of the specific stores are American Eagle, Famous Footwear, Walmart, Kroger, Target, CVS, Food Lion, Family Dollar, Sam's Club, Walgreens, Rite Aid, Whole Foods, Circle K, Speedway, Express, Orbits, Macy's, Kohl's, and Hoppy Lobby just to name a few. <br />
<br />
As you can see, you are more than likely buying the items required to receive the rebate. So what are you waiting for? Click the link below and join my team. Lets both earn money together <a href="https://ibotta.com/r/aylmtel">https://ibotta.com/r/aylmtel</a><br />
<br />
If you like this post and want to see more, follow me on my website <a href="http://www.chadcompton.com/" target="_blank">www.chadcompton.com</a><br />
Or if you prefer...<br />
<a href="http://www.instagram.com/chad.compton" target="_blank"><img src="http://www.chadcompton.com/images/social/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" target="_blank"><img src="http://www.chadcompton.com/images/social/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/twitter.png" /></a>
<a href="https://github.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/github.png" /></a>
<a href="https://bitbucket.org/ccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/bitbucket.png" /></a>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0tag:blogger.com,1999:blog-4625247287479600024.post-25351447364798437032015-08-25T09:04:00.001-07:002015-10-08T18:10:24.782-07:00Embed A Facebook Feed Into A Website<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhzhXEv1ERemwpWbswStgCZChQBv2TZ531QNsbyCPZLphNnQj5imEhiy9WTEY17Y4PqIAoeBdmj3Wqh8QVDLVmz0LO81qlqyewoaDhQssMEfat0kBTm1r5ZQnmWj67bbdDqoaftyijBiVE/s1600/13jat.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhzhXEv1ERemwpWbswStgCZChQBv2TZ531QNsbyCPZLphNnQj5imEhiy9WTEY17Y4PqIAoeBdmj3Wqh8QVDLVmz0LO81qlqyewoaDhQssMEfat0kBTm1r5ZQnmWj67bbdDqoaftyijBiVE/s320/13jat.png" width="320" /></a></div>
So in a past blog, I wrote <a href="http://chadcomptonblog.blogspot.com/2015/08/tip-12-embed-twitter-feed-into-website.html" rel="nofollow" target="_blank">Tip 12: Embed A Twitter Feed Into A Website</a> and was asked if there was a way to embed Facebook into a website as well. Facebook provides you with all the tools you need to do this.<br />
<br />
If there is any way to embed any of your social media feeds into your website or blog, I would recommend doing so. This way you have constant changing information appearing on your site without having to hand enter it each time or even knowing how to code. With that said, lets get started.<br />
<br />
<span style="color: blue;"><b>The 7 simple steps to add a facebook feed to your site. </b></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnj1Y7E9DudLl85jNHnEWKLkOiTeoAQEn_AcS8bq2gGpZMvkqPV0MhiBSypWG3il9OWWkGqU36iW7JayS8nknJRM4IHBDsEDcI-wUZM4hcrnzvVxo48qyPGvSm06wLx0ac7RUtoqdeB9Q/s1600/facebookfeed.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnj1Y7E9DudLl85jNHnEWKLkOiTeoAQEn_AcS8bq2gGpZMvkqPV0MhiBSypWG3il9OWWkGqU36iW7JayS8nknJRM4IHBDsEDcI-wUZM4hcrnzvVxo48qyPGvSm06wLx0ac7RUtoqdeB9Q/s320/facebookfeed.png" width="215" /></a></div>
<br />
<li><b>Go to Facebook Developer Plugin Page</b> <br />Click here <a href="https://developers.facebook.com/docs/plugins/page-plugin" target="_blank">https://developers.facebook.com/docs/plugins/page-plugin</a>.</li>
<br />
<br />
<li><b>Copy/Paste or Type the Facebook Page Website Address </b><br />in the box that is labeled Facebook Page URL.</li>
<br />
<br />
<li><b>Pick the Settings You Desire for Your Plugin</b><br />Add width, height, show friends faces, hide cover photo, and show page posts. You will be able to see what the end result of your options will look like on the bottom of the page. (<i>Just a note, for the width and height I use percentages instead of pixels to make it more mobile responsive.)</i></li>
<br />
<br />
<li><b>Click the "Get Code" button</b><br />The code you just created will pop up.</li>
<br />
<br />
<li><b>Copy the Code from Section 1</b><br />This code should be placed at the top of the desired page. Facebook developers recommend to place it directly after the <body> tag. It is the Javascript SDK coding that is needed for the plugin to function.</li>
<br />
<br />
<li><b>Copy the Code from Section 2</b><br />This code should be placed where ever on the page you wish the Facebook Plugin itself to appear.</li>
<br />
<br />
<li><b>Save your New Code to Your Site</b><br />After adding your new code to your site where you want it, save it and upload it if necessary. <br /><br /> </li>
<br />
If you are looking for just adding the "Like" or "Share" buttons to your site, check back at a later date.<br />
<br />
If you like this post and want to see more, follow me on my website <a href="http://www.chadcompton.com/" target="_blank">www.chadcompton.com</a><br />
Or if you prefer...<br />
<a href="http://www.instagram.com/chad.compton" target="_blank"><img src="http://www.chadcompton.com/images/social/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" target="_blank"><img src="http://www.chadcompton.com/images/social/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/twitter.png" /></a>
<a href="https://github.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/github.png" /></a>
<a href="https://bitbucket.org/ccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/bitbucket.png" /></a>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0tag:blogger.com,1999:blog-4625247287479600024.post-81615491940227627292015-08-21T06:08:00.000-07:002015-08-21T07:13:35.304-07:00Just Beet It<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjrzdqh4ceFi7_x6S9e7lzLqxK3AZPuTrP7PtnUjJ2Tn9Pl2F7pRsNnBuOT6YUWjoNuWJcU0gfyGp1btRJ6cFbhPvDzhzublZU4NS_zEOqHJo3g7XzYfAgnsPZnWym62y7d09vIqwzK8Ug/s1600/beets.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="237" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjrzdqh4ceFi7_x6S9e7lzLqxK3AZPuTrP7PtnUjJ2Tn9Pl2F7pRsNnBuOT6YUWjoNuWJcU0gfyGp1btRJ6cFbhPvDzhzublZU4NS_zEOqHJo3g7XzYfAgnsPZnWym62y7d09vIqwzK8Ug/s320/beets.png" width="320" /></a></div>
I have ate beets for years and really was an acquired taste for me. As a kid, I thought beets were only able to be consumed when pickled. I didn't like them at all. It wasn't until later in life when I had a roasted beet and enjoyed it. Then it wasn't until my travels abroad that I found out that you could eat the beet green as well. <br />
<br />
<h3>
<b><span style="color: red;">Brief History</span></b></h3>
<hr color="red" />
<div>
<span style="color: #f54c00;"><br /></span></div>
The beet originated in prehistoric times and grew wild along the coastlines of Asia, Europe, and North Africa. Back then, only the beet greens or tops were consumed. Ancient Romans were the first peoples to cultivate and consume the beet root itself. Invading tribes of Rome were the ones responsible of spreading beets through northern Europe and then introducing them to the rest of the world.<br />
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgP70wZCnLKQ8ULqmIMxnvZs50E_qgpKTuRLmvr2H3QS4Wgb4Q4ql6Q9creEgJAfMCQeKmoQmiM6hGZP7MUKs3CiRaq23VLjlWkQ6Tp-51T6g093vpqk9YoHGhkVEJaSIRA2pJQJgKO4Kw/s1600/beetTandmWorldWide.jpg" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgP70wZCnLKQ8ULqmIMxnvZs50E_qgpKTuRLmvr2H3QS4Wgb4Q4ql6Q9creEgJAfMCQeKmoQmiM6hGZP7MUKs3CiRaq23VLjlWkQ6Tp-51T6g093vpqk9YoHGhkVEJaSIRA2pJQJgKO4Kw/s200/beetTandmWorldWide.jpg" width="196" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Picture from TandomWorld.com</td></tr>
</tbody></table>
<br />
Beets or sugar beets are very sweet and contain the highest sugar content of all vegetables. Both their root and greens (aka tops) are good for human consumption and are packed with nutrients. Please note that beets aren't just the plain Jane red ball that most people picture when they hear the word. Beet farmers have developed many different varieties including gold or yellow or candy cane.Besides tasting great, eating beets and their greens can benefit the body.<br />
<h3>
<span style="color: red;">Benefits</span></h3>
<hr color="red" />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgd6TMdoczDq23_mZznxRrsBkd-93cOANCfK_A0E0i83BZwPQQeNrVH-SNVCh1Zuc9kA12MbCJQqI5Gp3BNfkeiuQEh2ktIOPB0agMFkk0qIJHCZAv4WDYZPcPQCcu9PHNcS-DvGaMYB5Y/s1600/beetnrice.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="190" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgd6TMdoczDq23_mZznxRrsBkd-93cOANCfK_A0E0i83BZwPQQeNrVH-SNVCh1Zuc9kA12MbCJQqI5Gp3BNfkeiuQEh2ktIOPB0agMFkk0qIJHCZAv4WDYZPcPQCcu9PHNcS-DvGaMYB5Y/s200/beetnrice.png" width="200" /></a></div>
<br />
<br />
<br />
<li><b><span style="color: red;">Detoxify and cleanse the body.</span></b><br />Beets contain betalin pigments that aid in breaking down other toxins bound to other molecules so they can be excreted from the body. In laymen's terms they work as a purifier for the blood and liver.
</li>
<li><span style="color: red;"><b>Contain natural beta carotene.</b></span><br />Beta carotene helps prevent lung cancer and age related blindness called cataracts. The powerful phytonutrients that give beets their deep red color may help prevent various forms of cancer.</li>
<li><b><span style="color: red;">Can be used to test stomach acid.<div class="separator" style="clear: both; text-align: center;">
</div>
</span></b>If you eat a lot of beets, your pee will turn pink or red if you have low stomach acid.
</li>
<li><b><span style="color: red;">Packed with vitamins and minerals.</span></b><br />
Beets are high in immune-boosting vitamin C which can help prevent asthma symptoms. fiber, and essential minerals like potassium which are essential for healthy nerve and muscle function. They contain manganese which is good for your liver, bones, kidneys, and pancreas. Beets also contain the B vitamin folate, which helps reduce the risk of birth defects.
</li>
<li><b><span style="color: red;">Fight inflammation.</span></b><br />
Beets are one of the few sources of betaine, a nutreint that protects cells, enzymes, and proteins from environmental stress. It is also fights inflamation, improves vascular risk factors, protects internal organs, enhances performance, and helps prevents numerous chronic diseases.<br /><br /><div class="separator" style="clear: both; text-align: center;">
</div>
</li>
<li><b><span style="color: red;">Nature's Viagra.</span></b><br />
Since Romans were the first to eat the beet root, they found it to be natures aphrodisiac. They contain high amounts of boron, which is directly effects the production of sex hormones in humans. It will boost your libido, increased fertility, sperm mobility, and a reduction in frigidity in the bedroom.</li>
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Text Ad On Blog -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="4442568677" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<li><b><span style="color: red;">Help extend endurance and improve performance.</span></b><br />
Beets contain nitric oxide is a powerful vasodilator and is commonly used in supplements to give bodybuilders to help with endurance. It increases performance it is involved in increasing blood flow to the muscles, which makes it easier for you to produce energy. It also maintains blood pressure and controls muscle contraction.</li>
<li><span style="color: red;"><b>Lower blood pressure.</b>
</span><br />Beets contain nitrates naturally and its juice may lower blood pressure in just a few hours. It lowers systolic blood pressure by an average of 4 to 5 points. Nitric oxide, in turn, helps to relax and dilate your blood vessels, improving blood flow and lowering blood pressure.
</li>
<li><b><span style="color: red;">Beets are a high source of energy.</span></b><br />
At the same time they are low in calories and high in sugar (although the sugar is released into your system gradually, as opposed to chocolate). Very few foods found in the natural world are as beneficial as beets in this regard. Beets are a wonderful addition to any dietary need. With their high volume of nutrients, delicious taste, and multitude of uses, anyone can jump right into beets without missing a beat.
</li>
<li><b><span style="color: red;">Beets help your mental health.</span></b><br />
Beets contain betaine, the same substance that is used in certain treatments of depression. It also contains trytophan, which relaxes the mind and creates a sense of well-being, similar to chocolate. Beets can also lower your blood pressure. So if you’re already steamed about not eating beets, you can get a two-fer by diving into them right away.</li>
If you like this post and want to see more, follow me on my website <a href="http://www.chadcompton.com/" target="_blank">www.chadcompton.com</a><br />
Or if you prefer...<br />
<a href="http://www.instagram.com/chad.compton" target="_blank"><img src="http://www.chadcompton.com/images/social/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" target="_blank"><img src="http://www.chadcompton.com/images/social/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/twitter.png" /></a>
<a href="https://github.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/github.png" /></a>
<a href="https://bitbucket.org/ccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/bitbucket.png" /></a>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0tag:blogger.com,1999:blog-4625247287479600024.post-935709167255989772015-08-19T06:18:00.000-07:002015-10-08T18:10:46.803-07:00Embed A Twitter Feed Into A Website<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgVorIcva6X7nXWGKYuUmjGiDnI-w_NB-sBWozeVLVGcN978Thc-BY80o2LzCgzWjyQ3zE-3_qbcZFK79H8zSzWQmFXFO2Bb4eujm9q3T0JyxGISxvg7HJtldP0euKGQwATVaWSOAMtoU/s1600/12jat.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgVorIcva6X7nXWGKYuUmjGiDnI-w_NB-sBWozeVLVGcN978Thc-BY80o2LzCgzWjyQ3zE-3_qbcZFK79H8zSzWQmFXFO2Bb4eujm9q3T0JyxGISxvg7HJtldP0euKGQwATVaWSOAMtoU/s320/12jat.png" width="320" /></a></div>
I recently was asked to embed a Twitter feed into a clients website. After I launched the site, I was asked how I did this. So instead of just emailing that one person and letting him know, I thought I would write a blog about it. This way many people could benefit from the information as well.<br />
<br />
Please note that you do not just have to post a specific Twitter feed on your site. During this process, I found out that you can also embed Favorites, Search Words, Lists, or Collections from any given account. <br />
<br />
Embedding a Twitter feed and any other social media into a site is a great way to allow non-coding site owners the ability to update sections of their site without having to attempt to edit the website code itself. This feature is also immediate with no delay in data or news getting to the feed. I would encourage any website owner to do this. I will also blog about how to do this with other forms of social media as well at a later date and time. Keep checking back often. Or if you wish to see one sooner than later, <a href="mailto:rccompton@gmail.com" target="_blank">email me</a>.<br />
<br />
<b><span style="color: blue;">The 8 simple steps below will allow you to embed a twitter feed into a website with ease.</span></b><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3mK4IxgeNO2LIxo95YwXT63NaiaJN6XU3jXN1M9SXkJbRzVBiFlygt8NAgJqyolnsRD1gQzk5EqLQgg_xZbbVlZeZryu1G7Li7sxwfxNGh2vI_1BoyBYeuA7V261bSzDi0GOL68MVNjs/s1600/twitter-logo.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3mK4IxgeNO2LIxo95YwXT63NaiaJN6XU3jXN1M9SXkJbRzVBiFlygt8NAgJqyolnsRD1gQzk5EqLQgg_xZbbVlZeZryu1G7Li7sxwfxNGh2vI_1BoyBYeuA7V261bSzDi0GOL68MVNjs/s1600/twitter-logo.png" /></a></div>
<ol>
<li>Sign into a Twitter account, please note it doesn't have to be the account
you wish to embed into your site.</li>
<li>Go click on your avatar up in the right corner and then go down to <span style="color: blue;"><b>Settings</b></span>.
</li>
<li>Once you are in your <span style="color: blue;"><b>Settings</b></span>, go click on <span style="color: blue;"><b>Widgets</b></span>.
</li>
<li>Click on the <span style="color: blue;"><b>Create New</b></span> button.
</li>
<li>Type the Twitter <span style="color: blue;"><b>Username</b></span> you are wishing to embed in the top line.
</li>
<li>Click through the <span style="color: blue;"><b>Options</b></span> you wish to show and
then customize some of the design by defining the <span style="color: blue;"><b>Height</b></span>, <b><span style="color: blue;">Theme</span></b>, and <span style="color: blue;"><b>Link Color</b></span>.
</li>
<li>Click the <b><span style="color: blue;">Create Widget</span></b> button.
</li>
<li>Copy & paste this code to your website.
</li>
</ol>
<div>
<br /></div>
If you like this post and want to see more, follow me on my website <a href="http://www.chadcompton.com/" target="_blank">www.chadcompton.com</a><br />
Or if you prefer...<br />
<a href="http://www.instagram.com/chad.compton" target="_blank"><img src="http://www.chadcompton.com/images/social/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" target="_blank"><img src="http://www.chadcompton.com/images/social/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/twitter.png" /></a>
<a href="https://github.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/github.png" /></a>
<a href="https://bitbucket.org/ccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/bitbucket.png" /></a>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0tag:blogger.com,1999:blog-4625247287479600024.post-12725303098676369012015-08-17T19:07:00.001-07:002015-08-18T06:06:06.627-07:00Grocery Shopping in the Philippines<div class="separator" style="clear: both; text-align: center;">
</div>
<div style="text-align: left;">
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: right; margin-left: 1em; text-align: right;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmJq-xDMX2k1ssg11r1EifZ6ZwY6_i94tissa2AZhlfYzXCVR88phbJix5TjUpSeu0mnqgnDqDprJ4UVY67Qk8PlT58hG-UOzgXZmfbi7MWcqIHpZBVonSBTbVZGa3B8UIATWLS4_udNM/s1600/security.png" imageanchor="1" style="clear: right; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img border="0" height="197" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmJq-xDMX2k1ssg11r1EifZ6ZwY6_i94tissa2AZhlfYzXCVR88phbJix5TjUpSeu0mnqgnDqDprJ4UVY67Qk8PlT58hG-UOzgXZmfbi7MWcqIHpZBVonSBTbVZGa3B8UIATWLS4_udNM/s200/security.png" width="200" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Security guard in official uniform outside SM Mall. </td></tr>
</tbody></table>
When you are in a place long enough while traveling, you are going to have to venture out to get groceries at some point. You are going to have to pick up supplies and groceries or other food stuffs just as the locals do. Living in Angeles City, Philippines this holds true as well. <br />
<br /></div>
<div style="text-align: left;">
Here there are little one room stalls or open markets all along the streets that you can visit if you like, but I am referring to the full blown action of the grocery store. Most of the larger grocery store chains here are located in malls or bigger shopping centers. <br />
<br />
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfCmbyXGJIq4A6A15vH8GbS3TG_-WzpzZakSfHgpUOrVyIJpPxCNq8_i6zGUOKPESG14-cIj88T00Wj4shCK50NKmQYC3ZcvcgnXiRSpi3dVrCQszaNs9cf8GOs5q8APEo8pHI44j85D8/s1600/20150409_115935.jpg" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfCmbyXGJIq4A6A15vH8GbS3TG_-WzpzZakSfHgpUOrVyIJpPxCNq8_i6zGUOKPESG14-cIj88T00Wj4shCK50NKmQYC3ZcvcgnXiRSpi3dVrCQszaNs9cf8GOs5q8APEo8pHI44j85D8/s200/20150409_115935.jpg" width="150" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Fish looking at me from Fish counter.</td></tr>
</tbody></table>
When you enter these grocery stores, you will have to go past security men/women that will more than likely check you with a metal detector or pat you down. This is completely normal for this area of the world. You will know the official security folks by their unique white and black uniforms (shown above). </div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
All of the markets in Asia will have a certain smell that just can't be described. Soon as you step foot inside the doors, you can smell the distinct smell. It is a mixture of fresh fish, seafood, poultry, pork, and other meats. Some people are repulsed by it, but I on the other hand find it very comforting. You will also get hints of <a href="http://chadcomptonblog.blogspot.com/2015/03/the-king-of-fruits.html" target="_blank">durian</a> and other asian fruits and veggies that are a bit out of the ordinary. If you are unfamiliar with the <a href="http://chadcomptonblog.blogspot.com/2015/03/the-king-of-fruits.html" target="_blank">durian</a> fruit, you can read about the <a href="http://chadcomptonblog.blogspot.com/2015/03/the-king-of-fruits.html" target="_blank">King of Fruits in my blog by clicking here</a>. This scent is so enticing to me, when I am in the United States, I seek out Asian Markets to shop in. It takes me back to my homes I have had abroad. <br />
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: right; text-align: right;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjT1q83a5nZAoerP01pmhXcgwb9zy80unfgSN7DjXsnLBG2Tla5ZHDAonFnLxzJBRWD_v2fUxrk53eJyO_un4HyqtkQ4jsikdhcVW7b4hxRVnj_9P5-66XRc7HwbGePGj6MTPkkYhf9DyQ/s1600/20150409_114147.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="150" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjT1q83a5nZAoerP01pmhXcgwb9zy80unfgSN7DjXsnLBG2Tla5ZHDAonFnLxzJBRWD_v2fUxrk53eJyO_un4HyqtkQ4jsikdhcVW7b4hxRVnj_9P5-66XRc7HwbGePGj6MTPkkYhf9DyQ/s200/20150409_114147.jpg" width="200" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><i>Packets of mayo with jars sold below.</i></td></tr>
</tbody></table>
<br />
Here in the Philippines, there are many ways to buy a certain product. You can purchase a regular size jar of an item lets say mayonnaise. Or you can a full sized packed of mayonnaise to refill your previous jar with. Or you can pick up single-serving packets of the mayonnaise. These single packets are actually bought up by people and taken to their road side store or stand in their local village in most cases. I am just using mayonnaise as an example. Any item for the most part can be purchased like this. The pinoy (relating to the Philippines or the Filipinos) seem to be a single-serving culture and I love them for that.<br />
<br />
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEicOy4izdnjxspO9arhJ1I8SzD88thIcWjETETrO_dGsZ64BTNwCXkrBnRpBZfPMOL0SeFB_J8rI8SwQsYb7vNJlVEbsVPYLp4JQBpAie0QJTbD6YEEh4_YFbJm1r1S7nb1UvMvs5-oEKs/s1600/IMG_0021.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="212" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEicOy4izdnjxspO9arhJ1I8SzD88thIcWjETETrO_dGsZ64BTNwCXkrBnRpBZfPMOL0SeFB_J8rI8SwQsYb7vNJlVEbsVPYLp4JQBpAie0QJTbD6YEEh4_YFbJm1r1S7nb1UvMvs5-oEKs/s320/IMG_0021.jpg" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><i>Roadside market showing the individual packets hanging.</i></td></tr>
</tbody></table>
If you are a creature of habit and wish to purchase specific brands that you have grown accustom to, you can find a lot of the same products on army bases, duty free stores, or some stores have a foreign section as well. Please be aware that these foreign products may be two or three times the cost of what you are use to paying in your home country. <br />
<br />
The Philippines are also really strict when it comes to rules. They have check out isles that are for certain shopping cart sizes (they refer to them by color and size). The orange carts are the hand held carts we are use to here in the United States, but they also can have a push cart that holds 2 of these hand held carts which is still makes it okay to check out in the orange cart isle. They also have a big cart check out and those usually vary in color, but are strictly referred to as Big Cart Isle. Then last but not least they have a Senior Citizen or Pregnant Isle to check out. Even if all the Big Cart Isles and the Orange Cart Isles are backed up with 10 or 15 people, they will not allow anyone who isn't a Senior or Pregnant to check out in the Senior or Pregnant Isle. Crazy but true fact.<br />
<br />
I hope this has helped you or entertained you in some way. If you have any questions, please feel free to ask. I will be glad to answer them. Thank you for taking the time to read my blog. <br />
<table style="width: 100%px;">
<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Text Ad On Blog -->
<ins class="adsbygoogle"
style="display:block"
data-ad-client="ca-pub-5641665550057503"
data-ad-slot="4442568677"
data-ad-format="auto"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<tbody>
<tr><td><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFk8wUgEJGNK7pBeDtuWRwNC2l7ffVT22cV_do31Hc4zwVrT9VS-qZktb0Ap2_muqtQQ_EG1mHLCRidGqzW3EZZP19wyGz_MqUBwKg-w3pFw3O3jJqwmdXQLQuShSkVoqEC4yjFycvAoY/s1600/20150417_113757.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFk8wUgEJGNK7pBeDtuWRwNC2l7ffVT22cV_do31Hc4zwVrT9VS-qZktb0Ap2_muqtQQ_EG1mHLCRidGqzW3EZZP19wyGz_MqUBwKg-w3pFw3O3jJqwmdXQLQuShSkVoqEC4yjFycvAoY/s320/20150417_113757.jpg" width="240" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><i>Senior & Pregnant Isle.</i></td></tr>
</tbody></table>
<br /></td>
<td><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLv9UNRMFMwzDuLq0FXQSOkrmRo4X8BaxFKTy8gqkH-3DAl0u9kA-aQWj0IgoIthaLqaMXvgfxpkPr0gUiOFJ6A4hHfxpnccy5AltL9iSdUUrn3mm6-m8crBNdL7Mw2fICWL2moh9Ht9I/s1600/20150417_113828.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLv9UNRMFMwzDuLq0FXQSOkrmRo4X8BaxFKTy8gqkH-3DAl0u9kA-aQWj0IgoIthaLqaMXvgfxpkPr0gUiOFJ6A4hHfxpnccy5AltL9iSdUUrn3mm6-m8crBNdL7Mw2fICWL2moh9Ht9I/s320/20150417_113828.jpg" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><i>Big Cart Isle.</i></td></tr>
</tbody></table>
<br /></td></tr>
</tbody></table>
<br />
<br />
If you like this post and want to see more, follow me on my website <a href="http://www.chadcompton.com/" target="_blank">www.chadcompton.com</a><br />
Or if you prefer...<br />
<a href="http://www.instagram.com/chad.compton" target="_blank"><img src="http://www.chadcompton.com/images/social/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" target="_blank"><img src="http://www.chadcompton.com/images/social/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/twitter.png" /></a>
<a href="https://github.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/github.png" /></a>
<a href="https://bitbucket.org/ccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/bitbucket.png" /></a>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
</div>Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0tag:blogger.com,1999:blog-4625247287479600024.post-68339339947111089282015-08-13T10:04:00.001-07:002015-10-08T18:11:01.778-07:00UPDATE A Column With Its Current Value With Addition (SQL)<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEillrxoMdUFJ9cj1iXJWLaN7hA_boU9_kT4ygEyBU6liKni1_KqqXlNniP36F9u4tImGWaSWn_dOBzanhIo95sZsoVTBC6CktWz44uetJ4OAGK6Y3Vreu-n8CwI_ayZWtDHWshGuUXC3Cc/s1600/11jat.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEillrxoMdUFJ9cj1iXJWLaN7hA_boU9_kT4ygEyBU6liKni1_KqqXlNniP36F9u4tImGWaSWn_dOBzanhIo95sZsoVTBC6CktWz44uetJ4OAGK6Y3Vreu-n8CwI_ayZWtDHWshGuUXC3Cc/s320/11jat.png" width="320" /></a></div>
This week I ran upon an issue in SQL where I needed to actually do a Google Search to find an answer. I knew how to do this in Visual Basic.Net (VB.Net), but had no clue how to do it via one single SQL statement which is my preferred method. I needed to UPDATE A Column with its current value with an additional word added. The column I was needing to update had multiple options. Below I will show you 2 ways to complete the same project and you see which one you prefer. <br />
<br />
I could have designed an update for every specific possible outcome and it would have worked just fine, but here lately I try to accomplish something with one perfect query. Below I will show you both ways that I am talking about. You can pick the best one for your project.<br />
<br />
Example.<br />
<br />
I have a table called tblTable and in that table I have a fields/columns called DocumentType and DateReceived. I wish to ADD the year to the end of specific DocumentTypes that were received in 2015 for archiving purposes. The DocumentType I wish to archive are Certificate and Report only.
<br />
Table original called tblTable.<br />
<br />
<div class="code notranslate" style="background-color: #f1f1f1; border: 1px solid rgb(221, 221, 221); box-sizing: border-box; color: #444444; font-family: Consolas, 'courier new'; font-size: 15px; line-height: 21.4285717010498px; margin: 0px 0px 12px; padding: 9.765625px; width: auto; word-wrap: break-word;">
<div style="box-sizing: border-box; font-size: 14px;">
<table style="width: 100%;">
<tbody>
<tr><td><span style="color: blue;"><b>DocumentName</b></span></td><td><span style="color: blue;"><b>DocumentType</b></span></td><td><span style="color: blue;"><b>DateReceived</b></span></td></tr>
<tr><td colspan="3"><hr />
</td></tr>
<tr><td>Cow.doc</td><td>Certificate</td><td>1/2/2015</td></tr>
<tr><td>Dog.doc</td><td>Entry </td><td>2/5/2015</td></tr>
<tr><td>Chicken.doc</td><td>Report</td><td>5/5/2015</td></tr>
<tr><td>Horse.doc</td><td>Entry</td><td>1/9/2015</td></tr>
<tr><td>Pig.doc </td><td>Certificate </td><td>8/8/2014</td></tr>
<tr><td>Pony.doc </td><td>Certificate </td><td>5/1/2015</td></tr>
</tbody></table>
<br /></div>
</div>
<br />
Table results after the SQL statements below.<br />
<br />
<div class="code notranslate" style="background-color: #f1f1f1; border: 1px solid rgb(221, 221, 221); box-sizing: border-box; color: #444444; font-family: Consolas, 'courier new'; font-size: 15px; line-height: 21.4285717010498px; margin: 0px 0px 12px; padding: 9.765625px; width: auto; word-wrap: break-word;">
<div style="box-sizing: border-box; font-size: 14px;">
<table style="width: 100%;">
<tbody>
<tr><td><span style="color: blue;"><b>DocumentName</b></span></td><td><span style="color: blue;"><b>DocumentType</b></span></td><td><span style="color: blue;"><b>DateReceived</b></span></td></tr>
<tr><td colspan="3"><hr />
</td></tr>
<tr><td><span style="color: red;">Cow.doc</span></td><td><span style="color: red;">Certificate 2015</span></td><td><span style="color: red;">1/2/2015</span></td></tr>
<tr><td>Dog.doc</td><td>Entry </td><td>2/5/2015</td></tr>
<tr><td><span style="color: red;">Chicken.doc</span></td><td><span style="color: red;">Report 2015</span></td><td><span style="color: red;">5/5/2015</span></td></tr>
<tr><td>Horse.doc</td><td>Entry</td><td>1/9/2015</td></tr>
<tr><td>Pig.doc </td><td>Certificate </td><td>8/8/2014</td></tr>
<tr><td><span style="color: red;">Pony.doc </span></td><td><span style="color: red;">Certificate 2015 </span></td><td><span style="color: red;">5/1/2015</span></td></tr>
</tbody></table>
</div>
</div>
<br />
<br />
The first way would be to do 2 separate update statements that would UPDATE each specific DocumentType with the desired results.<br />
<br />
<div class="code notranslate" style="background-color: #f1f1f1; border: 1px solid rgb(221, 221, 221); box-sizing: border-box; color: #444444; font-family: Consolas, 'courier new'; font-size: 15px; line-height: 21.4285717010498px; margin: 0px 0px 12px; padding: 9.765625px; width: auto; word-wrap: break-word;">
<div style="box-sizing: border-box; font-size: 14px;">
<b><span style="color: blue;">UPDATE tblScanDocs</span></b><br />
<b><span style="color: blue;">Set DocumentType = 'Report 2015'</span></b><br />
<b><span style="color: blue;">where DocumentType = 'Report' and YEAR(DateReceived) = '2015'</span></b><br />
<br />
And<br />
<br />
<span style="color: blue;"><b>UPDATE tblScanDocs</b></span><br />
<span style="color: blue;"><b>Set DocumentType = 'Certificate 2015'</b></span><br />
<span style="color: blue;"><b>where DocumentType = 'Certificate' and YEAR(DateReceived) = '2015'</b></span><br />
<br />
<br /></div>
</div>
The second way (the way I prefer) is to combine both of the above statements into one.<br />
<br />
<br />
<div class="code notranslate" style="background-color: #f1f1f1; border: 1px solid rgb(221, 221, 221); box-sizing: border-box; color: #444444; font-family: Consolas, 'courier new'; font-size: 15px; line-height: 21.4285717010498px; margin: 0px 0px 12px; padding: 9.765625px; width: auto; word-wrap: break-word;">
<div style="box-sizing: border-box; font-size: 14px;">
<span style="color: blue;"><b>UPDATE tblScanDocs</b></span><br />
<span style="color: blue;"><b>Set DocumentType = DocumentType + ' 2015'</b></span><br />
<span style="color: blue;"><b>where DocumentType in ('Certificate' , 'Report')</b></span><br />
<span style="color: blue;"><b>and YEAR(Datereceived) = '2015'</b></span></div>
</div>
<br />
Both ways will give you the desired outcome, but as you can see the second way would be a great time saver if you had quite a few DocumentTypes that needed to be updated.<br />
<div>
<br /></div>
If you like this post and want to see more, follow me on my website <a href="http://www.chadcompton.com/" target="_blank">www.chadcompton.com</a><br />
Or if you prefer...<br />
<a href="http://www.instagram.com/chad.compton" target="_blank"><img src="http://www.chadcompton.com/images/social/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" target="_blank"><img src="http://www.chadcompton.com/images/social/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/twitter.png" /></a>
<a href="https://github.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/github.png" /></a>
<a href="https://bitbucket.org/ccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/bitbucket.png" /></a>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0tag:blogger.com,1999:blog-4625247287479600024.post-66917372285630643982015-08-07T14:56:00.002-07:002015-08-17T19:05:55.177-07:00Aloe Vera Internal Benefits<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhecUfAEI0pnxqGQSO2VvEf5CfGJ1i4BRAxtWpgNjkQbgN1m0Guof29JG1DaC416rwzgUzt2btFdfis_DYm8w7Hk9yLHD-6hg4maRi6VQe0FiX_JXhc5n1CqKO-TA_wcIJJuwyWQWIsoA0/s1600/AloeVera.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="213" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhecUfAEI0pnxqGQSO2VvEf5CfGJ1i4BRAxtWpgNjkQbgN1m0Guof29JG1DaC416rwzgUzt2btFdfis_DYm8w7Hk9yLHD-6hg4maRi6VQe0FiX_JXhc5n1CqKO-TA_wcIJJuwyWQWIsoA0/s320/AloeVera.png" width="320" /></a></div>
During my years of travel to and from Asia, I have developed an acquired taste for a lot of the drinks and foods the different cultures have to offer. <br />
<br />
One of the unique items I can't get enough of is a nutritional drink known as Aloe Vera Water or Juice. Aloe vera juice contains leaf pulp that is rich in natural nutrients and fiber. The one that I normally drink is actually flavored with the essence of grapes. It tastes like a bight crisp water with the fibrous pulp from the aloe making it seem most like the inside of a grape itself. I actually started drinking it before I knew of its beneficial properties. Below are just a few of aloe's benefits when ingested by way of this nutritional drink.<br />
<br />
<b>Please do not consume aloe vera that isn't made for internal consumption.</b><br />
<br />
<h3>
<span style="color: #f54c00;">Heart Benefits</span></h3>
<hr color="#f54c00" />
<br />
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: right; margin-left: 1em; text-align: right;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgU6GfBFj2V6B81n1kG_qsMY8vP1tHTmbKy7wTX6-xnxhuBC8qnEE-2oQl_eketgk4TqPA0V8Fw6DZfg8FvrSn-r4yzVoGA7R6dGtW94n2fvKeJGGJjYKulnQ-wgrdAsZlOPuPzcEF7-Q8/s1600/aloe.jpg" imageanchor="1" style="clear: right; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgU6GfBFj2V6B81n1kG_qsMY8vP1tHTmbKy7wTX6-xnxhuBC8qnEE-2oQl_eketgk4TqPA0V8Fw6DZfg8FvrSn-r4yzVoGA7R6dGtW94n2fvKeJGGJjYKulnQ-wgrdAsZlOPuPzcEF7-Q8/s1600/aloe.jpg" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="color: #45c491;"><b>This is the Aloe Vera Water that I usually buy.<br />Mostly found in Asian Markets in the US.</b></span></td></tr>
</tbody></table>
Ingesting aloe vera helps improve the circulation of blood in the body. It helps fight blood clots in the arteries of the heart and body while reducing fatty deposits. Aloe helps stop the body's absorption of cholesterol, thus reducing overall cholesterol levels and promoting good health. <br />
<br />
<h3>
<span style="color: #f54c00;">Immune Benefits</span></h3>
<hr color="#f54c00" />
<br />
Aloe vera aid the immune system by ridding the body of harmful pathogens and toxins because it contains bacterial, anti-fungal, and anti-viral properties. It helps the immune system directly by reducing effect of allergies, arthritis, and other inflammatory immune disorders.<br />
<br />
<br />
<h3>
<b><span style="color: #f54c00;">Digestive Benefits</span></b></h3>
<hr color="#f54c00" />
<br />
When ingested, aloe vera contains nutrients that heal and soothe the lining of the digestive tract. Aloe can decrease irritation while aiding in the repair of ulcers in the mouth, stomach, and intestines. Aloe is an adaptogen that can increase healthy bacteria that regulate bowel movements, while easing acid reflux. It also contains a substance called anthraquinone, which is a natural laxative. Aloe rids the body of bad bacteria while regulating diarrhea and constipation. Aloe vera juice decreases inflammation in both the stomach and intestines thus helping in irritable bowel syndrome (IBS), colitis, and other inflammatory disorders of the stomach.<br />
<br />
<br style="background-color: white; color: #444444; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2000007629395px;" />
If you like this post and want to see more, follow me on my website <a href="http://www.chadcompton.com/" target="_blank">www.chadcompton.com</a><br />
Or if you prefer...<br />
<a href="http://www.instagram.com/chad.compton" target="_blank"><img src="http://www.chadcompton.com/images/social/Instagram.png" /></a>
<a href="http://chadcomptonblog.blogspot.com/" target="_blank"><img src="http://www.chadcompton.com/images/social/Blogger.png" /></a>
<a href="https://twitter.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/twitter.png" /></a>
<a href="https://github.com/rccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/github.png" /></a>
<a href="https://bitbucket.org/ccompton" target="_blank"><img src="http://www.chadcompton.com/images/social/bitbucket.png" /></a>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Chad Compton Designs -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-5641665550057503" data-ad-format="auto" data-ad-slot="2114347876" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>Anonymoushttp://www.blogger.com/profile/01293217540962731440noreply@blogger.com0