If you're doing an insert where you don't want the constraints checked, you can script out the constraints on the table, then drop them, do the import, then add them...

Did you actually install SSMS? The weird thing about the newer installers from MSFT is that all the pieces are separate. If you search for it, can you find this...

Don't think you can do that very easily with SSRS. the best I think you can do is to make the filters optional... Except you can't build complete filters through...

Too hard to just copy & paste your CREATE TABLE and INSERT scripts here?

Would be easier to help with some sample data... It can be completely fake, just representative.

Some days I can't see the forest for the trees. If the filters are all optional, you can do the filtering in SSRS. (So you could have a whole bunch...

If you think about DAX like a programming language, the functions either return scalar values or tables. And the functions in DAX receive either table-type objects or scalar values too....

So you want to make some parameters optional?

SomeColumn = COALESCE(@ParameterName, [SomeColumn])

So If @ParameterName is not assigned a value, then the comparison evaluates to

SomeColumn = SomeColumn

… so it's...

Could you please post create table scripts and some sample data and expected output?

Since you're new here, welcome! And some reading: How to post a question to get the...

• This reply was modified 6 years, 3 months ago by pietlinden.

Just wondering, but why are you doing a PIVOT in T-SQL at all? Why not do it in the presentation layer (Excel, SSRS etc)?

if you absolutely have to do it...

• This reply was modified 6 years, 2 months ago by pietlinden.

You'll get tested answers if you provide some consumable data... How about...

SELECT ID, StartDate, EndDate, ContractValue, Manager
FROM 
(VALUES (1,'2019-11-01','2020-06-30',45000,'Stephen Smith'),
(2,'2019-12-01','2020-07-30',75000,'Carol Kenin'),
(3,'2020-01-15','2020-08-30',25000,'John Gnan'),
(4,'2020-02-01','2020-09-30',40000,'Jacob Joklin')) z(ID, StartDate, EndDate, ContractValue,...

I think I know what happened... MSFT was sneaking in updates while I was testing. Gotta love invisible updates.

Looks like this might be what you're looking for:

SELECT acc, COUNT(DISTINCT(token)) AS dc
FROM Test1
GROUP BY acc

I think I tried the 2016 version. Any time I try to connect to an ACCDB, it fails. If I use Jet4.0 with an MDB file, it works fine. The...

• This reply was modified 6 years, 3 months ago by pietlinden.

Google is your friend:

https://docs.microsoft.com/en-us/sql/relational-databases/security/sql-server-certificates-and-asymmetric-keys?view=sql-server-ver15