Reputation
1,339
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
8 19
Newest
 Organizer
Impact
~87k people reached

Apr
15
awarded  Organizer
Apr
15
revised SQL Join problem
added DMBS tags
Apr
15
suggested approved edit on SQL Join problem
Apr
15
comment SQL Join problem
What DBMS are you using? And what determines which record is "first" in table B? To be certain that you're getting the desired result, you will need to specify a column by which table B should be sorted.
Mar
15
awarded  Popular Question
Aug
18
comment How does SQL Server Import and Export Wizard fetch metadata?
Oh, what I wouldn't give for a profiler... Unfortunately, the offending system is a remotely hosted vendor app, and I only have ODBC access. There is a system view analogous to sys.columns, but it shows what should be the limit, not what's actually stored in the column.
Aug
18
comment How does SQL Server Import and Export Wizard fetch metadata?
It has a LENGTH(), but it's only valid for char and varchar. I can probably cobble together what I need from that, but it seems like the wizard is doing something quicker and more sophisticated that I was hoping to emulate. I'm trying to make my homemade replication more robust, but Progress doesn't make that easy.
Aug
18
asked How does SQL Server Import and Export Wizard fetch metadata?
Aug
3
awarded  Constituent
Jul
28
awarded  Caucus
Jul
20
comment Most efficient way to insert rows into a temp table in a stored procedure
The right indexes will make all the difference. You can index trashy data--you don't have to have keys & constraints. If you really need the indexes to not stay there, it's possible that creating an index, running your 5 queries, and deleting the index will still be faster than your current process.
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.