Shnugo

Shnugo has asked 11 questions and find answers to 188 problems.

Stats

About

Started with GFA-Basic on Atari Mega-ST
Then VB5, little C++
Much with MS-Access (VBA)
Now a great enthusiast of C#
Lot of database experience (MS-SQL-Server)
structure aesthete
Lot of generic structures with generic skins
XML, XSL, XHTML, PDF: Transformations for WYSIWYG-documents

Shnugo questions

Strange CAST behaviour with INT and a single hyphen ( - )
Deploy SSRS reports on a customer's machine with PowerShell
Date conversion and culture: Difference between DATE and DATETIME

Shnugo answers

SQL Return subquery 'Total Records' to outer query
The Extracted data retrieved from XML in MySQL duplicated
SQL query hierarchical XML with multiple sub-elements
HTML Escape in T-SQL SQL Server 2014
Complex Grouping and Resultset
Find table containing two particular columns in SQL Server
Trim a part of a String
convert query output into json format in sql server
TRY_PARSE but faster
How to get a count between to dates and write the count of rows into a table with T-SQL?