Shnugo

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

Convert Oracle Datetime format query to MS SQL Server Format
Escape XML special characters upon convert
How to compact the result of a query?
SQL Server query performance: Nested cursors
Examing Values from xml-field in SQL Server 2008
Search for column name in multiple databases on SQL Server
get attribute value of XML child node with where condition on parent node
(SQL) Identify positions of multiple occurrences of a string format within a field
SQL importing Extended Events file using sys.fn_xe_file_target_read_file how to only get values since last import
Trying to extract IP from XML using XML nodes