Click here to Skip to main content
14,694,683 members
Home » Discussions » Database
   

Database

 
GeneralRe: User Access Database - Best practise Pin
Simon_Whale9-Nov-18 2:39
professionalSimon_Whale9-Nov-18 2:39 
GeneralRe: User Access Database - Best practise Pin
Eddy Vluggen9-Nov-18 6:49
professionalEddy Vluggen9-Nov-18 6:49 
AnswerRe: User Access Database - Best practise Pin
Jörgen Andersson9-Nov-18 1:47
professionalJörgen Andersson9-Nov-18 1:47 
GeneralRe: User Access Database - Best practise Pin
Simon_Whale9-Nov-18 2:38
professionalSimon_Whale9-Nov-18 2:38 
GeneralRe: User Access Database - Best practise Pin
Jörgen Andersson9-Nov-18 2:46
professionalJörgen Andersson9-Nov-18 2:46 
GeneralRe: User Access Database - Best practise Pin
Simon_Whale9-Nov-18 2:50
professionalSimon_Whale9-Nov-18 2:50 
QuestionConditional statements in ON clause of joins Pin
simpledeveloper7-Nov-18 13:49
Membersimpledeveloper7-Nov-18 13:49 
AnswerRe: Conditional statements in ON clause of joins Pin
Mycroft Holmes7-Nov-18 21:25
professionalMycroft Holmes7-Nov-18 21:25 
I think you are going to need multiple joins to the same table and use nested ISNULL conditions.

However your requirement to pick the latest valid address due to different conditions is going to make this a nightmare in a single pass. I would split that logic out to a view that encapsulates the rules and supplies a single address for each entity. Then simply inner join to the view. Make the view generic and you have it available for any procedure Poke tongue | ;-P
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

GeneralRe: Conditional statements in ON clause of joins Pin
simpledeveloper9-Nov-18 14:00
Membersimpledeveloper9-Nov-18 14:00 
GeneralRe: Conditional statements in ON clause of joins Pin
Mycroft Holmes9-Nov-18 18:02
professionalMycroft Holmes9-Nov-18 18:02 
GeneralRe: Conditional statements in ON clause of joins Pin
simpledeveloper11-Nov-18 18:28
Membersimpledeveloper11-Nov-18 18:28 
QuestionLooking for a lightweight database to use for a vb win app Pin
jkirkerx7-Nov-18 13:01
professionaljkirkerx7-Nov-18 13:01 
AnswerRe: Looking for a lightweight database to use for a vb win app Pin
Nathan Minier8-Nov-18 2:08
professionalNathan Minier8-Nov-18 2:08 
GeneralRe: Looking for a lightweight database to use for a vb win app Pin
jkirkerx8-Nov-18 11:25
professionaljkirkerx8-Nov-18 11:25 
AnswerRe: Looking for a lightweight database to use for a vb win app Pin
--ZiM-- .11-Nov-18 9:36
Member--ZiM-- .11-Nov-18 9:36 
QuestionBackup file is not restoring into Database even after giving message as restored successfully Pin
simpledeveloper7-Nov-18 8:40
Membersimpledeveloper7-Nov-18 8:40 
QuestionIndex on nvarchar column doesnot affect performance (sql server) Pin
Heba Kamel23-Oct-18 2:29
MemberHeba Kamel23-Oct-18 2:29 
AnswerRe: Index on nvarchar column doesnot affect performance (sql server) Pin
Richard Deeming23-Oct-18 2:58
mveRichard Deeming23-Oct-18 2:58 
GeneralRe: Index on nvarchar column doesnot affect performance (sql server) Pin
Heba Kamel23-Oct-18 3:03
MemberHeba Kamel23-Oct-18 3:03 
GeneralRe: Index on nvarchar column doesnot affect performance (sql server) Pin
Richard Deeming23-Oct-18 3:04
mveRichard Deeming23-Oct-18 3:04 
Questionhow do i scan a image from a flat bed scanner using python and Microsoft access Pin
Member 1401815918-Oct-18 4:19
MemberMember 1401815918-Oct-18 4:19 
Rant[REPOST] how do i scan a image from a flat bed scanner using python and Microsoft access Pin
Richard Deeming18-Oct-18 4:28
mveRichard Deeming18-Oct-18 4:28 
AnswerRe: how do i scan a image from a flat bed scanner using python and Microsoft access Pin
CHill6018-Oct-18 5:50
mveCHill6018-Oct-18 5:50 
Generalthank you for your reply how you suggest i do it? Pin
Member 1401815918-Oct-18 21:52
MemberMember 1401815918-Oct-18 21:52 
GeneralRe: thank you for your reply how you suggest i do it? Pin
CHill6021-Oct-18 3:20
mveCHill6021-Oct-18 3:20 

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.