Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
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 tmp.COL1, tmp.COL2, tmp.COL3, tmp.COL4 FROM [SELECT TestA.COL1,TestA.COL2, TestA.COL3, TestA.COL4 FROM TestA UNION ALL SELECT TestB.COL1,TestB.COL2,TestB.COL3, TestB.COL4 FROM TestB ]. AS tmp GROUP BY tmp.COL1, tmp.COL2, tmp.COL3, tmp.COL4 HAVING (((Count(*))=1)) ORDER BY tmp.COL2, tmp.COL3;
|MS SQL Update query with connected table data||3||59|
|qry in a qry worked by week ending date! how do I get it to work by weeks (y-t-d) instead of one week at a time?||25||86|
|Access join syntax when converting to T-SQL query||4||44|
|Syntax issue with my Where Clause SQL 2012||20||38|