Click here to Skip to main content
15,921,113 members
Home / Discussions / Database
   

Database

 
GeneralRe: intricate date query sql Pin
Richard MacCutchan20-Feb-14 0:16
mveRichard MacCutchan20-Feb-14 0:16 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 0:24
Martin Niemandt20-Feb-14 0:24 
GeneralRe: intricate date query sql Pin
Richard MacCutchan20-Feb-14 0:29
mveRichard MacCutchan20-Feb-14 0:29 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 0:41
Martin Niemandt20-Feb-14 0:41 
AnswerRe: intricate date query sql Pin
Mycroft Holmes20-Feb-14 12:01
professionalMycroft Holmes20-Feb-14 12:01 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 18:53
Martin Niemandt20-Feb-14 18:53 
GeneralRe: intricate date query sql Pin
Mycroft Holmes20-Feb-14 19:46
professionalMycroft Holmes20-Feb-14 19:46 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 20:45
Martin Niemandt20-Feb-14 20:45 
Interesting I will go take a peek at OLAP, The only problem is I am moulding the data in parts updating parts after the initial insert. I just need to get a running total of the date difference (Which is used as time) and I need to restart the counting when the difference (not the total) is more than 30 minutes and then I need to assign that session an ID a session ID must not lap over different users. the part I am stuck with is 1. the running total of the time difference 2. assigning incremented ID's based on this logic
[Edit]: Your left join idea helped already thank you
GeneralRe: intricate date query sql Pin
Mycroft Holmes20-Feb-14 21:36
professionalMycroft Holmes20-Feb-14 21:36 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 22:01
Martin Niemandt20-Feb-14 22:01 
GeneralRe: intricate date query sql Pin
Jörgen Andersson20-Feb-14 21:28
professionalJörgen Andersson20-Feb-14 21:28 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 22:04
Martin Niemandt20-Feb-14 22:04 
QuestionMSSQL : Selecting a value from a row that has a column with minimun creation time for given parameters Pin
Prasad A19-Feb-14 19:26
Prasad A19-Feb-14 19:26 
AnswerRe: MSSQL : Selecting a value from a row that has a column with minimun creation time for given parameters Pin
GuyThiebaut19-Feb-14 21:46
professionalGuyThiebaut19-Feb-14 21:46 
GeneralRe: MSSQL : Selecting a value from a row that has a column with minimun creation time for given parameters Pin
Prasad A19-Feb-14 22:08
Prasad A19-Feb-14 22:08 
GeneralRe: MSSQL : Selecting a value from a row that has a column with minimun creation time for given parameters Pin
GuyThiebaut19-Feb-14 22:24
professionalGuyThiebaut19-Feb-14 22:24 
QuestionUpdate Database for C# application Pin
PDTUM19-Feb-14 6:06
PDTUM19-Feb-14 6:06 
AnswerRe: Update Database for C# application Pin
David Mujica19-Feb-14 8:39
David Mujica19-Feb-14 8:39 
AnswerRe: Update Database for C# application Pin
PDTUM20-Feb-14 5:54
PDTUM20-Feb-14 5:54 
QuestionRe: Update Database for C# application Pin
Nicholas Swandel21-Feb-14 3:55
Nicholas Swandel21-Feb-14 3:55 
AnswerRe: Update Database for C# application Pin
PDTUM21-Feb-14 5:50
PDTUM21-Feb-14 5:50 
GeneralRe: Update Database for C# application Pin
Nicholas Swandel21-Feb-14 6:20
Nicholas Swandel21-Feb-14 6:20 
Questionbegin tran in sql server 2008 Pin
vkEE19-Feb-14 5:22
vkEE19-Feb-14 5:22 
AnswerRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 6:02
professionalGuyThiebaut19-Feb-14 6:02 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 6:13
vkEE19-Feb-14 6:13 

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.