iamdave

iamdave has asked 1 questions and find answers to 11 problems.

Stats

About

BI Developer specialising in MSBI stack.

iamdave questions

Aggregate for each day over time series, without using non-equijoin logic

iamdave answers

can I turn a select from a select statement into a self join?
How to return local temporary table from generated sql
Sorting an alphanumeric column in SQL with mix of alphanumeric and alpha-only values
SQL hashing a password
SQL Select: Get the previous Date in column
Find Missing Dates in Data
Is it possible to avoid specifying a column list in a SQL Server CTE?
Fuzzy logic matching
SQL Fuzzy Join - MSSQL
Set .NET Framework version for ScriptComponentProject