Cheat Sheet Per Bag Details

SELECT
    dbo.dmprod.pr_codenum,
    dbo.dmprod.pr_descrip,
    RTRIM(dbo.dmcats2.c2_name) + ': ' + RTRIM(dbo.dmunit.un_name) + CASE
        WHEN pr_descrip LIKE '%Tower%' THEN ' - Tower '
        WHEN pr_descrip LIKE '%Shipper%' THEN ' - Shipper '
        WHEN pr_descrip LIKE '%Walmart%' THEN ' - Walmart '
        WHEN pr_descrip LIKE '%Sam%' THEN ' - Sams '
        ELSE ''
    END AS [Group],
    RTRIM(dbo.dmpr5.p5_name) AS Brand,
    RTRIM(dbo.dmpr2.p2_name) AS Class,
    RTRIM(d

Cheat Sheet Per Bag

SELECT
    RTRIM(dbo.dmcats2.c2_name) + ': ' + RTRIM(dbo.dmunit.un_name) + CASE
        WHEN pr_descrip LIKE '%Tower%' THEN ' - Tower '
        WHEN pr_descrip LIKE '%Shipper%' THEN ' - Shipper '
        WHEN pr_descrip LIKE '%Walmart%' THEN ' - Walmart '
        WHEN pr_descrip LIKE '%Sam%' THEN ' - Sams '
        ELSE ''
    END AS [Group],
    RTRIM(dbo.dmpr5.p5_name) AS Brand,
    RTRIM(dbo.dmpr2.p2_name) AS Class,
    RTRIM(dbo.dmpr1.p1_name) AS Protein,
    RTRIM(dbo.dmd3.d3_val

Chart of Accounts

SELECT
    dbo.dmchrt.ch_id,
    LEFT (dbo.dmchrt.ch_account, 5) + '-' + SUBSTRING(CAST(dbo.dmchrt.ch_account AS varchar), 6, 2) + '-' + SUBSTRING(CAST(dbo.dmchrt.ch_account AS varchar), 8, 3) + '-' + SUBSTRING(CAST(dbo.dmchrt.ch_account AS varchar), 11, 1) AS ch_account,
    RTRIM (dbo.dmchrt.ch_name) AS ch_name,
    dbo.dmchrt.ch_type,
    cb2.d3_value AS CostingBucket,
    pl2.d3_value AS PLCategory
FROM
    dbo.dmchrt
    LEFT OUTER JOIN dbo.dtd2 AS cb ON cb.d2_recid = dbo.dmchrt.ch

Broker Deal Sheet Item Master Info

SELECT
    RTRIM(dbo.dmcats2.c2_name) + ': ' + RTRIM(dbo.dmunit.un_name) + CASE
        WHEN pr_descrip LIKE '%Tower%' THEN ' - Tower '
        WHEN pr_descrip LIKE '%Shipper%' THEN ' - Shipper '
        WHEN pr_descrip LIKE '%Walmart%' THEN ' - Walmart '
        WHEN pr_descrip LIKE '%Sam%' THEN ' - Sams '
        ELSE ''
    END AS [Group],
    dbo.dmcats2.c2_id AS [Subcategory ID],
    RTRIM(dbo.dmpr5.p5_name) AS Brand,
    RTRIM(dbo.dmpr2.p2_name) AS Class,
    RTRIM(dbo.dmpr1.p1_

Broker Deal Entry Sales Rep

SELECT
  TOP (1000) RTRIM(dbo.dmsman.sm_fname) AS [First Name],
  RTRIM(dbo.dmsman.sm_lname) AS [Last Name],
  dbo.dmsman.sm_id,
  RTRIM(dbo.dmsgrp.sg_name) AS [Group],
  dbo.dmsgrp.sg_id,
  RTRIM(dbo.dmsman.sm_city) + ', ' + RTRIM(dbo.dmsman.sm_state) AS Lookup,
  Email.d2_value AS RepEmail
FROM
  dbo.dmsman
  INNER JOIN dbo.dmsgrp ON dbo.dmsgrp.sg_id = dbo.dmsman.sm_sgid
  LEFT OUTER JOIN dbo.dtd2 AS Email ON Email.d2_recid = dbo.dmsman.sm_id
  AND Email.d2_d1id = 185
WHERE
  (db

BOM Green Yield v2

SELECT
  s4.pr_codenum AS partnum,
  s4.pr_descrip AS partdescrip,
  SUM(
    (
      (
        (stage3.bo_quant / stage3.re_yield) * (stage2.bo_quant / stage2.re_yield)
      ) * (stage1.bo_quant / stage1.re_yield)
    ) * (stage0.bo_quant / stage0.re_yield)
  ) AS s0tot,
  SUM(
    (stage3.bo_quant / stage3.re_yield) * (stage2.bo_quant / stage2.re_yield)
  ) AS s2tot,
  1 AS One
FROM
  dbo.dmprod AS s4
  INNER JOIN (
    SELECT
      rs4.re_prid,
      bs3.bo_prid,
      rs

BOM Green Yield

SELECT
  s4.pr_codenum AS partnum,
  s4.pr_descrip AS partdescrip,
  SUM(
    (
      (
        (stage3.bo_quant / stage3.re_yield) * (stage2.bo_quant / stage2.re_yield)
      ) * (stage1.bo_quant / stage1.re_yield)
    ) * (stage0.bo_quant / stage0.re_yield)
  ) AS s0tot
FROM
  dbo.dmprod AS s4
  INNER JOIN (
    SELECT
      rs4.re_prid,
      bs3.bo_prid,
      rs4.re_yield,
      bs3.bo_quant
    FROM
      dbo.dmrev AS rs4
      INNER JOIN dbo.dmbom AS bs3 ON rs4.re_id =

Bags Sold v2

SELECT
    Sold.pr_codenum AS SoldPart,
    Sold.pr_descrip AS SoldDescrip,
    dbo.dmpr3.p3_name AS Stage,
    Bag.pr_codenum AS Part,
    Bag.pr_descrip AS Descrip,
    dbo.dmpr5.p5_name AS Brand,
    dbo.dmpr2.p2_name AS Class,
    dbo.dmpr1.p1_name AS Protein,
    dbo.dttord.to_shipped AS Shipped,
    SUM(dbo.dtord.or_qship) AS ShippedQty,
    dbo.dmbom.bo_quant,
    dbo.dmrev.re_yield,
    dbo.dmbom.bo_quant / dbo.dmrev.re_yield AS Bags
FROM
    dbo.dtord
    INNER JOIN dbo.

Bags Sold Sams Club

SELECT
    dbo.dmship.sh_name AS Store,
    dbo.dmprod.pr_codenum AS Part,
    dbo.dmprod.pr_descrip AS Descrip,
    dbo.dmpr3.p3_name AS Stage,
    dbo.dmpr5.p5_name AS Brand,
    dbo.dmpr2.p2_name AS Class,
    dbo.dmpr1.p1_name AS Protein,
    dbo.dmprod.pr_reorder AS Min1,
    dbo.dmprod.pr_maxquan1 AS Max1,
    dbo.dttord.to_shipped AS Shipped,
    SUM(dbo.dtord.or_qship) AS ShippedQty
FROM
    dbo.dtord
    INNER JOIN dbo.dmprod ON dbo.dtord.or_prid = dbo.dmprod.pr_id
    IN

Bags Sold By Month

SELECT
  Sold.pr_codenum AS SoldPart,
  Sold.pr_retail AS SoldRetail,
  Sold.pr_descrip AS SoldDescrip,
  dbo.dmpr3.p3_name AS SoldStage,
  dbo.dmbill.bi_id,
  dbo.dmbill.bi_name AS BTCust,
  dbo.dmship.sh_id,
  dbo.dmship.sh_name AS STCust,
  rep.RepID,
  rep.RepName,
  Bag.pr_codenum AS BagPart,
  Bag.pr_retail AS BagRetail,
  Bag.pr_descrip AS BagDescrip,
  Bag.pr_user1 AS BagFlavor,
  prodtype.d3_value AS BagProdType,
  dbo.dmpr5.p5_name AS BagBrand,
  dbo.dmpr2.p2_name AS B

Bags Sold

SELECT
    Sold.pr_codenum AS SoldPart,
    Sold.pr_descrip AS SoldDescrip,
    dbo.dmpr3.p3_name AS Stage,
    Bag.pr_codenum AS Part,
    Bag.pr_descrip AS Descrip,
    dbo.dmpr5.p5_name AS Brand,
    dbo.dmpr2.p2_name AS Class,
    dbo.dmpr1.p1_name AS Protein,
    dbo.dttord.to_shipped AS Shipped,
    SUM(dbo.dtord.or_qship) AS ShippedQty,
    dbo.dmbom.bo_quant,
    dbo.dmrev.re_yield,
    dbo.dmbom.bo_quant / dbo.dmrev.re_yield AS Bags
FROM
    dbo.dtord
    INNER JOIN dbo.

Approaching Year

SELECT
  dbo.dmprod.pr_codenum,
  dbo.dmprod.pr_descrip,
  dbo.dmunit.un_name,
  lessyear.less,
  lessyear.less * dbo.dmprod.pr_fixstan AS lessdol,
  lessthirty.thirty,
  lessthirty.thirty * dbo.dmprod.pr_fixstan AS thirtydol,
  lesssixty.sixty,
  lesssixty.sixty * dbo.dmprod.pr_fixstan AS sixtydol,
  lessninety.ninety,
  lessninety.ninety * dbo.dmprod.pr_fixstan AS ninetydol
FROM
  dbo.dmprod
  INNER JOIN dbo.dmunit ON dbo.dmprod.pr_unid = dbo.dmunit.un_id
  LEFT OUTER JOIN (
  

2. Text to Speech with HuggingFace.js Inference

# Text to Speech with HuggingFace.js Inference

**model:** [`espnet/kan-bayashi_ljspeech_vits`](https://huggingface.co/espnet/kan-bayashi_ljspeech_vits)

`hf-logo.svg`
```svg
<svg xmlns="http://www.w3.org/2000/svg" width="95" height="88" fill="none">
	<path fill="#FFD21E" d="M47.21 76.5a34.75 34.75 0 1 0 0-69.5 34.75 34.75 0 0 0 0 69.5Z"/>
	<path fill="#FF9D0B" d="M81.96 41.75a34.75 34.75 0 1 0-69.5 0 34.75 34.75 0 0 0 69.5 0Zm-73.5 0a38.75 38.75 0 1 1 77.5 0 38.75 38.75 0 0 1-77.5 0Z"/>
	<path 

28022024

inicio{
"host":"2110046DFF7EF761FB4A2061E24E",
"porta":"65DB51D1"
}fim

Quiz CSS show/hide display

Use checkbox to display/hide an answer. ![](https://cdn.cacher.io/attachments/u/3m1cbtt5dsmw3/7_jr1FGG1Ysj2jIGeztYSpIxlR2d5nZm/yho14obkm.png)
 <section>
        <h2>Quiz 1</h2>
        <p class="question-1">
          Question 1, what Is a Latin looking placeholder text for design?
        </p>
        <label for="button-reveal-answer-1"> Show Answer</label>
        <input
          type="checkbox"
          id="button-reveal-answer-1"
          class="button-reveal-answer-1"
        />
        <!-- <button class="button-reveal-answer-1">Show answer</button> -->

        <p class="answer-1">
          Answer: Lorem ipsum dolor Sit ame

Raw Waste Report

SELECT
  results.jo_jobnum,
  results.jo_closed,
  linepart.pr_codenum AS jobpart,
  linepart.pr_descrip AS jobpartdesc,
  bompart.pr_codenum AS bomlinepart,
  bompart.pr_descrip AS bomlinepartdesc,
  rel.relieved - ISNULL(unrel.unrelieved, 0) AS Relieved,
  fin.finquant AS finished
FROM
  (
    SELECT
      dbo.dtjob.jo_jobnum,
      dbo.dtjob.jo_closed,
      dbo.dtljob.lj_id,
      dbo.dtljob.lj_prid,
      dbo.dmbom.bo_prid
    FROM
      dbo.dtjob
      INNER JOIN dbo.dtl