Hi,

Thanks for the reply. 🙂

Yes, an SQL Server agent job that runs overnight and polls my results table will work, it will at least provide my user with notifications but...

Here is the complete sequence of tasks in the workflow:

1. Get list of current Sales Order from db

2. Get list of current System Stock from db

3. Get list of current...

Hi Jonathan,

Thanks for your reply.

Unfortunately, I couldn't find a way to make the logic work in T-SQL.

Basically I need to update the main table with rows from the 4 sub-tables,...

Well I spent two days on this and couldn't get the trigger to work even though the code works fine when run outside of my trigger.

Eventually I simply moved the...

Thanks for the excellent advice guys.

Having done some further work on this along the lines you suggested I have reached the conclusion that a custom control in my report to...

Thanks for the replys.

I am using SQL Server Business Intelligence Development Studio/VS 2005 to develop my report.

There are two queries used in my report. The first is just a lookup...

I have added a second parameter to the report. The problem I am experiencing is that the items in the first multi-value parameter are not linked with those in the...

I had not used CTE's before but having now looked their recursive properties they do provide exactly what I needed.

Many thanks. 🙂