Viewing 15 posts - 1,276 through 1,290 (of 1,360 total)
The short answer is no. Ideally the "share drive" would not be read from by your reporting server and definitely not by letter-aliased file path. In reality it always depends. ...
September 11, 2019 at 1:54 pm
I tried another simple stored procedure above, which I executed. It didn't display the results window for the SELECT statement result at this time.
Not sure which proc with what...
September 11, 2019 at 1:27 pm
What lead you to conclude it was the images which were causing the render to take so long? 400 thumbnails are tiny. Is there a query being run too?
September 10, 2019 at 9:04 pm
So I'm trying to get an external image to show after I deployed the report. When I run the unpublished report in Visual Studio it's not an issue. I...
September 10, 2019 at 8:49 pm
I have set up the "Amazon Redshift (x64) driver in the ODBC "System DSN" window and that connects fine.
Ok
I have connected SSMS to the driver via a linked...
September 10, 2019 at 5:55 pm
It's possible within tsql to set up linked servers to submit queries to different db's. However to switch between the linked servers you must use the word "go". I'm pretty sure...
September 10, 2019 at 12:53 pm
What query are you executing on the different servers? When you get the list of servers do you only get a list of IP addresses or is there usename and...
September 9, 2019 at 10:04 pm
tl;dr stands for "too long; didn't read" so your worries were well founded! But seriously, what you posted worked and I'm very glad to have helped. Readability is always a...
September 9, 2019 at 7:09 pm
This is outside my area but my 2 pennies: Witness Client and Witness Server are used to keep the cluster in sync. The error appears to have triggered a retry...
September 9, 2019 at 2:30 pm
The specific issue of: Must declare the scalar variable "@output". This is because when you specify the output variable(s) in the execute statement the target variable needs to be on the...
September 9, 2019 at 1:07 pm
Hey alright, now the code is tl;dr but it seems like you're on your way!
#3, you're correct. The proc output variable(s) can be of any type. However, the RETURN type...
September 9, 2019 at 12:21 pm
One reason the first proc is not functional is because the temporary table is out of scope. Where does #ssrsresults get created? If a temp table only has 1 '#'...
September 8, 2019 at 9:55 pm
I can always change a select-insert into a merge. There's never going to be a "WHEN MATCHED". Must try to see if it solves the problem.
Yep
declare...
September 7, 2019 at 1:07 pm
This is done. I couldn't find any satisfactory solution to placeholder replacement so the string formatting still happens in C#. All of the text files and templates have been moved...
September 6, 2019 at 8:40 pm
I think I see what you are saying about how many times the function could execute and the fact that I don't have a FROM clause. Are you saying...
September 6, 2019 at 3:47 pm
Viewing 15 posts - 1,276 through 1,290 (of 1,360 total)