Viewing 15 posts - 2,851 through 2,865 (of 5,109 total)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 16, 2017 at 4:43 am
To the OP:
is this meant to be a dynamic statement, or are you tables really of this format? Are all your tables named "t#" and your columns named...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 16, 2017 at 4:38 am
At a guess, maybe because you have two sets of double quotes: ExecuteSql"(varchar(max),"USE MASTER. Thus the second one is closing your first; making your entire query un-encapsulated. Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 16, 2017 at 1:38 am
Duplicate of https://www.sqlservercentral.com/Forums/1901858/Unable-to-access-Reporting-services-reports-from-application. Please stick to one topic per discussion.
As stated in the other topic though, I think you're out of luck. Put your computer(s) in...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 16, 2017 at 1:28 am
You say it provides "Wrong results", however, you have provided us any data to work with, or what you expect the right results to be. This'll be difficult to troubleshoot...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 16, 2017 at 1:25 am
If the JOIN is still really slow, then I imagine your Indexes have been poorly chosen. Providing DDL with the indexes would help.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 16, 2017 at 1:05 am
Why are joining onto Table B 3 times on the same value? You could return the same column 3 times with 1 JOIN, not use 3 to the same value...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 15, 2017 at 2:36 pm
I can't tell you a lot either I'm afraid. I do have it, and use it, but that was due to more necessity than choice; SSMS isn't available on Linux...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 15, 2017 at 4:49 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 15, 2017 at 3:11 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 15, 2017 at 3:09 am
And we're done! Whoop whoop!
Surprisingly went smoothly, and didn't end as a midnighter. 😀
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 14, 2017 at 2:11 pm
"Not working"? What do you mean? Does it return incorrect results? Error? (You didn't provide an error message though). Mayne your SQL Server falls over when you use your query?...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 14, 2017 at 2:09 pm
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 14, 2017 at 2:02 pm
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 14, 2017 at 1:48 pm
That looks like you're trying to connect via an AD account, however, Unix/Linux doesn't natively support Domain Authentication.
Can I assume that you do indeed have kerboros installed on...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 14, 2017 at 10:56 am
Viewing 15 posts - 2,851 through 2,865 (of 5,109 total)