This is not dynamic, if you have more than just products A, C, P and NULL, but as I said above, I have little information to go on. if you...

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...

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...

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...

The OP posted this...

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...

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...

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...

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...

As Lowell said, you should have:

=iif(Fields!Gender.Value="M","LightGreen","Khaki")

None of the defined colours have spaces in there.

patilar (12/21/2016)

---

; with cte as

(

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...

Let's tidy your code up a bit and put it in some IFCode brackets:

CREATE TABLE Staging (id INT,

...

randheerb (12/20/2016)

---

Hi,

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...

randheerb (12/20/2016)

---

Hi,

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...

GilaMonster (12/20/2016)

---

Thom A (12/20/2016)

---

Getting...