Cacher is the code snippet organizer for pro developers

SELECT
    dbo.dmprod.pr_codenum,
    dbo.dmd3.d3_value AS picklocation
FROM
    dbo.dtd2
    INNER JOIN dbo.dmd3 ON CAST(dbo.dtd2.d2_value AS int) = dbo.dmd3.d3_id
    INNER JOIN dbo.dmprod ON dbo.dtd2.d2_recid = dbo.dmprod.pr_id
WHERE
    (dbo.dtd2.d2_d1id = 134)

SELECT
    jo_jobnum,
    jo_closed,
    iif(
        jo_closed <> min(gl_date),
        FORMAT(min(gl_date), 'MM/dd/yyyy'),
        ''
    ) AS gl_date,
    dtjob3.ch_account AS paydetacct,
    dtjob3.payrolldetail,
    gldet.ch_account AS gldetacct,
    SUM(gl_debits) AS gldetail,
    dtjob3.payrolldetail - SUM(gl_debits) AS variance
FROM
    dtjob
    JOIN (
        SELECT
            j3_jobnum,
            ch_id,
            ch_account,
            SUM(ROUND(j3_modhour * 

SELECT
    dbo.dmprod.pr_codenum,
    dbo.dmprod.pr_descrip,
    SUM(dbo.dtpur.pu_ordman) AS Ordquant
FROM
    dbo.dtpur
    INNER JOIN dbo.dttpur ON dbo.dttpur.tp_recevd IS NULL
    AND dbo.dttpur.tp_ordtype IN ('p', 'r')
    AND dbo.dttpur.tp_id = dbo.dtpur.pu_tpid
    INNER JOIN dbo.dmprod ON dbo.dmprod.pr_id = dbo.dtpur.pu_prid
GROUP BY
    dbo.dmprod.pr_codenum,
    dbo.dmprod.pr_descrip

SELECT
    dbo.dmprod.pr_codenum AS PartNumber,
    dbo.dmprod.pr_descrip AS Description,
    ISNULL(lots.'lotquant', 0) AS Onhand,
    ISNULL(pur.'purquant', 0) AS OpenPurchaseOrders
FROM
    dbo.dmprod
    LEFT OUTER JOIN (
        SELECT
            SUM(fi_quant) AS 'lotquant',
            fi_prid
        FROM
            dbo.dtfifo
        WHERE
            (fi_zeroed IS NULL)
            AND (fi_type = '')
        GROUP BY
            fi_prid
    ) AS lots ON lots.fi_prid 

SELECT
    h.to_ordnum AS ordnum,
    h.to_dueship AS dueship,
    lastmoduser.userid
FROM
    dbo.dttord AS h
    INNER JOIN (
        SELECT
            MAX(to_id) AS id,
            to_ordnum
        FROM
            dbo.dttord
        WHERE
            (to_status = 'h')
        GROUP BY
            to_ordnum
    ) AS lastsale ON lastsale.id = h.to_id
    INNER JOIN (
        SELECT
            MAX(lo_id) AS logid,
            lo_recid
        FROM
            dbo.dxlog

SELECT
    dbo.dmprod.pr_retail AS [FB Code],
    dbo.dmprod.pr_codenum AS [Part Number],
    dbo.dmprod.pr_descrip AS Description,
    dbo.dtfifo.fi_userlot AS Lot,
    dbo.dtfifo.fi_balance AS Quantity,
    dbo.dtfifo.fi_postref AS Postref,
    dbo.dmware.wa_name AS Facility,
    dbo.dtfifo.fi_lotnum AS [System Lot],
    dbo.dmloc.lo_name AS Location,
    dbo.dtfifo.fi_date AS Date,
    dbo.dtfifo.fi_cost AS [Lot Cost],
    dbo.dtfifo.fi_cost * dbo.dtfifo.fi_balance AS Value,
    

SELECT
    dbo.dmprod.pr_codenum AS PartNumber,
    dbo.dmprod.pr_descrip AS Description,
    dbo.dmpr5.p5_name AS Brand,
    dbo.dmunit.un_factor AS Unit,
    dbo.dtd2.d2_value AS OzWeight,
    dbo.dmpr1.p1_name AS Protein
FROM
    dbo.dmprod
    LEFT OUTER JOIN dbo.dmpr5 ON dbo.dmpr5.p5_id = dbo.dmprod.pr_user9
    LEFT OUTER JOIN dbo.dmunit ON dbo.dmunit.un_id = dbo.dmprod.pr_unid
    LEFT OUTER JOIN dbo.dtd2 ON dbo.dtd2.d2_recid = dbo.dmprod.pr_id
    AND dbo.dtd2.d2_d1id = 32
 

SELECT
    dbo.dtjob.jo_jobnum,
    dbo.dtjob.jo_planstart,
    dbo.dtjob.jo_type,
    dbo.dtjob.jo_remarks,
    dbo.dtjob.jo_notes,
    dbo.dmware.wa_name,
    dbo.dtd2.d2_value,
    dbo.dmprod.pr_codenum,
    dbo.dmprod.pr_descrip,
    a.lj_quant,
    dbo.dmunit.un_name,
    dbo.dmpr3.p3_name,
    screencount.screen,
    RTEcount.RTE,
    Rawcount.Raw
FROM
    dbo.dtjob
    INNER JOIN dbo.dtljob AS a ON dbo.dtjob.jo_id = a.lj_joid
    INNER JOIN dbo.dmware ON dbo.dtjob.jo_wa

SELECT
    j4_jobnum,
    SUM(j4_fixmat * j4_quant) AS stanmat,
    SUM(j4_fixlab * j4_quant) AS stanlab,
    SUM(j4_fixmat * j4_quant + j4_fixlab * j4_quant) AS stantot
FROM
    dbo.dtjob4
GROUP BY
    j4_jobnum

SELECT
    colorpicklist.d3_value AS Color,
    dbo.dmprod.pr_unitwgt,
    dbo.dmunit.un_factor,
    0 AS avg_pct_increase,
    dbo.dmpr5.p5_name AS Brand,
    dbo.dmunit.un_name,
    dbo.dmprod.pr_codenum,
    dbo.dmprod.pr_descrip,
    CASE
        WHEN eggs.d2_value = 'Yes' THEN 'Eggs, '
        ELSE ''
    END + CASE
        WHEN fish.d2_value = 'Yes' THEN 'Fish, '
        ELSE ''
    END + CASE
        WHEN milk.d2_value = 'Yes' THEN 'Milk, '
        ELSE ''
    END + CASE

Collection<SampleModel> samples = getSamples();
ProcessTrackedRecord.SAMPLE.load(samples, exemplarContext);

Multimap<String, Long> activeExperimentRecIdsBySampleId = HashMultimap.create();

var enbManager = Manager.NOTEBOOK_EXPERIMENT_MANAGER.get(exemplarContext);

var templateNameById = enbManager.getTemplateExperimentInfoList(user).stream()
        .collect(Collectors.toMap(TemplateExperimentInfo::getTemplateId, TemplateExperimentInfo::getTemplateName));

var relatedExperiments = en

var categories = Enum.GetValues(typeof(CategoryType)).Cast<CategoryType>().ToList();

categories.Dump();

categories.ForEach(t => {
    (t == CategoryType.Category2).Dump();
});

public enum CategoryType
{
    Category1 = 1,
    Category2 = 2,
    Category3 = 3,
    Category4 = 4,
    Category5 = 5,
    Category6 = 6,
    Category7 = 7,
    Category8 = 8,
}

// 1. Clear mods
const chkBoxes = document.querySelectorAll('#tab-general .table tbody tr td:first-child input[type="checkbox"]');
chkBoxes.forEach(
	chkBox => {
		chkBox.checked = true;
	}
);
const clrBtn = document.querySelector('.page-header > .container-fluid > .pull-right > a[data-original-title="Clear"]');
clrBtn.click();

// 2. Refresh mods
const chkBoxes = document.querySelectorAll('#tab-general .table tbody tr td:first-child input[type="checkbox"]');
chkBoxes.forEach(
	chkBox => {
		chk

/**
 * @param {string} s
 * @param {number} k
 * @return {number}
 */
var longestIdealString = function(s, k) {
    // Initialize an array to keep track of the longest ideal string ending with each letter
    var dp = new Array(26).fill(0);

    // Iterate over each character in the string
    for (var i = 0; i < s.length; i++) {
        // Convert the current character to its corresponding integer (0-25)
        var c = s.charCodeAt(i) - 'a'.charCodeAt(0);

        // Initialize the maximum len

$IPAddressRegEx = '^(?:[0-9]{1,3}\.){3}[0-9]{1,3}$'