So this is a running total , yes?

See Jeff Modens article

http://www.sqlservercentral.com/articles/T-SQL/68467/

Not knowing your data , or having any sample data to test against , this is my best guess...

Select YourSourceTable.Id,

case when JobCategoryRecord.TopTaxonomyId =...

Ok , first off thats and estimated plan not an actual plan, what i was looking for , amongst other things, was a difference between the actual rowcount and...

Whats the exact error ?,i did change the table to a temp one.

this script runs fine.

DROP TABLE #WCE_COURSE_DELEGATE_LINK

GO

CREATE TABLE #WCE_COURSE_DELEGATE_LINK (

uniqueid int IDENTITY(1,1)...

Is this a bill of materials ?

Try this...

http://sqlblog.com/blogs/john_paul_cook/archive/2009/10/11/bill-of-materials-where-used-query.aspx

Please keep your issue to one post.

http://www.sqlservercentral.com/Forums/Topic801931-360-1.aspx

is this what you are trying to achieve ?

with cteDelegates(course_code, delegate_name, delegateid ,rown)

as

(

Select course_code, delegate_name, delegateid,ROW_NUMBER() OVER (PARTITION BY DELEGATEID ORDER BY DELEGATEID)

...

Please see the links in my signature below

Without a question from the OP , we shall never know 🙂

The overhead of calling a function is quite large

http://www.sqlservercentral.com/Forums/Topic790541-145-2.aspx#bm790978

Try this page

http://www.sommarskog.se/arrays-in-sql-2005.html

I'll go for "whats then velocity of an unladen swallow" 😀

And the question is ?

In the past, i have solved this sort of issue by having an extra column on the target table to store the source id. That way you have something...

Why are you converting to a varchar ? varchar(what) by the way ? if you dont specify it defaults to 1

select Top 10 Firstname, Middlename, surname, year(dateofbirth) - year(Getdate()) from...