Shnugo

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

Get all values from an XML column
SQL Server: Check Upper Case or Lower Case after certain Character
Reduce cost for Table Valued Function - XML Reader in query plan - how?
Change Column Name Dynamically Using Mapping Table
T-SQL: how to process JSON elements with dot in their names?
SQL Server show column as delimited against a repeatable key
Select all XML nodes from XML column
How to find diff between two strings in SQL
Count number of level of each specific xml node in SQL Server
FOR XML ... TYPE much slower than FOR XML?