Click here to Skip to main content
15,917,610 members
Home / Discussions / Database
   

Database

 
AnswerRe: datetime problem Pin
GuyThiebaut26-Feb-14 21:49
professionalGuyThiebaut26-Feb-14 21:49 
QuestionHow to use temporary tables in SQL Server 2008? Pin
Rakesh Meel24-Feb-14 1:58
professionalRakesh Meel24-Feb-14 1:58 
AnswerRe: How to use temporary tables in SQL Server 2008? Pin
David Mujica24-Feb-14 3:18
David Mujica24-Feb-14 3:18 
QuestionHelp required on Database Model Pin
Nitheesh George23-Feb-14 6:05
Nitheesh George23-Feb-14 6:05 
AnswerRe: Help required on Database Model Pin
Mycroft Holmes23-Feb-14 11:52
professionalMycroft Holmes23-Feb-14 11:52 
AnswerRe: Help required on Database Model Pin
Eddy Vluggen24-Feb-14 8:17
professionalEddy Vluggen24-Feb-14 8:17 
AnswerRe: Help required on Database Model Pin
Duncan Edwards Jones26-Feb-14 11:06
professionalDuncan Edwards Jones26-Feb-14 11:06 
Questionintricate date query sql Pin
Martin Niemandt19-Feb-14 22:07
Martin Niemandt19-Feb-14 22:07 
Hi can anyone help me I don't necessarily want a solution just an idea.
I have a table e.g
ID - Start Date - End Date - Difference(Duration) - SessTotal - SessID

Now the Id is per user. and the date difference is the time spent doing something. If the difference is greater than 30 minutes I need to increment the session ID by 1.
Second I need to create a running total for session total per session.
1 session ID must also not be able to have more than 1 UserID [ID] in it's row.
AnswerRe: intricate date query sql Pin
Richard MacCutchan19-Feb-14 22:19
mveRichard MacCutchan19-Feb-14 22:19 
GeneralRe: intricate date query sql Pin
Martin Niemandt19-Feb-14 22:28
Martin Niemandt19-Feb-14 22:28 
GeneralRe: intricate date query sql Pin
Richard MacCutchan19-Feb-14 23:08
mveRichard MacCutchan19-Feb-14 23:08 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 0:11
Martin Niemandt20-Feb-14 0:11 
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 
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 

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.