Viewing 15 posts - 346 through 360 (of 440 total)
muthukkumaran Kaliyamoorthy (10/20/2011)
telnet servername 2544
Excuse me for asking, but where does 2544 come from? I have not seen any information telling what port number was specified, 2544 is definitely not...
October 20, 2011 at 2:29 am
Sorry, I don't quite understand your question. But for permissions in SSRS you either use local windows accounts or domain accounts. There is nothing like SQL Server Mixed Authentication in...
October 20, 2011 at 1:27 am
According to HP.com, the only 2.8GHz processor for DL380 G4 is a dual core processor. So, if that is right you have a single physical processor, and only need one...
October 20, 2011 at 1:23 am
First of all, if you scroll somewhat down on the forum, you'll see dedicated Reporting Services groups.
As for your question, the process is like this (depending on version of SSRS):
When...
October 20, 2011 at 1:14 am
Try to connect to IP,port. If that does not work, it is a firewall issue. You may perhaps have one or more firewalls between your client and your server?
October 20, 2011 at 12:53 am
Agreed, CTE is most likely more efficient, and proper use of filters should definitely be used. A CTE with row_number does not take into consideration that there may be multiple...
October 19, 2011 at 6:32 am
As far as I know, there is no way to do this. When SQL Server start processing the report, it retrieves all the data fro that report, then it renders...
October 19, 2011 at 5:07 am
This sounds very much like a firewall issue. Please have a look at my blog post regarding this issue.
October 19, 2011 at 5:02 am
I guess you want something like this?
update t1 set column = t2.column
from
table t1
inner join table t2 on (t2.id = (select max(id) from table where id < t1.id and column is...
October 19, 2011 at 4:57 am
Then the post is in wrong group, 2008 instead of 2005. There is no built in function for distance/coordinates in SQL Server 2005.
October 18, 2011 at 2:37 pm
Since you're using SQL Server 2008 (or later), I would have a look at the spatial datatypes, more specifically geography. This datatype with its methods is created for this kind...
October 18, 2011 at 1:33 pm
If you look at the top operator, you can see that "Is Row Count" is true. This top operator is nothign more than a rowcount. Thanks to SQL Server 2008...
October 17, 2011 at 1:00 pm
Trying to explain a bit more regarding the index deletes: For the clustered index delete you see the columns used for looking up the keys to delete, and the columns...
October 17, 2011 at 12:55 pm
Another option, create a hidden multi select parameter with all the contact names, and use join on that parameter. Works like a charm.
October 17, 2011 at 12:48 pm
Viewing 15 posts - 346 through 360 (of 440 total)