Click here to Skip to main content
15,848,264 members
Home / Discussions / Database
   

Database

 
QuestionDoubt in oralce table Pin
Balaji Naidu27-Apr-15 10:39
Balaji Naidu27-Apr-15 10:39 
QuestionRe: Doubt in oralce table Pin
Richard Deeming27-Apr-15 11:21
mveRichard Deeming27-Apr-15 11:21 
AnswerRe: Doubt in oralce table Pin
Balaji Naidu27-Apr-15 11:26
Balaji Naidu27-Apr-15 11:26 
AnswerRe: Doubt in oralce table Pin
Sascha Lefèvre27-Apr-15 16:15
professionalSascha Lefèvre27-Apr-15 16:15 
QuestionOrder By Pin
jkirkerx26-Apr-15 12:57
professionaljkirkerx26-Apr-15 12:57 
AnswerRe: Order By Pin
David Mujica27-Apr-15 4:37
David Mujica27-Apr-15 4:37 
GeneralRe: Order By Pin
jkirkerx27-Apr-15 7:40
professionaljkirkerx27-Apr-15 7:40 
QuestionBetter way of matching a customer address Pin
jkirkerx24-Apr-15 7:25
professionaljkirkerx24-Apr-15 7: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 7:40
professionaljkirkerx24-Apr-15 7:40 
GeneralRe: Better way of matching a customer address Pin
PIEBALDconsult24-Apr-15 8:47
mvePIEBALDconsult24-Apr-15 8:47 
GeneralRe: Better way of matching a customer address Pin
jkirkerx24-Apr-15 13:31
professionaljkirkerx24-Apr-15 13:31 
GeneralRe: Better way of matching a customer address Pin
PIEBALDconsult24-Apr-15 13:36
mvePIEBALDconsult24-Apr-15 13:36 
GeneralRe: Better way of matching a customer address Pin
jkirkerx24-Apr-15 13:50
professionaljkirkerx24-Apr-15 13:50 
AnswerRe: Better way of matching a customer address Pin
jschell26-Apr-15 8:26
jschell26-Apr-15 8:26 
GeneralRe: Better way of matching a customer address Pin
jkirkerx26-Apr-15 9:34
professionaljkirkerx26-Apr-15 9:34 
QuestionExporting Database in XML Pin
MattAtCetraCom22-Apr-15 8:54
MattAtCetraCom22-Apr-15 8:54 
AnswerRe: Exporting Database in XML Pin
David Mujica22-Apr-15 10:36
David Mujica22-Apr-15 10:36 
QuestionRe: Exporting Database in XML Pin
Eddy Vluggen22-Apr-15 11:33
professionalEddy Vluggen22-Apr-15 11:33 
AnswerRe: Exporting Database in XML Pin
MattAtCetraCom23-Apr-15 8:37
MattAtCetraCom23-Apr-15 8:37 
GeneralRe: Exporting Database in XML Pin
Eddy Vluggen23-Apr-15 8:48
professionalEddy Vluggen23-Apr-15 8:48 
QuestionCreating SSIS OLE DB Source with Parameters programmatically with .NET Pin
Dr Miroslav Stimac22-Apr-15 6:10
professionalDr Miroslav Stimac22-Apr-15 6:10 
AnswerRe: Creating SSIS OLE DB Source with Parameters programmatically with .NET Pin
PIEBALDconsult22-Apr-15 6:15
mvePIEBALDconsult22-Apr-15 6:15 
GeneralRe: Creating SSIS OLE DB Source with Parameters programmatically with .NET Pin
Dr Miroslav Stimac22-Apr-15 6:31
professionalDr Miroslav Stimac22-Apr-15 6:31 
QuestionMaster slave model in databases Pin
holykrish20-Apr-15 20:10
holykrish20-Apr-15 20:10 
SuggestionRe: Master slave model in databases Pin
Richard MacCutchan20-Apr-15 22:45
mveRichard MacCutchan20-Apr-15 22: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.