SELECT Number FROM [db1].[dbo].[Table] INTERSECT SELECT Number FROM [db2].[dbo].[Table]
SELECT * FROM cards WHERE ftCertNumber in (700000004741, 700000002395)
add as many values as you need
SELECT column FROM table GROUP BY column HAVING count(*) > 1;
Put three formulas in cells and then make a Pie chart from the three results.
=COUNTIFS(A1:A47, “>0%”, A1:A47, “<=50%”)
=COUNTIFS(A1:A47, “>50%”, A1:A47, “<=70%”)
=COUNTIFS(A1:A47, “>70%”, A1:A47, “<=100%”)
This is for viewing only, using Powershell…
GUI Display; supports sorting, filtering:
Import-Csv yourfile.csv |Out-GridView
select * from (select Col1,Col2 from table1 Union select Col1,Col2 from table2 )t where yourconditions
go into “Query”->”Query Options…”, grid tab, and check “include column headers when copying or saving results”
Right click on grid results and click “Save Results As” and save it.
If your results are not in grid format (which they should be), right click where you write the query, hover “Results To” and click “Results To Grid”
SELECT * FROM [database1].[dbo].[Gift]
UNION SELECT * FROM [database2].[dbo].[Gift]
optional stuff goes after – order by, blah blah blah
+1 40-VOIP-INFO (408-647-4636)
calling the 408 number says that “This number has been changed to the 631 number, but either number works.