Click here to Skip to main content
15,936,046 members
Home / Discussions / Database
   

Database

 
QuestionDoubt in oralce table Pin
Balaji Naidu27-Apr-15 9:39
Balaji Naidu27-Apr-15 9:39 
QuestionRe: Doubt in oralce table Pin
Richard Deeming27-Apr-15 10:21
mveRichard Deeming27-Apr-15 10:21 
AnswerRe: Doubt in oralce table Pin
Balaji Naidu27-Apr-15 10:26
Balaji Naidu27-Apr-15 10:26 
AnswerRe: Doubt in oralce table Pin
Sascha Lefèvre27-Apr-15 15:15
professionalSascha Lefèvre27-Apr-15 15:15 
QuestionOrder By Pin
jkirkerx26-Apr-15 11:57
professionaljkirkerx26-Apr-15 11:57 
AnswerRe: Order By Pin
David Mujica27-Apr-15 3:37
David Mujica27-Apr-15 3:37 
GeneralRe: Order By Pin
jkirkerx27-Apr-15 6:40
professionaljkirkerx27-Apr-15 6:40 
QuestionBetter way of matching a customer address Pin
jkirkerx24-Apr-15 6:25
professionaljkirkerx24-Apr-15 6:25 
I'm trying to find a better way of matching an address. So I was thinking, the credit card processors use the street address 1 and zip or postal code to do a AVS match, and perhaps I should just copy that idea.

I wrote this, sort of copied it and made some edits
But I can't get it right. I can't figure out where to place my input to match against.
DECLARE @PostalCode VarChar(12), @CustomerID Int, @StreetAddress1 VarChar(80);
SET @PostalCode = '92648';
SET @CustomerID = 5;
SET @StreetAddress1 = '18751 Park Haven Lane';
SELECT * 
FROM CUSTOMER_SHIPPING_ADDRESS
WHERE LEFT(@StreetAddress1, 5) IN ( 
 SELECT LEFT(StreetAddress1, 5) 
 FROM CUSTOMER_SHIPPING_ADDRESS
 GROUP BY LEFT(StreetAddress1, 5 ) 
 HAVING COUNT(*) > 1 
) 
AND PostalCode = @PostalCode 
AND CustomerID = @CustomerID 

AnswerRe: Better way of matching a customer address Pin
jkirkerx24-Apr-15 6:40
professionaljkirkerx24-Apr-15 6:40 
GeneralRe: Better way of matching a customer address Pin
PIEBALDconsult24-Apr-15 7:47
mvePIEBALDconsult24-Apr-15 7:47 
GeneralRe: Better way of matching a customer address Pin
jkirkerx24-Apr-15 12:31
professionaljkirkerx24-Apr-15 12:31 
GeneralRe: Better way of matching a customer address Pin
PIEBALDconsult24-Apr-15 12:36
mvePIEBALDconsult24-Apr-15 12:36 
GeneralRe: Better way of matching a customer address Pin
jkirkerx24-Apr-15 12:50
professionaljkirkerx24-Apr-15 12:50 
AnswerRe: Better way of matching a customer address Pin
jschell26-Apr-15 7:26
jschell26-Apr-15 7:26 
GeneralRe: Better way of matching a customer address Pin
jkirkerx26-Apr-15 8:34
professionaljkirkerx26-Apr-15 8:34 
QuestionExporting Database in XML Pin
MattAtCetraCom22-Apr-15 7:54
MattAtCetraCom22-Apr-15 7:54 
AnswerRe: Exporting Database in XML Pin
David Mujica22-Apr-15 9:36
David Mujica22-Apr-15 9:36 
QuestionRe: Exporting Database in XML Pin
Eddy Vluggen22-Apr-15 10:33
professionalEddy Vluggen22-Apr-15 10:33 
AnswerRe: Exporting Database in XML Pin
MattAtCetraCom23-Apr-15 7:37
MattAtCetraCom23-Apr-15 7:37 
GeneralRe: Exporting Database in XML Pin
Eddy Vluggen23-Apr-15 7:48
professionalEddy Vluggen23-Apr-15 7:48 
QuestionCreating SSIS OLE DB Source with Parameters programmatically with .NET Pin
Dr Miroslav Stimac22-Apr-15 5:10
professionalDr Miroslav Stimac22-Apr-15 5:10 
AnswerRe: Creating SSIS OLE DB Source with Parameters programmatically with .NET Pin
PIEBALDconsult22-Apr-15 5:15
mvePIEBALDconsult22-Apr-15 5:15 
GeneralRe: Creating SSIS OLE DB Source with Parameters programmatically with .NET Pin
Dr Miroslav Stimac22-Apr-15 5:31
professionalDr Miroslav Stimac22-Apr-15 5:31 
QuestionMaster slave model in databases Pin
holykrish20-Apr-15 19:10
holykrish20-Apr-15 19:10 
SuggestionRe: Master slave model in databases Pin
Richard MacCutchan20-Apr-15 21:45
mveRichard MacCutchan20-Apr-15 21:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.