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

You have to specify defaults when you create the table using the DEFAULT keyword. Then if you don't specify a value for that column when you insert a new record,...

It's easier to start with one fact table and create dimension tables for that.  It's certainly possible to have more than one fact table in a model, but if you're...

Use the Import/Export wizard to create an SSIS package that does it?

There's probably a better way, but one option is to automate Word.

Open file,

Run Replace

Save

Go to next file. (you can use DIR() to get the next file)