Posts

Showing posts from March 11, 2019

SQL Server UNICODE() Function

Image
Clash Royale CLAN TAG #URR8PPP <!-- main_leaderboard, all: [728,90][970,90][320,50][468,60] --> SQL Server UNICODE() Function ❮ SQL Server Functions Example Return an integer value (the Unicode value), for the first character of the input expression: SELECT UNICODE('Atlanta'); Try it Yourself » Definition and Usage The UNICODE() function returns an integer value (the Unicode value), for the first character of the input expression. Syntax UNICODE( character_expression ) Parameter Values Parameter Description character_expression Required. An nchar or varchar expression Technical Details Works in: SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse More Examples Example Return an integer value (the Unicode value), for the first character of the input expression: SELECT UNICODE(CustomerName) AS UnicodeOfFirstChar FROM Customers; Try it Yourself » ❮ SQL Server Functions

Augusta-Richmond County Public Library System

Image
Augusta-Richmond County Public Library System From Wikipedia, the free encyclopedia Jump to navigation Jump to search Augusta-Richmond County Public Library System The Appleby Library Established 1848 (Augusta Library) 2013 (ARCPLS) Location Richmond County, Georgia Coordinates 33°28′23.5776″N 81°58′6.5352″W  /  33.473216000°N 81.968482000°W  / 33.473216000; -81.968482000 Coordinates: 33°28′23.5776″N 81°58′6.5352″W  /  33.473216000°N 81.968482000°W  / 33.473216000; -81.968482000 Branches 6 Collection Size 362,034 (2016) [1] Access and use Circulation 478,362 (2016) [1] Population served 204,435 (2016) [1] Members 76,409 (2016) [1] Other information Director Mashell Fashion Website http://arcpls.org/ The Augusta-Richmond County Public Library System is a public library system consisting of six branches serving the county of Richmond, Georgia. The headquarters for the library system is the Augusta-Richmond County Public Library loca

Ranking variables according to their percent contribution to total

Ranking variables according to their percent contribution to total Consider the following example data: psu | sumsc sumst sumobc sumother sumcaste -------|----------------------------------------------- 10018 | 3 2 0 4 9 | 10061 | 0 0 2 5 7 | 10116 | 1 1 2 4 8 | 10121 | 3 0 1 2 6 | 20002 | 4 1 0 1 6 ------------------------------------------------------- I want to rank the variables sumsc , sumst , sumobc , and sumother according to their percent contribution to sumcaste (this is the total of all variables) within psu . sumsc sumst sumobc sumother sumcaste psu Could anyone help me do this in Stata? 2 Answers 2 First we enter the data: clear all set more off input psu sumsc sumst sumobc sumother sumcaste 10018 3 2 0 4 9 10061 0 0 2 5 7 10116 1 1 2 4 8 10121 3 0 1 2 6 20002 4 1 0 1 6 end Second, we prepare the reshape : reshape local j=1 foreach var of varlist sumsc sumst sumobc sumother gen temprl`j' = `var' / sumcaste ren `var' addi`j' local ++j resha

Edward Elgar £20 notes in UK

Image
11 So I got a few £20 notes which were intended to be given as pocket money on a child's trip to UK. As the notes looked differently and some were older than other I realized that: Elgar £20 note no longer legal tender This means that shops no longer have to accept the notes, and it is up to banks whether they agree to swap notes after this date. [...] After June 30 if a bank or building society refuses to swap a note, consumers have the right to swap the notes at the Bank of England itself. The Bank promises that it will honour the face value of any note issued, even notes from before the Second World War. The quote is coming from 2010. I wonder what is the reality about accepting the notes now? Except the mentioned swap at the Bank of England as the article suggests, can the notes be used in everyday (esp. tourist) situations: can the old notes be used in shops, including in airport shops, to buy train tickets? Would a taxi driver accept them? Would I be able