Shnugo

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

TSQL Extract Number Range from String with Known Ending
XML Query Attach appropriate ID
Optimize queries
Extract nested XML data with inconsistent attributres and elements in SQL Server
How I can get table definition in SQL SERVER 2008 R2 using SQL query?
What's the proper way to associate different account types (database types) to payments and invoices?
Len function on Float in SQLServer gives wrong length
How to aggregate JSON in SQL Server?
Convert Oracle Datetime format query to MS SQL Server Format
Escape XML special characters upon convert