gotqn

gotqn has asked 116 questions and find answers to 81 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

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
Count each element within XML node instead of continuous counting
SQL Server SET XACT_ABORT ON vs TRY...CATCH Block inside the stored procedure
Joined two select statements but data is showing twice instead of once