Viewing 15 posts - 1,336 through 1,350 (of 1,413 total)
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
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 '#'...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
September 6, 2019 at 3:47 pm
If you run it a million times. In this case here the OP has no 'from' clause so it only executes once. I actually did read your article a while...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
September 4, 2019 at 10:59 pm
If you're looking for something simple a scalar function could work. The calculation requires no rows or columns. If you know the function is accessed by query(s) in a proc...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
September 4, 2019 at 6:23 pm
Set operators work best when the tables are identical. In this case there are different collations between tables. Since "we're talking about thousands of columns across 100s of tables" it...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
September 4, 2019 at 1:07 pm
Viewing 15 posts - 1,336 through 1,350 (of 1,413 total)