SELECT
DISTINCT RTRIM(dbo.dmbill.bi_name) AS bi_name,
dbo.dmbill.bi_id,
RTRIM(dbo.dmbill.bi_street) AS bi_street,
RTRIM(dbo.dmbill.bi_city) AS bi_city,
RTRIM(dbo.dmbill.bi_state) AS bi_state,
RTRIM(dbo.dmbill.bi_zip) AS bi_zip,
RTRIM(dbo.dmgrp.gr_name) AS BillingGroup,
RTRIM(dbo.dmbill.bi_contact) AS bi_contact,
RTRIM(dbo.dmbill.bi_phone) AS bi_phone,
rep.RepName,
pipedrive.d2_value AS PipedriveDealID,
mindate.mo_date AS BillToCreatedDate
FROM
dbo.dttord
1871年春天,一个年轻人看到一本书,里面有一句话对他的前途产生了巨大的影响。他是蒙特瑞医院的一个学生。他
当时正满怀忧虑,担心如何通过期末考试、要做什么、到哪里去,怎样才能开业、才能谋生等。
如今他已成为当时最有名的医学家,他创造了闻名世界的约翰·霍普斯金斯医学院,成为牛津大学的客座教授,并被英
王册封爵位。他的后半生无忧无虑,需要上千页的书才能记述他的一生。
他的名字叫做威廉·奥斯勒爵士。他在1871年春天看到的那句由汤姆斯·卡莱里所写的话,帮助他度过了无忧无虑的一
生,这句话就是:"对我们来说,首先要做的事情不是去观望遥远的将来,而是做手边的清晰之事。"
42年之后,在一个温暖的春夜,郁金香开满了校园,威廉·奥斯勒爵士正在对耶鲁大学的学生发表演讲。他对那些耶鲁
大学的学生们说,像他这样一位曾经在四所大学当过教授、写过一本很受欢迎的书的人,似乎应该有一个"特殊的头
脑",其实不然。他说,他的一些好朋友都知道,他的脑筋其实"最普通不过了"。
那么他成功的秘诀到底是什么呢?他认为,这完全是因为他生活在一个"只有今天的密封舱"里。他这句话是什么意思?
1871年春天,一个年轻人看到一本书,里面有一句话对他的前途产生了巨大的影响。他是蒙特瑞医院的一个学生。他
当时正满怀忧虑,担心如何通过期末考试、要做什么、到哪里去,怎样才能开业、才能谋生等。
如今他已成为当时最有名的医学家,他创造了闻名世界的约翰·霍普斯金斯医学院,成为牛津大学的客座教授,并被英
王册封爵位。他的后半生无忧无虑,需要上千页的书才能记述他的一生。
他的名字叫做威廉·奥斯勒爵士。他在1871年春天看到的那句由汤姆斯·卡莱里所写的话,帮助他度过了无忧无虑的一
生,这句话就是:"对我们来说,首先要做的事情不是去观望遥远的将来,而是做手边的清晰之事。"
42年之后,在一个温暖的春夜,郁金香开满了校园,威廉·奥斯勒爵士正在对耶鲁大学的学生发表演讲。他对那些耶鲁
大学的学生们说,像他这样一位曾经在四所大学当过教授、写过一本很受欢迎的书的人,似乎应该有一个"特殊的头
脑",其实不然。他说,他的一些好朋友都知道,他的脑筋其实"最普通不过了"。
那么他成功的秘诀到底是什么呢?他认为,这完全是因为他生活在一个"只有今天的密封舱"里。他这句话是什么意思?
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
#/etc/ssh/sshd_config
AllowTcpForwarding yes
GatewayPorts yes
systemctl restart ssh
// 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(
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
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
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
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_
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
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
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 =
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.
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
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