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.
------------ Query One -------------- SELECT endshare.orderno, endshare.ship_via, endshare.nvalue, endshare.bill_weigh, endshare.sname, endshare.scompany, endshare.saddr1, endshare.saddr2, endshare.scity, endshare.sstate, endshare.szipcode, endshare.scountry, endshare.sphone1, endshare.semail, endshare.usi_status, endshare.ship_date, endshare.BOX_ID, endshare.ORDERNO, ProductType.searchtext FROM endshare join items on items.orderno = endshare.orderno join stock on items.item = stock.number join ProductType on stock.assoc = ProductType.prodtype WHERE endshare.orderno=318850 ------------ Query Two -------------- DECLARE @searchtext VARCHAR(1024) SELECT @searchtext = COALESCE(@searchtext + ',', '') + searchtext FROM ProductType SELECT ProductType = @searchtext
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.