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, 1 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

            
            
                                                
        

Be brave. Read the documentation. There are examples of how to properly use all this stuff there.

CREATE TABLE #d(
 HTS_NUM CHAR(4),
 Ctry CHAR(2),
 GA_REQ_CODE CHAR(3)
 );
GO
INSERT INTO #d VALUES ('1062','US','FD3'),('1062','US','FW2'),('1062','US','FD3');

SELECT DISTINCT HTS_NUM
 , Ctry
 ,stuff((
    SELECT ', ' + cast(GA_REQ_CODE as varchar(max))
    FROM #d
    FOR XML...

Could you post some sample data in the form of CREATE TABLE and INSERT scripts?

and where's your CREATE TABLE script?

TOP  and CROSS APPLY... and absent another table, you might need DISTINCT.

Post your attempt... if we just tell you the answer, you won't learn anything.

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

What's the business question you're trying to answer?

Back up a step.  What's the question you're trying to answer?

Why not post some consumable data so people can just run it and help solve your problem?

use...