gotqn

gotqn has asked 116 questions and find answers to 84 problems.

Stats

About

Free Tibet From China Domination

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

enter image description here

gotqn questions

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
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?

gotqn answers

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
I want to insert values for Ranks column on bases of other column required condition
Random char in tsql string
Use findstr to replace null values with empty strings from sqlcmd command
Use table hints with variable table
Get previous row value using LAG with specific condition
How to replace substring in a column using lookup table in sql server