Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
SELECT UPPER(RTRIM(Prempl.ffname)) as fstname, UPPER(RTRIM(Prempl.fname)) as lstname, Jodrtg.fuprodtime, Ladetail.fdate,Ladetail.fempno,Ladetail.fstatus,Ladetail.fcompqty, Ladetail.fjobno,Ladetail.flabtype,Ladetail.foperno,Ladetail.fpro_id, Ladetail.fscrpqty,Ladetail.fedatetime,Ladetail.fsdatetime,Ladetail.fjobno+STR(Ladetail.foperno,4) as Jobopkey,Ladetail.fchrglab, Ladetail.fcEarnCode,Ladetail.fcDept, CASE WHEN Ladetail.flabtype = 'P' THEN Ladetail.Fchrglab * 60 ELSE DateDiff(mi, Ladetail.fsdatetime, Ladetail.fedatetime)*60 END AS LABSeconds, Round(DateDiff(mi, Ladetail.fsdatetime, Ladetail.fedatetime),4) as LABMIN, SUBSTRING(CONVERT(CHAR(19),ladetail.fsdatetime,100),13,7) AS NSHOUR, SUBSTRING(CONVERT(CHAR(19),ladetail.fedatetime,100),13,7) AS NEHOUR, ladetail.fdate+(7-(cast(datepart(dw,ladetail.fdate) as int))) AS labweek FROM ladetail LEFT OUTER JOIN prempl ON Ladetail.fempno = Prempl.fempno LEFT OUTER JOIN jodrtg ON Ladetail.fjobno = Jodrtg.fjobno AND Ladetail.foperno = Jodrtg.foperno where ladetail.fjobno = '30915-0000'
|AD permissions required to allow computer objects and service accounts to register SPNs||1||29|
|SQL query and VBA||5||46|
|Teradata SQL - Is it possible to take each line item and turn into column headers.||2||27|
|SQL Recursion schedule||13||16|