Jeff Moden (3/29/2012)

---

Eugene Elutin (3/29/2012)

---

Just looking into this thread again...

What I can say, crap data structure design quickly leads to crap and stupid coding you need to do to achieve...

Eugene Elutin (3/29/2012)

---

Just looking into this thread again...

What I can say, crap data structure design quickly leads to crap and stupid coding you need to do to achieve something good!...

Anders Pedersen (3/28/2012)

---

Should have everything you need.

Just sum on the converted to minute columns however you want it summed, then add the values together.

I guess what you really want here...

Anders Pedersen (3/28/2012)

---

Try this. Tested on SQL 2008 (10.0.4000). Might not be optimal, but makes it readable.

create function dbo.fcn_ConvertTimeToMinutes(@Time Time)

returns int

begin

declare @r int;

select @r = substring(CONVERT(varchar(5), @Time), 1,2)...

I am not able...

dwain.c (3/27/2012)

---

Just shooting in the dark here but maybe if you rearranged your statements as follows it might get you closer:

ALTER PROCEDURE [dbo].[timelord_year]

@Year [nvarchar](4000)

SET NOCOUNT ON

SET ANSI_WARNINGS Off

;WITH

cteToDateTime(DT)...

Paul,

For future posts, please see the article at the first link in my signature line below. It'll help us help you more quickly.

First, we need some test data. ...

bitbucket-25253 (3/26/2012)

---

You did say previously:

Thanks for your reply....However, I have to create a new column based on this calculation and use that in a report. Your code is correct but...

Could someone please have a look at my query, I am stuck with this one for a long time now...

I have a column 'WeekHours' which has a datatype varchar and...

bitbucket-25253 (3/23/2012)

---

@min-2 is simply functioning as a "place holder" or intermediate value. You could alter the previous code to

SET @min-2 = CAST(SUBSTRING(@H1,CHARINDEX(':',@H1)+1,DATALENGTH(@H1))AS INT)+CAST(SUBSTRING(@H2,CHARINDEX(':',@H2)+1,DATALENGTH(@H2))AS INT)

INSERT INTO NewColumn -- Inserted...

bitbucket-25253 (3/23/2012)

---

Here is one way of doing what you want, but I must say it is not very efficient, but for the life of me I can not come up...

bitbucket-25253 (3/23/2012)

---

Well you have stated your requirement, as strange as it seems, but what is your question ? What assistance are you seeking ?

Looking for a better method to...

This is not a duplicate post....its an altogether different query. Read the post Properly first before writing any comments.

If...

Thanks for your reply. I want it to display as 147:00:00...as the value is returned in hours.

Thanks Ron,

But the thing is I dont wish to join the values, instead I...