Shnugo

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

Getting NULL values while using OPENXML to read from XML file
SQL query to get list of month between two dates
How Can I separate characters and number from a word using SQL Server query
Using FOR JSON and CTE and store it in a variable
FOR XML cannnot serialize char(0x0000) even though REPLACE function already included to replace Char(0x0000)
How to create a (Polymorphism) collection/list/array of a class where each one may have some different properties
TSQL -- Extract JSON values for unknown/dynamic key in sub-object (not an array)
Convert XML from one format to another
Sequence Use. Two Sequences on one column
Get the greatest value in a nvarchar column