Shnugo

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

Apply previously shredded xml values to subsequent elements
What are the advantages/disadvantages of using a CTE?
How do I get the specified node from XML in SQL
How to get value from ntext (in xml format) column in sql
Convert a letter into a number
Generate XML from SQL Server by select multiple tables to a certain file location
select columns into rows grouped by columns values
For xml path returns null instead of nothing
Supply xml element value in modify() method
Fast way to "flatten" hierarchy table?