Viewing 15 posts - 1 through 15 (of 139 total)
Thanks Linda, that's reassuring. Having rarely shared a report project with a colleague before I've never noticed this behaviour. Unfortunately, this means the reports with that data source don't run...
January 13, 2011 at 2:12 am
Thanks for this - solved my problem.
You could also insert the following if the login doesn't yet exist in each database
CREATE USER LOGIN_HERE
June 11, 2010 at 7:13 am
I agree that there's a temptation for the manager to save up everything to the annual review, sometimes long after the detail of some issues has been forgotten. But where...
May 11, 2010 at 2:59 am
On the subject of consolidating SQL Server instances, we have the opposite problem of trying to arrange separate groups of databases on one machine. This is really just get round...
November 12, 2009 at 5:02 am
glad to help, though I didn't know about Ben's solution and it is a little neater...
October 27, 2009 at 11:56 am
I don't know any way of converting a literal string into something which could be interpreted as a field name. Better to pass your @param to the underlying stored proc...
October 26, 2009 at 5:47 am
I haven't moved the SMS site database, I just want to run queries on it (in its current location) from our company SQL Server installation. I expect this...
October 20, 2009 at 10:02 am
that's much better!
October 14, 2009 at 3:33 am
neat one dystarry. And here's the solution for rows grouped by type_id:
declare @type_id int
declare cursor1 CURSOR FAST_FORWARD FOR SELECT distinct type_id FROM fruit
drop table #Temp
create table #Temp (region_id int, atext...
October 14, 2009 at 2:56 am
this is mostly useful when you have to group rows together by one field and concatenate the corresponding values for each group. How would the solution look then?
October 14, 2009 at 2:17 am
I have tried to alter the width of multi-value parameter drop-downs but have not found a way. You can however vary the width of other parameters by editing the ReportingServices.css...
September 23, 2009 at 7:42 am
OK I can empathise with that...
June 29, 2009 at 2:54 am
what is SCOME?
Standing Committee on Medical Education (SCOME)?
June 29, 2009 at 2:34 am
another problem is that when 'Select All' is selected, you have to deal with a massive string which slows down the performance of your proc, rather than ignoring the condition...
April 21, 2009 at 5:32 am
I've always used this code in my stored procs:
charindex(',' + rtrim(fieldname) + ',',',' + @paramlist + ',') > 0
April 21, 2009 at 2:01 am