Shnugo

Shnugo has asked 11 questions and find answers to 122 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

Count number of level of each specific xml node in SQL Server
FOR XML ... TYPE much slower than FOR XML?
Remove XML Nodes for matching attribute condition in SQLServer
Add zeros in SQL columns
SQL Select: Take value from XML field
Generate single XML file from SQL Server with multiple results per customer
Query where date = '2016/01/02' not working?
SQL Server table audit trigger
How to import nested JSON to SQL Server table?
Msg 9402, Level 16, State 1, Line 9 XML parsing: line 1, character 38, unable to switch the encoding