生活在今天的密封舱里

1871年春天,一个年轻人看到一本书,里面有一句话对他的前途产生了巨大的影响。他是蒙特瑞医院的一个学生。他
当时正满怀忧虑,担心如何通过期末考试、要做什么、到哪里去,怎样才能开业、才能谋生等。

如今他已成为当时最有名的医学家,他创造了闻名世界的约翰·霍普斯金斯医学院,成为牛津大学的客座教授,并被英
王册封爵位。他的后半生无忧无虑,需要上千页的书才能记述他的一生。

他的名字叫做威廉·奥斯勒爵士。他在1871年春天看到的那句由汤姆斯·卡莱里所写的话,帮助他度过了无忧无虑的一
生,这句话就是:"对我们来说,首先要做的事情不是去观望遥远的将来,而是做手边的清晰之事。"

42年之后,在一个温暖的春夜,郁金香开满了校园,威廉·奥斯勒爵士正在对耶鲁大学的学生发表演讲。他对那些耶鲁
大学的学生们说,像他这样一位曾经在四所大学当过教授、写过一本很受欢迎的书的人,似乎应该有一个"特殊的头
脑",其实不然。他说,他的一些好朋友都知道,他的脑筋其实"最普通不过了"。

那么他成功的秘诀到底是什么呢?他认为,这完全是因为他生活在一个"只有今天的密封舱"里。他这句话是什么意思?

生活在今天的密封舱里

1871年春天,一个年轻人看到一本书,里面有一句话对他的前途产生了巨大的影响。他是蒙特瑞医院的一个学生。他
当时正满怀忧虑,担心如何通过期末考试、要做什么、到哪里去,怎样才能开业、才能谋生等。

如今他已成为当时最有名的医学家,他创造了闻名世界的约翰·霍普斯金斯医学院,成为牛津大学的客座教授,并被英
王册封爵位。他的后半生无忧无虑,需要上千页的书才能记述他的一生。

他的名字叫做威廉·奥斯勒爵士。他在1871年春天看到的那句由汤姆斯·卡莱里所写的话,帮助他度过了无忧无虑的一
生,这句话就是:"对我们来说,首先要做的事情不是去观望遥远的将来,而是做手边的清晰之事。"

42年之后,在一个温暖的春夜,郁金香开满了校园,威廉·奥斯勒爵士正在对耶鲁大学的学生发表演讲。他对那些耶鲁
大学的学生们说,像他这样一位曾经在四所大学当过教授、写过一本很受欢迎的书的人,似乎应该有一个"特殊的头
脑",其实不然。他说,他的一些好朋友都知道,他的脑筋其实"最普通不过了"。

那么他成功的秘诀到底是什么呢?他认为,这完全是因为他生活在一个"只有今天的密封舱"里。他这句话是什么意思?

UAT Test | prev_initial_default_or_payoff

select fn.loan_id, 
	fn.installment_number as ins_n, 
	fn.period_start as p_strt, 
	fn.period_end as p_end,  
	fn.amount_owed_to_period as owed_to_prd,
	fn.amount_paid_to_period as paid_to_prd,
	fn.initial_default_cumulative as int_dft,
	fn.early_payoff_cumulative as e_payff_cum,
	fn.refinance_payoff_cumulative as r_payff_cum,
	fn.prev_initial_default_or_payoff
from dw_core.fact_installment fn
where fn.loan_id = 650229
order by fn.installment_number;

select fn.loan_id, 
	fn.installment_number a

Открыть туннелирование через SSH

#/etc/ssh/sshd_config

AllowTcpForwarding yes
GatewayPorts yes

systemctl restart ssh

Collect All Members of On-Call Groups

A quick and dirty script to get all the members of on-call groups which can be further parsed in Excel
// 1. Get all on-call shifts's unique groups
var gr = new GlideRecord('cmn_rota');
gr.query();

var uniqueGroupsArray = []; 

while (gr.next()) {
    var group = gr.group + '';
    if (uniqueGroupsArray.indexOf(group) == -1) {
        uniqueGroupsArray.push(group);
    }
}

gs.info('On-Call Groups: ' + uniqueGroupsArray.length);
// 2. Get all unique group's unique users
var uniqueUsersArray = [];

for (var i=0;i<uniqueGroupsArray.length;i++) {
    var grUsers = new GlideRecord(

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.