AdamL

AdamL has asked 10 questions and find answers to 43 problems.

Stats

About

MSSQL, SSIS, PowerShell, VBA, VBS, C#

MCP, MCTS, MCSA, MCSE

profile for AdamL on Stack Exchange, a network of free, community-driven Q&A sites

AdamL questions

recursive cte - mark all leafs
No error when selecting non-existing property
undocumented CONVERT styles - datetime 23
sql server CLR scalar function with default column name
PowerShell type accelerators: PSObject vs PSCustomObject
Edit SQL in Power Query

AdamL answers

Converting a base 31 value to BigInt in SQL Server
variable stuck in SSIS package
Get-ChildItem with multiple paths - Error if directory is missing
Group By, Count and Delete on Consecutive Records
PowerShell - Zip specific files in a folder
How to easily extract the first/last element from a PSCustomObject (preferably without foreach)?
Regular expression for matching all file names with 888 except those containing 888/444, 888/447, or 888/405?
Rename files to md5 sum + extension on Windows 7 (with CMD or PowerShell 2013)
Why is Get-PSDrive so slow?
Have Select-Object -Unique work on one property but display multiple?