280 reputation
312
bio website wernercd.com
location Delaware
age 35
visits member for 3 years, 8 months
seen Sep 23 at 4:48

Data Analyst Programmer (Primarily C#)


Jul
2
awarded  Curious
Jun
26
awarded  Notable Question
May
2
awarded  Nice Question
Feb
5
accepted Good, Bad or Indifferent: WHERE 1=1
Dec
15
comment Why use WHERE 1 or WHERE 1=1?
I write code similar to the first block in SSMS or similar query tools. Researching data sets and getting the right results before it gets put into reporting tools (like Crystal Reports) for end users. The second block is what I've seen other people do, since my job hasn't been too much about raw sql access. I've troubleshot other peoples similar code and can understand the reasoning. (Code was in VB, C# and PHP).
Dec
13
answered Why use WHERE 1 or WHERE 1=1?
Sep
19
awarded  Notable Question
Sep
3
comment Are there any problems with deploying an SQL Server database to a production server by taking a backup?
@AaronBertrand Sometimes answering a question means pointing out answers to unasked or un-thought-of (word?) questions.
Aug
22
revised Find Duplicate Customers
deleted 405 characters in body
Aug
22
comment Find Duplicate Customers
I see it now. Yeah, I meant they can each be individually wrong (and possibly more, but I don't want to try and match on 2 of 4 at this stage, unless requested). Sorry about that, can't edit the comment
Aug
22
comment Find Duplicate Customers
Saw your edit to first comment. Added distinct counts. Not sure where you see "No matches" (maybe a corrected typo on my part as well? lol), but it should be 3 or 4 matches.
Aug
22
revised Find Duplicate Customers
added 96 characters in body
Aug
22
comment Find Duplicate Customers
(Couple edits on my previous post for clarity) Well my idea is to use 3 of the 4... but you can have 4 of 4 match and DOB/SSN/First/Last can all be wrong, change (as in marriage/divorce), refused entry (Can refuse SSN)... So, in my mind, 5 possibilities: All match, different ID. 1 of 4 Doesn't match, different ID.
Aug
22
comment Find Duplicate Customers
What do you mean "most selective"? The ID is unique. IndividualID is Not Null. Then you have Last/First/DOB/SSN - with associated typo's, empty/null, etc.
Aug
22
revised Find Duplicate Customers
added 6 characters in body
Aug
22
asked Find Duplicate Customers
Aug
1
comment SSMS Tools Pack Alternative
I like the looks of this. Looks smooth and awesome. Definitely doesn't seem to have the "breadth" that the tool packs have, but I really like the few things it does - as it seems to do them well.
Mar
26
awarded  Popular Question
Feb
26
comment SSMS Tools Pack Alternative
@AndreiRantsevich stackoverflow.com/questions/15080185/… related question, trying to stumble my way through.
Feb
26
comment SSMS Tools Pack Alternative
@MartinSmith stackoverflow.com/questions/15080185/… I'd like to take this a couple steps further, but I'm not sure how to even start...