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 5 years, 10 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 5 years, 9 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 5 years, 10 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

Having users share the same front end is a recipe for disaster. Some really smart Access folks have written tools for forcing the distribution of new front ends so that...

I agree. Normally, in an article like that, the author would pose the questions and maybe format them as bullet points because that makes them stick out... then later he...

Has my customer conversion rate improved since this time last quarter?

What is my annual sales growth as compared to last year?

The answers to the questions can be found by using...

Expected results?

OR the two parts together????

select p.PartID, p.PartNumber,m.SupplierId,m.TradeCode from #tempsupplier m 
inner join #parts p   on p.SupplierId=m.SupplierId
where not exists ( select 1 from  #TradeCodes t where t.TradeCode=m.TradeCode)
OR...

One way... You may need to modify the FORMAT()… bit to get the dates formatted the way you want. I did that because I wanted them cast as strings.

            
January 18, 2020 at 3:27 am
            
#3716481