Sorry about the alias' and the no lock stuff, its not my code, i was passed it from someone who uses a drag and drop programme to build the query...

thanks for the reply. we have tried the mysql...

Thank you, sorry for being a n00b. its working now i followed those instructions.

thanks again

Hello again, i thought i would re-use this thread as it is dealing with the same report.

I have come round to running this report again for the previous year and...

Hi,

thanks for anyone who looked into this, the problem is fixed now. it was to do with the network.

its a college network running RM software 🙁 and the smartcache software...

:D:D:D:D:D

Thank you. as u might be able to guess that worked. thanks for your time over the past few days.

now i just hope my training course comes around soon. lol

Hi,

I am not using the Intel software, just the standard MS Visual Studio .net 2003 (Reporting Services)

i had a look for something similar in that with no luck. sorry about...

thanks,

I did make it a parameter but it didn't seem to get passed to the report. it asks for it before i click 'View Report' but then comes up with...

i didnt write that bit. its from a program we use that creates the sql for certain things. once i have everything working iam going to try and clean it...

are you saying my coding skills are bad... lol i would have to agree with you.

thanks, will give it ago.

Hi,

I tried using ## with no luck. heres the code

--------------------

DECLARE @sql varchar(1000) DECLARE @stat varchar(10) DECLARE @date varchar(20) DECLARE @tg varchar(10) CREATE TABLE ##t(ref varchar(12)

collate...

thanks for all your help. i have managed to get it working now.

all i had to do was switch round the variables in the where statement.

i.e - it was "where...

How would i find out the collation of a table? i have tried puting the results of one query into a temp table setting to collation to both types it...