gotqn

gotqn has asked 112 questions and find answers to 66 problems.

Stats

About

Free Tibet From China Domination

http://freetibet.org/about/10-facts-about-tibet

enter image description here

gotqn questions

NULLIF/IIF returning undesired results when comparing Khmer to zero length string
How to pass array to class option of rails generator?
Technique for fixing XML parsing: illegal qualified name character
Why "Action Mailer" is not rendering the email template?
Explaining COUNT return value when used without group
T-SQL Update table columns using function
How to convert row values to columns with dynamic columns count?
SQL CLR function based on .net ComputeHash is not working with Cyrrilic
Regular Expression - Match End if Start is Match
Ruby on Rails - how require is executed in application.js

gotqn answers

SELECT query to print as JSON list in one row [duplicate]
How to reference subquery in the WHERE clause
Cannot find data type 'ntext' error in Azure SQL Data Warehouse
SQL to JSON - Create a Json Array
Count Distinct over partition by sql
Dynamic SQL Statement is too long
Composite clustered index vs non-unique clustered index. Which is better/worse in this case?
parsing data out of a single data point
Merge two rows into one after a join
How to make a select statement to return "NULLs" if the value is a repetition in SQL