gotqn

gotqn has asked 124 questions and find answers to 97 problems.

Stats

About

Free Tibet From China Domination

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

enter image description here

gotqn questions

Initializing multiple variables with one SELECT statement
Rails 5 - vendor assets are not loaded on production (fonts only)
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

gotqn answers

SQL Server parent child (parent see all everything)?
SQL Server GROUP BY with condition
How to get seperate intervals from overlapping dates
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?