Reputation
1,307
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
7 16
Newest
 Enlightened
Impact
~34k people reached

Jun
2
awarded  Enlightened
Jun
2
awarded  Nice Answer
May
17
awarded  Yearling
May
6
comment Issuing Inserts/Updates to Progress OpenEdge via ODBC
I've been trying in both SSMS and SSIS. Edited to include full set of errors from SSIS (I'm not using the catalog yet--we skipped 2012, and not yet up to speed on 2014).
May
6
revised Issuing Inserts/Updates to Progress OpenEdge via ODBC
added 472 characters in body
May
6
asked Issuing Inserts/Updates to Progress OpenEdge via ODBC
Nov
15
awarded  Enlightened
Nov
15
awarded  Nice Answer
May
23
comment QUERY - pivot multiple columns, variable number of rows
If your version IDs are different for every recipe, then you're either going to end up with two columns for every row in your table, or your version in the column name would not match the version ID.
May
19
revised How to SELECT multiple COUNT(*) columns with each GROUP BY having a different WHERE clause?
added 288 characters in body
May
19
answered How to SELECT multiple COUNT(*) columns with each GROUP BY having a different WHERE clause?
May
17
comment Performance hit of CONVERT from nvarchar to money (SQL Server)
Mostly I was thinking of Aaron's arguments against it, but sqlblog.com/blogs/aaron_bertrand/archive/2009/10/12/… doesn't have a lot of detail, and the SO question he links to suffers the same problem of the accepted answer not having the interesting info
May
17
awarded  Yearling
May
16
comment List of fallback values in SQL
Something like SELECT TOP (1) FolderName FROM dbo.FallbackFolders WHERE FolderExists = 1 ORDER BY Precedence?
May
16
comment Performance hit of CONVERT from nvarchar to money (SQL Server)
You probably don't want to use MONEY--go DECIMAL. See stackoverflow.com/questions/582797/…
May
16
answered Query plan cache bloated by ad-hoc queries, even with “Optimize for Ad-hoc Workloads”
May
16
awarded  Enlightened
May
16
awarded  Nice Answer
May
14
comment How to find duration in a dataset
It needed a slight change in how the NULLs were filtered. It still doesn't match the desired output exactly, as it shows the first and last PollTime for a NULL set, rather than the first of the NULL set and the first of the following set. May do the trick, though, if a simple "+1" is appropriate for your application.
May
14
revised How to find duration in a dataset
`WHERE Value IS NULL` in the CTE breaks the "gaps and islands" construct. Filter out the unwanted groups in the outer query.