SELECT COL_TO_CHECK, COUNT(COL_TO_CHECK) FROM table1 GROUP BY COL_TO_CHECK HAVING COUNT(*) > 1 ORDER BY COUNT(*) If there is more than 1 column with that value it will show up like: COL_TO_CHECK COUNT(COL_TO_CHECK) ————————————————————- Value 3 Value2 2 Value99 4
Find bank owned properties from the bank’s website: USBank Chase M&T Bank of America Key Bank Wells Fargo PNC
Create connection string:SqlConnection conn = new SqlConnection(“Data Source=DATASOURCE\\\\SQLEXPRESS;Initial Catalog=DATABASE_NAME;Integrated Security=True”); try { conn.Open(); SqlCommand sql = new SqlCommand(“SELECT * FROM tableName”, conn); SqlDataReader reader = sql.ExecuteReader(); while (reader.Read()) { this.TARGET_ID.InnerHtml += reader[“column”] ; } } catch (SqlException sqle) { sqle.Message.ToString(); }
This sign is posted at a BP gas station. “Please notify attendant of any gas spills.” I wasn\’t sure if I should go inside and mention the oil spill in the Gulf. I mean, it says to notify them. The question is, if there is a spill, do I trust your company to do anything… Read More »
These are homemade, obviously. I guess there\’s a reason why I don\’t do these professionally.
Recently (as in yesterday) I moved to a new house. This activity, in my humble opinion, is ranked right up there with digging a ditch. If someone asked me if I want to help them move or dig a ditch, it might be a toss-up. On the bright side it feels good, physically, to work… Read More »
Edit: RecordSetGo is being redeveloped to look a little bit more up-to-date. The back-end (database) will remain as-is and therefore all data will continue to exist, but the front end with which the user will interact will be changing. As a lone-developer I cannot estimate the time of completion. Record Set Go is a new… Read More »
People have a green agenda. It makes no sense to any thinking human being. Follow me here… We must “save trees”. Don\’t print emails, go paperless, and so on. Then we have to stop exhaling because carbon dioxide destroys the planet. But carbon dioxide feeds trees which in turn generate oxygen for us to breath.… Read More »
Google voice is still my second choice. When I used it a few days ago to call my wife for a second, she kept saying “huh?”, “what?”, “I can’t hear you”. After saying it three times, she got it. Then she told me that I sounded terrible. There may not really be an advantage to… Read More »
Source: PC World Google’s telephony management application Google Voice is now open to all U.S. residents, as the company on Tuesday removed the requirement for prospective users to receive an invitation in order to sign up for the service. Google Voice Now Open to Everyone in the US Already, there are 1 million people with… Read More »