ChrisM@Work (4/5/2013)

---

Not sure how it will pan out yet. With a couple of good mates in the immediate area and a nearby pub boasting 180 different whiskies[/url], it's a tough...

I only run when the ice cream van drives away

You need to have some way to order the original data.

Here's your data set up so others can use it: -

IF object_id('tempdb..#testEnvironment') IS NOT NULL

BEGIN

DROP TABLE...

rodjkidd (4/5/2013)

---

Nice.

So I take it you will jogging there and back then? 😀

I hate distances like that. Too far to walk, to short a drive for the car to get...

I'm in Castle Marina Premier Inn, which according to Google maps...

I note that you still haven't scripted out your expected outcome based on sample data. Unfortunately, this means I'm unable to provide any more assistance.

Good luck getting everything working.

Difficult to know what you want to do because you haven't included expected output for any data.

What is you expected output with the following: -

DECLARE @NewTask VARCHAR(50), @StartDate DATETIME, @EndDate...

What you're doing is pointless. The physical order of the table is not something you can use anyway. Have a read of this --> http://blogs.msdn.com/b/conor_cunningham_msft/archive/2008/08/27/no-seatbelt-expecting-order-without-order-by.aspx.

You've forgotten the expected results based on your sample data that was requested. You've not mentioned whether or not you tried the code I...

Taking a stab in the dark. . .

DECLARE @EnterTime TIME, @ExitTime TIME;

SELECT @EnterTime = '08:40:18.000', @ExitTime = '09:52:48.000'

SELECT CONVERT(VARCHAR(5), diffSeconds / 3600) + ':' +

...

Hey,

I finally had 5 minutes to read through your replies here and have realised that you've completely changed the requirements. So, what we need from you is sample data...

We have a software release where I work which is imminent. This has reduced my activity on these forums considerably, which is why I've not posted any replies. Some time...

Rauf Miah (3/11/2013)

---

I HAVE A TABLE WITH THREE FIELD COMCOD nchar(4) DUPLICATE ALLOWED FOREIGN KEY, ACTCODE nvarchar(6) PRIMARY KEY, ACTDESC nvarchar(250).

TABLE IS LIKE

COMCOD ...

bitbucket-25253 (3/11/2013)

---

CREATE TABLE T(COMCOD nchar(4), ACTCODE nvarchar(6), ACTDESC nvarchar(250),

PRIMARY KEY (ACTCODE))

...

oliver.morris (3/7/2013)

---

Hi Dwain,

Thanks for the help, I made a few changes but the key is that I need to push the column_id variable to each function. How do I do...