gotqn

gotqn has asked 121 questions and find answers to 91 problems.

Stats

About

Free Tibet From China Domination

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

enter image description here

gotqn questions

T-SQL Why division by zero does not generated error in the order by clause
Is there a SQL Server Management Studio option controlling parameters assignment?
T-SQL Generate Random/Sample Data from RegEx
DATEADD issue when negative number is used with MONTH datepart
How to reshape correlation output in R (un-pivoting result data)?
Reporting Services - get previous column value if current is NULL
Using one DECLARE statement for several variables
T-SQL How to escape star (*) character
NULLIF/IIF returning undesired results when comparing Khmer to zero length string
How to pass array to class option of rails generator?

gotqn answers

SQL Server two columns in index but query on only one
Adding Conditional Clause(Where) to Dense Rank Function
( CASE WHEN [date] IS NULL THEN 0 ELSE 1 END) is not working in my pivot
Script to change sql server database file location
Is there a SQL Server Management Studio option controlling parameters assignment?
How should I join to achieve this
Paperclip-ffmpeg error with styles for thumbnail when uploading video
T-SQL error: Adding a value to a 'smalldatetime' column caused overflow. SQL server bug?
SQL Server - Assign value to variable inside Dynamic SQL
Save result of select statement into wide table SQL Server