Viewing 15 posts - 4,981 through 4,995 (of 5,109 total)
I ended up fixing it by changing the colour of every server in my registered servers. It seems that if you simply use Ctrl+N to create a new query, it...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 15, 2016 at 4:05 am
On SSMS 2016, no. My Options->Editor Tab and Status Bar -> Single server connections is even set to Khaki, but it's still this really dark blue! 🙁
I've even uninstalled and...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 15, 2016 at 1:55 am
What you're looking for is a Merge, for the insert/update. Here is an example that should help you:
Create table #Test (CustomerID int,
Name varchar(20),
City varchar(20));
Insert into #Test
Values (1, 'Steve','London');
Select *
from...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 14, 2016 at 10:17 am
Apparently mofcomp.exe (which is contained your system32) can compile these files. I would suggest a Google.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 14, 2016 at 5:20 am
Just to check, previously you stated you were trying to access Program Files (x86), but your path is now Program Files. Is this correct?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 14, 2016 at 4:21 am
What do you mean by trying to Connect to Program Files(x86)? Program Files is a directory, so you would simply browse to it. In Command prompt this would be 'cd...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 14, 2016 at 2:36 am
What do you mean you are are not able to? is the report showing no results, or is it erroring?
If it is erroring, then please paste the error here. If...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 13, 2016 at 9:27 am
Tablix's (and many other items), on SSRS have a visibility value. You can access it by right clicking the tablix, selecting Tablix Properties, and then going to the Visibility Pane.
As...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 13, 2016 at 9:14 am
It looks like you're linking to another report on SSRS. You don't need to do a Hyperlink to do this, there is an Action pane, of which one of the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 13, 2016 at 8:55 am
Glad to help 🙂
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 13, 2016 at 5:35 am
Ok, you'll need to link your embedded shapefile to a dataset. You can do this by the following:
-Right click the Layer in the Map Layer Pane and select "Layer Data..."
-Select...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 13, 2016 at 5:25 am
Where is your Geography data coming from? Is it a dataset or is it a layer embedded in the report? I might be wrong, but I'm not sure you can...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 13, 2016 at 5:00 am
Koen Verbeeck (7/12/2016)
Keep those 2016 questions coming! 🙂
2106* 😉 Steve is almost 100 years ahead of the game!
(sorry, couldn't resist)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 12, 2016 at 9:58 am
Is the format of your excel documents likely to change? Also is each one in the same format?
I have a task I run at work that reads 5 Excel Worksheets...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 11, 2016 at 3:36 am
What do you mean by after the page break then?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 8, 2016 at 7:53 am
Viewing 15 posts - 4,981 through 4,995 (of 5,109 total)