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)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy