gotqn

gotqn has asked 120 questions and find answers to 90 problems.

Stats

About

Free Tibet From China Domination

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

enter image description here

gotqn questions

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?
Technique for fixing XML parsing: illegal qualified name character

gotqn answers

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
Converting Rows into Columns with Custom "as" statement