Click here to Skip to main content
15,509,152 members
Home / Discussions / Database
   

Database

 
AnswerRe: Insert into temptable ( #tmp1 ) that execute result from 1 procedure ( return 2 results ) Pin
Mycroft Holmes30-Jul-14 23:51
professionalMycroft Holmes30-Jul-14 23:51 
GeneralRe: Insert into temptable ( #tmp1 ) that execute result from 1 procedure ( return 2 results ) Pin
LTMKH31-Jul-14 16:53
LTMKH31-Jul-14 16:53 
GeneralRe: Insert into temptable ( #tmp1 ) that execute result from 1 procedure ( return 2 results ) Pin
Mycroft Holmes31-Jul-14 17:15
professionalMycroft Holmes31-Jul-14 17:15 
QuestionHow to Calculate Total Time Difference Pin
Robymon28-Jul-14 4:06
Robymon28-Jul-14 4:06 
AnswerRe: How to Calculate Total Time Difference Pin
Corporal Agarn28-Jul-14 4:26
professionalCorporal Agarn28-Jul-14 4:26 
GeneralRe: How to Calculate Total Time Difference Pin
Robymon28-Jul-14 4:36
Robymon28-Jul-14 4:36 
GeneralRe: How to Calculate Total Time Difference Pin
Corporal Agarn28-Jul-14 4:39
professionalCorporal Agarn28-Jul-14 4:39 
AnswerRe: How to Calculate Total Time Difference Pin
David Mujica28-Jul-14 4:28
David Mujica28-Jul-14 4:28 
In MS-SQL you can try

SQL
SELECT DATEDIFF(hour, START_DATE,END_DATE) FROM YOURTABLE

AnswerRe: How to Calculate Total Time Difference Pin
Andrius Leonavicius28-Jul-14 12:32
professionalAndrius Leonavicius28-Jul-14 12:32 
GeneralRe: How to Calculate Total Time Difference Pin
Mycroft Holmes29-Jul-14 14:05
professionalMycroft Holmes29-Jul-14 14:05 
GeneralRe: How to Calculate Total Time Difference Pin
Andrius Leonavicius29-Jul-14 15:03
professionalAndrius Leonavicius29-Jul-14 15:03 
GeneralRe: How to Calculate Total Time Difference Pin
Mycroft Holmes29-Jul-14 15:25
professionalMycroft Holmes29-Jul-14 15:25 
GeneralRe: How to Calculate Total Time Difference Pin
Andrius Leonavicius29-Jul-14 15:39
professionalAndrius Leonavicius29-Jul-14 15:39 
AnswerRe: How to Calculate Total Time Difference Pin
Mycroft Holmes29-Jul-14 15:29
professionalMycroft Holmes29-Jul-14 15:29 
AnswerRe: How to Calculate Total Time Difference Pin
Swinkaran4-Aug-14 17:28
professionalSwinkaran4-Aug-14 17:28 
QuestionSQL SERVER DBA--- HELP ME WITH THIS.... Pin
Member 1097517927-Jul-14 21:57
Member 1097517927-Jul-14 21:57 
AnswerRe: SQL SERVER DBA--- HELP ME WITH THIS.... Pin
Tim Carmichael28-Jul-14 3:58
Tim Carmichael28-Jul-14 3:58 
AnswerRe: SQL SERVER DBA--- HELP ME WITH THIS.... Pin
Mycroft Holmes29-Jul-14 15:33
professionalMycroft Holmes29-Jul-14 15:33 
QuestionProblem with SSIS 2012 Pin
amioni24-Jul-14 1:41
amioni24-Jul-14 1:41 
SuggestionRe: Problem with SSIS 2012 Pin
Richard Deeming24-Jul-14 2:57
mveRichard Deeming24-Jul-14 2:57 
GeneralRe: Problem with SSIS 2012 Pin
amioni24-Jul-14 3:04
amioni24-Jul-14 3:04 
QuestionRe: Problem with SSIS 2012 Pin
Richard Deeming24-Jul-14 3:13
mveRichard Deeming24-Jul-14 3:13 
AnswerRe: Problem with SSIS 2012 Pin
amioni24-Jul-14 4:00
amioni24-Jul-14 4:00 
GeneralRe: Problem with SSIS 2012 Pin
Richard Deeming24-Jul-14 4:12
mveRichard Deeming24-Jul-14 4:12 
GeneralRe: Problem with SSIS 2012 Pin
amioni24-Jul-14 4:25
amioni24-Jul-14 4:25 

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.