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.
SELECT o.OrderDate, o.OrderRef, c.ClientCode, oi.Quantity, sno.Snos FROM tblOrders o INNER JOIN tblOrderItems oi ON o.OrderID = oi.OrderID INNER JOIN ( SELECT CatID, ClientCode FROM tblCatalogue WHERE TrackSerialNumbers = 1 ) c ON oi.CatID = c.CatID INNER JOIN ( SELECT a.OrderID, s.CatID, COUNT(s.SerialNumber) AS Snos FROM tblSerialNumbers s INNER JOIN tblAirwayBills a ON s.AirwayBillID = a.AirwayBillID GROUP BY OrderID, CatID ) sno ON o.OrderID = sno.OrderID AND sno.CatID = oi.CatID WHERE o.OrderID > 184876 AND (oi.Quantity <> sno.Snos) Order By o.OrderID Desc
|Is there any Easy way to copy CSV to SQL Server using C#||3||91|
|How to query LOCK_ESCALATION||4||42|
|Why is the output of this function is like this?||4||38|
|Gettg error - Please help Msg 252, Level 16, State 1, Line 1||3||30|