-
Recent Posts
Archives
- July 2016
- April 2015
- January 2015
- October 2014
- September 2014
- July 2014
- June 2014
- May 2014
- April 2014
- March 2014
- January 2014
- August 2013
- March 2013
- February 2013
- January 2013
- December 2012
- June 2012
- April 2012
- March 2012
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
Categories
Blogroll
Meta
Category Archives: SQL
Full-Text Search with SQL Server 2008
The full-text search capabilities of SQL Server 2008 make it possible to search text across multiple columns, weight search terms, and search by proximity. A full-text query can be much faster than the equivalent LIKE query. The first step is … Continue reading
Posted in SQL, SQL Server
Leave a comment
Taking the top 5 of grouped ranked data in PostgreSQL
Working from a list of my ancestors’ occupations I wanted to list the top 5 occupations in each occupational category per decade, so that given year category description total … 1851 Agriculture Ag Lab 4 1851 Agriculture Farm Bailiff 1 … Continue reading
Posted in PostgreSQL, SQL
Leave a comment
Concatenating column from many side of one-to-many into single record using STUFF
SELECT OneTable.col1, OneTable.col2, STUFF ( ( SELECT ‘ ‘ + mt.col1 FROM ManyTable mt WHERE mt.foreignkeycol = OneTable.primarykeycol FOR xml path(”) ), 1, 1, ” ) AS concatenatedcol FROM OneTable Note: remember the ” in the inner SELECT statement, otherwise … Continue reading
Posted in SQL
Leave a comment
Jenny's Jottings 