gotqn

gotqn has asked 122 questions and find answers to 93 problems.

Stats

About

Free Tibet From China Domination

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

enter image description here

gotqn questions

Fusion Charts setCurrentRenderer('javascript') issue
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

gotqn answers

Update first table based on values from second table
I need to wrap a result set of xml data with a parent tag
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?