<style>p { margin: 0; }span.fr-emoticon.fr-emoticon-img { background-repeat: no-repeat !important; font-size: inherit; height: 1em; width: 1em; min-height: 20px; min-width: 20px; display: inline-block; margin: -0.1em 0.1em 0.1em; line-height: 1; vertical-align: middle; } span.fr-emoticon { font-weight: normal; font-family: "Apple Color Emoji", "Segoe UI Emoji", "NotoColorEmoji", "Segoe UI Symbol", "Android Emoji", "EmojiSymbols"; display: inline; line-height: 0; } blockquote { border-left: solid 2px #5e35b1; color: #5e35b1; margin-left:0; padding-left:5px;}blockquote blockquote{ border-color: #00bcd4; color: #00bcd4;}blockquote blockquote blockquote{ border-color: #43a047; color: #43a047;} table.grid{ border-collapse: collapse;} table.grid td, table.grid th { border: 1px solid #ddd;} .fr-fic.fr-dib{ display: block; margin: 5px auto;}.fr-fic.fr-dib.fr-fir{ text-align: right; margin: 5px 0 5px auto;}.fr-fic.fr-dib.fr-fil{ text-align: left; margin: 5px auto 5px 0;}.fr-fic.fr-dii{ float: none; margin: 5px auto;}.fr-fic.fr-dii.fr-fil{ float: left; margin: 5px auto;}.fr-fic.fr-dii.fr-fir{ float: right; margin: 5px auto;}img.fr-dib.fr-fir { margin-right: 0; text-align: right;}img.fr-dib.fr-fil { margin-left: 0; text-align: left;}img.fr-dib { margin: 5px auto; display: block; float: none;}img.fr-bordered { box-sizing: content-box; border: solid 5px #CCC;}img.fr-shadow { box-shadow: 10px 10px 5px 0px #cccccc;}img.fr-rounded { border-radius: 10px; -moz-border-radius: 10px; -webkit-border-radius: 10px; -moz-background-clip: padding; -webkit-background-clip: padding-box; background-clip: padding-box;}</style><p><br id="isPasted"><img data-fr-image-pasted="true" src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImRlMzMzNTIzLTllZDQtNDg1My04ZDU1LTI5NjQyMWM4NDQxOSJ9.Cnk1tMaThCP7ixXBZ_i9me6mjEHDydvcisx0P5z-brE" width="383" style="box-sizing: inherit; border-style: none; cursor: pointer; padding: 0px 1px; user-select: none; text-align: left; color: rgb(0, 0, 0); font-family: sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; width: 383px; height: 315.274px; max-width: none !important;" class="fr-fil fr-dib" height="315.274"><br></p>
<style>p { margin: 0; }span.fr-emoticon.fr-emoticon-img { background-repeat: no-repeat !important; font-size: inherit; height: 1em; width: 1em; min-height: 20px; min-width: 20px; display: inline-block; margin: -0.1em 0.1em 0.1em; line-height: 1; vertical-align: middle; } span.fr-emoticon { font-weight: normal; font-family: "Apple Color Emoji", "Segoe UI Emoji", "NotoColorEmoji", "Segoe UI Symbol", "Android Emoji", "EmojiSymbols"; display: inline; line-height: 0; } blockquote { border-left: solid 2px #5e35b1; color: #5e35b1; margin-left:0; padding-left:5px;}blockquote blockquote{ border-color: #00bcd4; color: #00bcd4;}blockquote blockquote blockquote{ border-color: #43a047; color: #43a047;} table.grid{ border-collapse: collapse;} table.grid td, table.grid th { border: 1px solid #ddd;} .fr-fic.fr-dib{ display: block; margin: 5px auto;}.fr-fic.fr-dib.fr-fir{ text-align: right; margin: 5px 0 5px auto;}.fr-fic.fr-dib.fr-fil{ text-align: left; margin: 5px auto 5px 0;}.fr-fic.fr-dii{ float: none; margin: 5px auto;}.fr-fic.fr-dii.fr-fil{ float: left; margin: 5px auto;}.fr-fic.fr-dii.fr-fir{ float: right; margin: 5px auto;}img.fr-dib.fr-fir { margin-right: 0; text-align: right;}img.fr-dib.fr-fil { margin-left: 0; text-align: left;}img.fr-dib { margin: 5px auto; display: block; float: none;}img.fr-bordered { box-sizing: content-box; border: solid 5px #CCC;}img.fr-shadow { box-shadow: 10px 10px 5px 0px #cccccc;}img.fr-rounded { border-radius: 10px; -moz-border-radius: 10px; -webkit-border-radius: 10px; -moz-background-clip: padding; -webkit-background-clip: padding-box; background-clip: padding-box;}</style><div id="isPasted" style="color: #000000;background-color: #fffffe;font-family: Consolas, 'Courier New', monospace;font-weight: normal;font-size: 14px;line-height: 19px;white-space: pre;"><strong><span style="font-family: Calibri; font-size: 12pt;">Example below</span></strong><br><br><br></div><div id="isPasted" style="color: #000000;background-color: #fffffe;font-family: Consolas, 'Courier New', monospace;font-weight: normal;font-size: 14px;line-height: 19px;white-space: pre;"><span style="color: #0000ff;">select</span><span style="color: #000000;"> </span><span style="color: #c700c7;">count</span><span style="color: #000000;">(did) </span><span style="color: #0000ff;">as</span><span style="color: #000000;"> [Quantity]</span><br><br><span style="color: #0000ff;">from</span><span style="color: #000000;"> device</span><br><br><span style="color: #778899;">left</span><span style="color: #000000;"> </span><span style="color: #778899;">join</span><span style="color: #000000;"> xtype </span><span style="color: #0000ff;">on</span><span style="color: #000000;"> ttypenum </span><span style="color: #778899;">=</span><span style="color: #000000;"> dtype</span><br><br><span style="color: #0000ff;">where</span><span style="color: #000000;"> dsite </span><span style="color: #778899;">in</span><span style="color: #000000;"> (</span><span style="color: #0000ff;">select</span><span style="color: #000000;"> ssitenum </span><span style="color: #0000ff;">from</span><span style="color: #000000;"> site </span><span style="color: #0000ff;">where</span><span style="color: #000000;"> sarea</span><span style="color: #778899;">=</span><span style="color: #000000;"> (</span><span style="color: #0000ff;">select</span><span style="color: #000000;"> ihaarea </span><span style="color: #0000ff;">from</span><span style="color: #000000;"> invoiceheader </span><span style="color: #0000ff;">where</span><span style="color: #000000;"> ihid</span><span style="color: #778899;">=</span><span style="color: rgb(65, 168, 95);">$INVOICEID</span><span style="color: #000000;">))</span><br><span style="color: #778899;">and</span><span style="color: #000000;"> (tdesc </span><span style="color: #778899;">like</span><span style="color: #000000;"> </span><span style="color: #ff0000;">'%Workstation%'</span><span style="color: #000000;"> </span><span style="color: #778899;">OR</span><span style="color: #000000;"> tdesc </span><span style="color: #778899;">like</span><span style="color: #000000;"> </span><span style="color: #ff0000;">'%IPSec Tunnel%'</span><span style="color: #000000;">) </span><span style="color: #778899;">and</span><span style="color: #000000;"> tdesc </span><span style="color: #778899;">NOT</span><span style="color: #000000;"> </span><span style="color: #778899;">like</span><span style="color: #000000;"> </span><span style="color: #ff0000;">'%Switch%'</span></div>
