What is your expected result out of the sample data you provide. I think i may have solution for it, but need to see your desired result visually..

I dont see a triangular join here. Its pretty straight forward join. Or maybe im overlooking something here :blink:

easily doable...

Can you have a gander the following article and provide us some extra information on what you are trying to acheive?

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Works fine for me though, after some minor modifications (modifications details in comments)

IF OBJECT_ID('TempDB..##myTable2') IS NOT NULL

DROP TABLE ##myTable2;

GO

CREATE TABLE ##myTable2

(

...

Yep, that's a neat one. Picked up...

You may also want to check out Jeff Moden article on arguably the fastest method in calculating running-totals as the one your requirements is putting up.

Please read it here :...

How about this?

Sample data and table structure

SET DATEFORMAT DMY ;

IF OBJECT_ID('TempDB..#Temp') IS NOT NULL

DROP TABLE #Temp;

IF OBJECT_ID('TempDB..#Calc') IS NOT NULL

DROP TABLE #Calc;

CREATE TABLE #Temp

(

...

I took the libetry to add a new table.

Would this suffice?

DECLARE @Zones TABLE (Zoneid INT IDENTITY, Zone CHAR(6))

INSERT @Zones (Zone)

SELECT...

That helps a lot.. Now, last question, do u maintain a "Zones" table where u ll have the list of zones?

Yes you can.

Can you provide us some sample table strucutre and and some sample data to work with?

Please read here on how to do that: http://www.sqlservercentral.com/articles/Best+Practices/61537/

You may want to look up Gail's article on IN vs EXISTS[/url]

Yes.. Try this

use tempdb

go

if OBJECT_ID('a') is not null

drop table a...

People here are from all over teh world and they...

Few questions

1. Can am emplolyee do the same task twice in a single day?

2. Do u have the list of tasks in another table?

3. Will the list of tasks be...

I sense dynamic Cross-Tabs[/url] here!