gotqn

gotqn has asked 115 questions and find answers to 78 problems.

Stats

About

Free Tibet From China Domination

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

enter image description here

gotqn questions

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?
SQL CLR function based on .net ComputeHash is not working with Cyrrilic

gotqn answers

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
create new column based on specific values another columns
CTE returning error
SQL Query multiple users who started on the same date