Suction

what are you trying to do, please follow the link I suggested in providing the t-sql what you are wanting help on

duplicate post

replies here please

as a follow on from this, read the first link in my signature block, it will help you in the future on how to post code for tables procedures and...

Michael Walter-477776 (3/15/2012)

1. Is there any way to configure SSMS to only point to a single server ( my assumption is that there is not - unless you separate out...

was this the only domain controller in the domain or do you have a replicated AD?

if its the only DC then you cant use AD credentials as there is no...

you either need to pass in a null value so that it gets everything, or change the last statement from @parm is null to @param = 2

thanks, will give it a go, the downloading server is a test server so dont think there will be a problem installing the extra component

thanks Howard thats great, it is roughly an hour into downloading that it does decide to time out, i've resulted in trying a number of ftp clients with no luck...

please post the DDL of the tables, the full query and test data and we can help you further.

as a side note to this, apart from winrar, are there any bult in commands like winrar which will split the files into multiple chunks, just thinking if I can...

again with the test1.rdl i still get the right results back from the test data I created in the eailer post using the first query you gave after modifing the...

i have attached the report rdl which I used, just give it a data source which points to the data and then create the query as a procedure and then...

yeah thats the same pdf

will wait for the official release of 2012 to get a bit of play on it before attending the courses

i have just created a sample report based on the query you provided using both a procedure and also the sql text embeded into a data set using a parameter...