正文 

当前位置： 首页 > 知识 > java教程

text主片段(代码片段)

author author     2022-12-02     477

关键词： 

***************************************************************************************************************************************
***************************************************************************************************************************************
**************************************************input file stats / DUNS Matches*******************************************************
--Match stats Summary / Total technology installs to DUNS                    
SELECT count(DISTINCT ord.ID ) as 'Input Rows'                             
, COUNT(DISTINCT DUNSNumber) as 'Distinct Input DUNS'
,COUNT(hit_id) as 'Total Records'
, Count(distinct hit_id) as 'Unique Installs'
,COUNT(DISTINCT product_id) as 'Product Count'
from fulfillment.dbo.orderrequestdetail ord 
join fulfillment.dbo.ph_loc_duns_core u on ord.DUNSNumber = u.dnb_duns_nbr
where orderrequestid = 10710

--product breakdown summary matched to DUNS 
SELECT product_id as ProductID
, Product, Vendor
, category_parent as 'Category Parent'
, category as Category
, isnull(Attribute,'') Attributes
, count(DISTINCT ord.ID) as Installs
from fulfillment.dbo.orderrequestdetail ord 
join fulfillment.dbo.ph_loc_duns_core u on ord.DUNSNumber = u.dnb_duns_nbr
where orderrequestid = 10710 
Group BY product_id 
, Product, Vendor
, category_parent
, category 
, attribute
ORDER BY COUNT(*) DESC


--Full tech stack of prospects from DUNS Table
SELECT ord.ClientID as 'ClientID'
, [DUNSNumber]
, isnull(ord.[url],'') as URL
, ord.[Company] AS company
,ord.[Address1]
,ord.[City]
,ord.[State]
,ord.[Zip]
, product_id as ProductID
, Product
, Vendor
, date_first_verified as 'Date First Verified'
, date_last_verified as 'Date Last Verified'
, intensity as 'Intensity'
, category_parent as 'Category Parent'
, category as Category
, isnull(Attribute,'') Attributes
--, revenue_range as 'revenue'
--, employees_range as 'employees'
from fulfillment.dbo.orderrequestdetail ord 
join fulfillment.dbo.ph_loc_duns_core u on ord.DUNSNumber = u.dnb_duns_nbr
where orderrequestid = 10710
ORDER BY ord.id, vendor, product

--**********************************************************************************************************----
***************************************************************************************************************************************
                                                    URL Delivery Snippets
--*************************************************************************************************************************************                                                   
 --total breakout counts
SELECT count(DISTINCT ord.ID ) as 'Input Rows'  --Shows Count of Client Input Rows Matched
, COUNT(DISTINCT u.URL) as 'Total URLs'         --Shows Total Distinct URLs that Matched
,COUNT(hit_id) as 'Total Records'               --Shows Total Records Matched to Client File
,Count(DISTINCT hit_id) as 'Unique Installs'    --Shows Unque Installs we have at those Matched URLs
,COUNT(DISTINCT product_id) as 'Product Count'  --Shows Unique Products
from fulfillment.dbo.orderrequestdetail ord     --Client request Table ( Where Clients data was imported too)
join fulfillment.dbo.ph_url_global_all u on ord.url_match = u.url   --(matching to the URL GLobal ( Company Product Installs)
where OrderRequestID = 10710                     - Shows what client import


--product breakdown matched to URL / per product breakdown showing how many imput rows for each product
SELECT product_id as ProductID
, Product, Vendor
, category_parent as 'Category Parent'
, category as Category
, isnull(Attribute,'') Attributes
, count(DISTINCT ord.ID) as Installs
from fulfillment.dbo.orderrequestdetail ord 
join fulfillment.dbo.ph_url_global_all u on ord.url_match = u.url
where orderrequestid = 10710 
Group BY product_id 
, Product, Vendor
, category_parent
, category 
, attribute
ORDER BY COUNT(*) DESC

--Standard URL output  
select ord.ClientID as 'ClientID'
, [DUNSNumber]
, isnull(ord.[url],'') as URL
, ord.[Company] AS Company
,ord.[Address1]
,ord.[City]
,ord.[State]
,ord.[Zip]
,product_id as 'ProductID'
,Product
,Vendor
,date_first_verified as 'Date First Verified'
,date_last_verified AS 'Date Last Verified'
,intensity as 'Intensity'
,category_parent AS 'Category Parent'
,Category
,ISNULL(Attribute, '') AS 'Attributes'
--,revenue_range AS 'Revenue'
--,employees_range AS 'Employees'
--,top_level_industry AS 'Top Level Industry'
--,sub_level_industry AS 'Sub Level Industry'
--, ISNULL(hq_address, '') as 'HQ Address'
--, ISNULL(hq_city, '') as 'HQ City'
--, ISNULL(hq_state, '') as 'HQ State'
--, ISNULL(hq_zip, '') as 'HQ Zip'
--, ISNULL(hq_country, '') as 'HQ Country'
--, ISNULL(hq_phone, '') as 'HQ Phone'
from fulfillment.dbo.orderrequestdetail ord 
join fulfillment.dbo.ph_url_global_all u on ord.url_match = u.url
where OrderRequestID = 10710
ORDER BY ord.id, vendor, product

***************************************************************************************************************************************
                                                    Sample SAP Delivery Code
--************************************************************************************************************************************* 
-- Summary Counts
SELECT count(DISTINCT ord.ID ) as 'Input Rows Matched' 
, COUNT(DISTINCT u.dnb_duns_nbr) as 'Distinct Input DUNS'  --changed to u.dnb_duns_nbr from ord.DUNSNumber.  Client did not supply and input DUNS values
,COUNT(hit_id) as 'Total Records'
, Count(distinct hit_id) as 'Unique Installs'
,COUNT(DISTINCT product_id) as 'Product Count'
from fulfillment.dbo.orderrequestdetail ord 
join fulfillment.dbo.ph_loc_duns_core u on ord.URL_match = u.url
where OrderRequestID = 10691
--AND category_id IN(30) -- only ERP
AND category_id IN(30,36) -- ERP/HCM
AND date_last_verified >= dateadd(MONTH, -54, getdate())
AND ord.url_match = 'cvs.com'

--product breakdown summary matched to DUNS 
SELECT product_id as ProductID
, Product, Vendor
, category_parent as 'Category Parent'
, category as Category
, isnull(Attribute,'') Attributes
, count(DISTINCT ord.ID) as 'Input Rows'
, count(DISTINCT u.hit_id) as Installs
from fulfillment.dbo.orderrequestdetail ord 
join fulfillment.dbo.ph_loc_duns_core u on ord.URL_match = u.url
where OrderRequestID = 10691
--AND category_id IN(30) -- only ERP
AND category_id IN(30,36) -- ERP/HCM
AND date_last_verified >= dateadd(MONTH, -54, getdate())
AND ord.url_match = 'cvs.com'
Group BY product_id 
, Product, Vendor
, category_parent
, category 
, attribute
ORDER BY COUNT(*) DESC

--Full tech stack of prospects from DUNS Table
SELECT TOP 300 ord.Company as  'Client Company'
, url_match as 'URL'
,dnb_duns_nbr as 'DUNS'
,u.company as Company,
u.address as Address
,isnull(u.city,'') as City
,isnull(u.State,'') as State
,isnull(u.Zip,'') as Zip
,isnull(u.Country,'') as Country
, product_id as ProductID
, Product
, Vendor
, date_first_verified as 'Date First Verified'
, date_last_verified as 'Date Last Verified'
, intensity as 'Intensity'
, category_parent as 'Category Parent'
, category as Category
, isnull(Attribute,'') Attributes
, u.dnb_sales_volume_us Revenue
, u.dnb_emp_total Employees
, u.sic_2 SIC2
, u.sic_2_description 'SIC2 Description'
, u.sic_3 SIC3
, u.sic_3_description 'SIC3 Description'
, u.sic_4 SIC4
, u.sic_4_description 'SIC4 Description'
from fulfillment.dbo.orderrequestdetail ord 
join fulfillment.dbo.ph_loc_duns_core u on ord.URL_match = u.url
where OrderRequestID = 10691
--AND category_id IN(30) -- only ERP
AND category_id IN(30,36) -- ERP/HCM
AND date_last_verified >= dateadd(MONTH, -54, getdate())
ORDER BY ord.Company, u.dnb_duns_nbr, u.vendor, u.product --added Order BY statement

text添加自定义主循环辅助功能(代码片段)

查看详情

text将类添加到主菜单链接(代码片段)

查看详情

text使用主分支保持gh-pages最新(代码片段)

查看详情

text[.leptonrc的模板]这是lepton配置文件的模板。请将它放在您的主目录中。#lepton(代码片段)

查看详情

十二.gui(代码片段)

tkinter模块(tkinter是一个跨平台的PythonGUI工具包)：#Tkinter是一个跨平台的PythonGUI工具包importtkintertop=tkinter.Tk()#可以不写btn=tkinter.Button()#pack()控制从属控件在所属主体内部出现的位置btn.pack()btn["text"]="ClickMe!"defclicked():print("Iwasclicked!")... 查看详情

echars简单总结(代码片段)

1、title标题title:show:true,//显示策略，默认值true,可选为：true（显示）|false（隐藏）text:'主标题',//主标题文本，'\\n'指定换行link:'',//主标题文本超链接,默认值truetarget:nul 查看详情

xpath(代码片段)

lxml模块如何使用fromlxmlimportetreeelement=etree.HMTL(str,bytes)element.xpath("xpath表达式")etree.tostring(element)#把element转化为字符串xpath有哪些常用方法//从任意位置选择节点//a/text()a下的文本//a/text()//a//text()a下所有的文本.当前路径@符号a/@hrefdi... 查看详情

事件应用于授权子窗体传递验证数据给主窗体(代码片段)

一、事件定义类，即子窗体 usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingDataMaint 查看详情

wpf弹窗(代码片段)

效果：主窗体打开弹窗ModifyTextDialogprivatevoidModifyTextClick(objectsender,RoutedEventArgse) ModifyTextDialogdialog=newModifyTextDialog(myTextBlock.Text); varr=dialog.ShowDialog();//得到弹窗返回结果，如果是true if(r.HasValue&&r.Value==true) myTextBlock.Text=dialog.my... 查看详情

qt_4-qmainwindow(代码片段)

QT_4QMainWindowQMainWindow是一个为用户提供主窗口程序的类，包含一个菜单栏（menubar）、多个工具栏(toolbars)、多个锚接部件(dockwidgets)、一个状态栏(statusbar)及一个中心部件(centralwidget)，是许多应用程序的基础，如文本编辑器，图片... 查看详情

text片段(代码片段)

查看详情

text片段(代码片段)

查看详情

text片段(代码片段)

查看详情

text代码片段很有用(代码片段)

查看详情

text代码片段【snl】(代码片段)

查看详情

text测试片段(代码片段)

查看详情

text片段沟通(代码片段)

查看详情

text测试片段(代码片段)

查看详情