Click here to Skip to main content
15,920,031 members
Home / Discussions / Database
   

Database

 
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 
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 
I absolutely have to display the date difference that is how the specification is made.
Let me try saying it this way:
I have to have a running total for the times until there is a 30 minute or larger gap or if a new user ID which is a different person is the next row of the dataset. then that is a session then I have to increment the session ID for each Session.

like
Update
SET [Session ID] = [Session ID] + 1
WHERE [Date difference] < 30 Minutes
OR If dates run out for this person presenting a new person.

And for then the running total must start again. Sigh | :sigh: It is allot to ask I am sorry but any help would be greatly appreciated.
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 
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 

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.