Viewing 15 posts - 4,651 through 4,665 (of 5,109 total)
Let's tidy up that statement of your (there wasn't a question), and actually give people a table they can read (your expected data is terribly misaligned):
USE DevTestDB;
GO
-- I have guessed...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 22, 2016 at 3:20 am
I'm a little confused about your statement of adding/removing a column on your laptop/server. How are you removing a column on the package on the server if it's deployed (are...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 22, 2016 at 2:39 am
You could, instead, have the SP itself do an EXECUTE AS. That user, instead, has access to use the certificates on the other database, and, also to access the data.
You...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 21, 2016 at 10:17 am
kevaburg (12/21/2016)
Like this for a single object.....
grant execute on [schema].[procedure] to user with grant option;or like this for all stored procedures.....
grant execute to user with grant option;
The OP posted this...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 21, 2016 at 9:53 am
If you're using an SP that is cross database, permissions are not inherited.
This means that the login must have a user on the target database, and have permission to select...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 21, 2016 at 9:45 am
What do you mean not showing? Your pictures are of your SSRS Web portal and Visual Studio report designer. There isn't any data on your pictures.
Please elaborate and gives us...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 21, 2016 at 6:26 am
There could be a number of reasons. Have you had a look at the query plan? This will more than likely give you the answer quite promptly 😎
If you're not...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 21, 2016 at 3:37 am
Multi parameter will pass the list as comma separated. This would mean, for example, that a list of people would better sent like:
GetSales @Users = 'Steve,Jane,Paul'
You would need to handle...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 21, 2016 at 3:23 am
yrstruly (12/20/2016)
=iif(Fields!Gender.Value="M","Light Green","Khaki")
As Lowell said, you should have:
=iif(Fields!Gender.Value="M","LightGreen","Khaki")
None of the defined colours have spaces in there.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 21, 2016 at 3:15 am
patilar (12/21/2016)
(
Select
row_number() over (partition by id order by id ) as rnum
,*
from staging
)
Select Id,name,max(empid) as empid,max(company_id) as company_id,addres
from cte
group by Id,case when rnum%2=0 then rnum else...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 21, 2016 at 3:00 am
Let's tidy your code up a bit and put it in some IFCode brackets:
CREATE TABLE Staging (id INT,
...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 21, 2016 at 2:21 am
randheerb (12/20/2016)
Just to clarify I have spoken with Microsoft you can use backward comaptibility with server 2016 standard core licensing. It can be down graded to sql 2014 stdandard core...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 20, 2016 at 9:52 am
randheerb (12/20/2016)
I want to install sql server 2014 standard 64 bit on server 2012 R2, I have got server 2016 standard core licensse. Just want to know If I download...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 20, 2016 at 8:47 am
GilaMonster (12/20/2016)
Thom A (12/20/2016)
GilaMonster (12/20/2016)
The answers in the last two posts will work fine, but they have an inherent performance problem. Have a look at the first section of https://www.simple-talk.com/content/article.aspx?article=2280
Getting...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 20, 2016 at 7:51 am
Phil Parkin (12/20/2016)
frederico_fonseca (12/19/2016)
if excel file format is 2010 or higher then https://msdn.microsoft.com/en-us/library/office/gg575571(v=office.15).aspx may be an option.Have you tried using this? How did it go?
No, as it's a Script task,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 20, 2016 at 7:13 am
Viewing 15 posts - 4,651 through 4,665 (of 5,109 total)