Viewing 15 posts - 31 through 45 (of 68 total)
It looks like it was because I had the snapshot view option on. Although I am still confused as to why the report doesn't choose the last date value...
June 6, 2012 at 9:16 am
Hi Sergei, I tested my data sources on my Reporting Service intranet and the tests were all successful. Any other idea on what might be causing this?
June 5, 2012 at 11:45 am
Hi knowitall, what exactly is the "properties of a solution?" I have about a dozen different data sources on the server and I am receiving the same error message...
June 5, 2012 at 11:10 am
Messages in the error log are the same. This error is occuring for all reports on the server. Does anyone know of a solution for this?
June 5, 2012 at 10:38 am
How do I change the current connection to a different database?
May 29, 2012 at 8:27 am
Brandie, deleting the encryption key will cause you to lose all of your saved connections associated with your reports. I used the forums because the Google results aren't sufficient....
May 23, 2012 at 11:26 am
Hi, the above thread corresponds to SQL Server 2005. I don't see the same options in SQL Server 2008 R2. Does anybody know where to find the same...
May 23, 2012 at 11:14 am
Is there a way to change the default setting so that you wouldn't have to do this for each thread you participate in?
May 18, 2012 at 2:25 pm
Hi Eugene,
I'd like to divide the statement into separate subscripts because the subscripts need to be processed in sequence. I was opening to use the GO command so that...
March 5, 2012 at 1:02 pm
I wanted to know if it was possible to subdivide the statements into separate scripts. But it sounds like it's not possible with the GO statement since it would...
March 5, 2012 at 10:12 am
I am assuming there can only be one test ID and test result "Negative" combination per test ID
COUNT *
FROM (SELECT *
FROM Stays
INNER JOIN Orders ON Stays.AA_ID =...
February 29, 2012 at 12:51 pm
Four steps
Query "step1":
SELECT a.col1, Max(a.col2) AS MaxOfcol2
FROM a
GROUP BY a.col1;
Query "step2":
SELECT a.col1, Max(a.col2) AS MaxOfcol21
FROM a LEFT JOIN step1 ON (a.col1 = step1.col1) AND (a.col2 = step1.MaxOfcol2)
WHERE (((step1.MaxOfcol2) Is Null))
GROUP...
February 29, 2012 at 12:37 pm
Hey there, I would go with the 3rd option. The users would still be able to reference the tables on the original DB through a linked server connection, but...
February 29, 2012 at 12:23 pm
getdate() retrieves the time too. So unless your orders were placed at this second, they're not going to return in the results section
February 22, 2012 at 9:00 am
Viewing 15 posts - 31 through 45 (of 68 total)