Viewing 15 posts - 271 through 285 (of 541 total)
ChrisM@Work (4/27/2012)
pwalter83 (4/27/2012)
ChrisM@Work (4/27/2012)
Oh come on, Paul - none of us is going to retype from a bitmap! Be nice!
This is a sample data from a stored procedure not a...
April 27, 2012 at 6:53 am
ChrisM@Work (4/27/2012)
Oh come on, Paul - none of us is going to retype from a bitmap! Be nice!
This is a sample data from a stored procedure not a table. The...
April 27, 2012 at 3:55 am
Cadavre (4/26/2012)
pwalter83 (4/26/2012)
April 27, 2012 at 2:54 am
Cadavre (4/26/2012)
DECLARE @StandardHours VARCHAR(20) = '133:50:15';
DECLARE @ActualHours VARCHAR(20) = '98:16:57';
SELECT
CAST(diffSeconds/3600 AS VARCHAR(6)) + ':'+ RIGHT('00'+CAST(diffSeconds%(3600)/60 AS VARCHAR(2)),2)+':'+RIGHT('00'+CAST(diffSeconds%60 AS VARCHAR(2)),2)
FROM (SELECT
...
April 26, 2012 at 9:53 am
dwain.c (4/25/2012)
I omitted that because I was in a hurry. Just use something like this:
':' + RIGHT('00'+CAST(Tue%60 AS VARCHAR),2)
Thank you very much again ! It worked perfectly !
April 26, 2012 at 2:45 am
dwain.c (4/25/2012)
April 25, 2012 at 9:50 am
pwalter83 (4/23/2012)
Jeff Moden (4/22/2012)
April 25, 2012 at 2:02 am
Jeff Moden (4/22/2012)
April 23, 2012 at 2:38 am
Jeff Moden (4/18/2012)
Dang it... that's the second time I lost track of this thread. My apologies. I'll try to take a look tonight.
No Problem, thanks Jeff
April 18, 2012 at 9:12 am
Anders Pedersen (3/29/2012)
pwalter83 (3/29/2012)
Jeff Moden (3/29/2012)
Are you all set then or do you still need some help to pull all of this off?
Jeff,
Actually I would need some help at this...
April 18, 2012 at 3:27 am
Anders Pedersen (3/29/2012)
pwalter83 (3/29/2012)
Jeff Moden (3/29/2012)
Are you all set then or do you still need some help to pull all of this off?
Jeff,
Actually I would need some help at this...
April 10, 2012 at 2:40 am
Anders Pedersen (3/29/2012)
pwalter83 (3/29/2012)
Jeff Moden (3/29/2012)
Are you all set then or do you still need some help to pull all of this off?
Jeff,
Actually I would need some help at this...
April 4, 2012 at 6:13 am
Anders Pedersen (3/29/2012)
pwalter83 (3/29/2012)
Jeff Moden (3/29/2012)
Are you all set then or do you still need some help to pull all of this off?
Jeff,
Actually I would need some help at this...
March 30, 2012 at 2:03 am
Eugene Elutin (3/29/2012)
Sorry, I wasn't right. I didn't read all posts through, what I've seen was just the first one, asking to sum HH:MM's...
March 29, 2012 at 7:56 am
Jeff Moden (3/29/2012)
Are you all set then or do you still need some help to pull all of this off?
Jeff,
Actually I would need some help at this point. Anders provided...
March 29, 2012 at 7:53 am
Viewing 15 posts - 271 through 285 (of 541 total)