GSquared is right - you need those SELECT (SELECT constructs in there as he describes.

Also, the final query is missing SELECT [columnlist].

Sure, briefly (it's nearly 10pm here).

Everything above this line [Troubleshoot from here down04-07-09] makes sense, nothing makes sense below the line. I'm guessing it should read something like

INSERT INTO...

My mistake Donato, the top line was eaten:

DECLARE @Startdate DATETIME, @Enddate DATETIME

SELECT @Startdate = convert(datetime, '02-APR-09' + ' 03:00:00', 101),

@Enddate = convert(datetime, '02-APR-09' + ' 20:00:00', 101)

--

SELECT itl.user_id,...

Can you run this please, with and without the derived table which is currently commented out, and post back the run times:SELECT @Startdate = convert(datetime, '02-APR-09' + ' 03:00:00',...

Stephen, what do you get when you run this:

SELECT *

FROM co_customer_x_address

where cxa_cst_key = '18599564-1e26-4f0d-b95b-000d09d32406'

What value does it have for cxa_adr_key?

Change this...

---

d.loginTime,

---

d.loginTimeSeconds,

---

d.LogoutTime

---

to this...

---

MAX(d.loginTime) AS loginTime,

---

MAX(d.loginTimeSeconds) AS loginTimeSeconds,

---

MAX(d.LogoutTime) AS LogoutTime

---

Try this, Donato:

DECLARE @Startdate DATETIME, @Enddate DATETIME

SELECT @Startdate = convert(datetime, '02-APR-09' + ' 03:00:00', 101),

@Enddate = convert(datetime, '02-APR-09' + ' 20:00:00', 101)

--

SELECT itl.user_id, au.notes, au.shift,

--

sum(update_qty * m.avg_cubes)...

Haha that's okay mate, none of the speedy-up stuff has been done yet! 😀

Ramesh (4/7/2009)

---

Guys, It looks like an interesting problem for me and I would like to try my hands on it. But the problem is that I still not completely...

No worries Flo. I wondered where you'd got to - you were right on the ball, then disappeared:w00t:

jbuttery (4/7/2009)

---

Thanks, Chris. That syntax looks good to me.

The link on the bottom of your posts is incorrect. It should be http://www.sqlservercentral.com/articles/Best+Practices/61537/

I finally read it and apologize for my post,...

As Grant and GSquared have pointed out, there's abundant scope for improvement in this query, to make it fast and to make it pretty. Here's the first query of the...

That's it, but I've got a sneaky suspicion that the CAST has to be to VARCHAR, otherwise the zero prefix won't work.

SELECT ReviewDate, Hub, BankNumber, BranchNumber, AccountNumber =

RIGHT('00000000000000000'...

RIGHT('00000000000000000' + CAST(CAST('000000005121321212' AS BIGINT) + 1 AS VARCHAR(18)), 18)