Attached.

Main table, queue table, indexes and execution plan.

Takes around 16 seconds to execute.

Thanks in advance

This could be where we are going wrong. We have clustered the unique ID column. Let me try this out on our development environment.

Thanks for all the replies.

Well the example I gave was a dumbed down version of what I'm trying to achieve. For scalability I didn't want to be limited. I've started to build out the...

That still only gives me 62 possible values? :hehe:

This was my prototype:

create table #items (itemID varchar(10), statusID int)

create table #statuses (statusName varchar(50), statusID int)

insert into #items values ('Item 1',1|2|8)

insert into #items values ('Item 2',1|4)

select * from #items

insert into...

Thanks for your reply.

The problem is the number of values can and will change - so my schema will also need to change each time a new value is added?

Thanks - going to get TFS set up for our team and see how it works out.

How does TFS deal with SSRS Reports? I've noticed when creating a SSRS Project in BIDS/Visual Studio I cannot have subfolders like I do in the SSRS Report Manager.

I think...

Did you set this up? I'm looking for advice on putting ssrs reports in to Svn.

Thanks

Nick

Tell me about it. I think we're one of the companies paying for extended support.

There is a large project to move people to Windows 7 but there are so many...

Half my team are stuck on windows XP so it's not an option. I'm on Windows 7 so will be planning on installing SSMS 2014.

Ideally we are looking to upgrade...

Koen Verbeeck (4/30/2014)

---

If they run in paralllel, they are independent of each other.

However, this is not 100% true. Say you have 7 tasks which can run in parallel.

But only 4...

Hmmm that doesn't seem to work. The other Data Flow tasks seem to continue to run in parallel.

I tried something similar with a Script task which returned a dts error...

Lets say we have a reconciliation against a 3rd party vendor where we submit sales to them.

There is a chance we can submit the same sale twice by accident. We...