282 reputation
216
bio website blog.codingbadger.com
location London, United Kingdom
age 31
visits member for 1 year, 10 months
seen Jul 16 at 12:43

Feb
15
comment What to do with duplicate lookup information
Thanks! That was my other idea but it seemed a bit like I was dropping bits of information I may need (The original Id's of the customer state in their respective systems) However, thinking about it I am not sure what I would use them for. Getting caught up in over thinking I suspect!
Feb
15
asked What to do with duplicate lookup information
Feb
12
comment Database not naturally shrinking log file
Damn it - cannot believe I couldn't find that!
Feb
12
asked Database not naturally shrinking log file
Feb
4
awarded  Informed
Jan
10
answered Remote Desktop Session's Machine ID for SQL Server Query
Jan
8
revised How do I use SSMS to compare Database 1 Table 1 against Database 2 Table 1?
formating and typos
Jan
8
suggested suggested edit on How do I use SSMS to compare Database 1 Table 1 against Database 2 Table 1?
Jan
2
awarded  Quorum
Nov
23
answered Special Oracle Order
Nov
5
awarded  Benefactor
Nov
5
accepted Powershell script executing within SQL Server Agent
Nov
1
awarded  Promoter
Oct
29
comment Powershell script executing within SQL Server Agent
@PatrickKeisler No I haven't - how would I do that?
Oct
26
comment Powershell script executing within SQL Server Agent
@PatrickKeisler Yes it is.
Oct
25
asked Powershell script executing within SQL Server Agent
Oct
19
comment Advice on how to approach data cleaning & importing
@Jon Ah yes, you are totally right there. I am not sure how I didn't notice that. I may have used the SourceTable at some point and forgotten to remove it. Still tinkering and monitoring at the moment so I may well change the approach. I am processing ~100 event types which is taking ~2minutes which is well within my time constraints. Thanks for your input :-)
Oct
19
comment Advice on how to approach data cleaning & importing
Answer posted! :)
Oct
19
answered Advice on how to approach data cleaning & importing
Oct
19
comment Advice on how to approach data cleaning & importing
Sure, I will post it as an answer. It uses slightly different logic from your case example but your answer certainly fueled my initial thoughts :)