Thanks everyone. I passed on suggestions up the food chain but they decided to let it run, 7 hours later...........

Jeff thanks for that, getting a cool from you wow. The problem was we had to get all till transactions from a large group of outlets, in case there was...

Re Jeffs comment Did the identify any limits or extenuating circumstances?

I was tasked with importing over 15000000 rows of data, first having to delete a massive amount of existing data....

I finally found the problem, when I downloaded both editions (2016,2019) they were .iso files. Not having a disk drive I checked what software to use to run them I...

I spoke too soon.

I have created a new windows login and added it to the server. The login has minimal rights to run reports.

In report manager I have tried to...

Issue solved I used RS configuration and added an execution account.

Same issue - was trying to edit

Great thanks very much, default values doh

The base report has the parameter name of directorate the sub level has the parameter name of group so on the text box action I pass Group with a value...

Excellent many thanks

Rus

I think the problem is with the data handling layer as the data is stored as nvarchar. It does appear that the appearance of data that is stored differs from...

Thank you for that Russ but there is still a problem

Entered in the web site:- Its all greek to me ?

Results from query analyser:- Its all greek to me Ώ

Output...

Sorted variable problem

I have a execute package task but although it appears to run it does notdo anything. The package I am calling has a sequence container which contains an execute sql...

You know that 'oh god why dont i keep my big mouth shut feeling' well I have just experienced that. First of all the dba is saying the whole file...