SQL Code

[Whitewater100]

Hello:

I am looking to see how you would answer these two questions using SQL? Any input is appreciated! Thanks

Customer Name	Month & Year	Sales Amt
A	Jan-20	100
B	Feb-20	200
C	Mar-20	300
D	Apr-20	400
C	Oct-21	600
F	Nov-21	700
G	Dec-21	800
SQL Code for New Customers in 2021?

Name	Dept	ID		Change Null to:
a	null	1		hr
b	finance	2
c	null	3		finance
d	logistics	4

[Anonymous · Accepted solution]

Hi @Whitewater100,

As lbendlin said, your requirement seems more related to t-SQL query coding. You can post at the SQL Server forum to get better support.

In addition, you can also try to use the following follow if it helps. 

Steps:

1. Create a select query to search customer names from the raw table.

2. Add a subquery to search the customer names from the table when the year of date is less than 2021.

Subqueries (SQL Server) - SQL Server | Microsoft Docs

3. Use t-SQL 'Not IN' operator to add conditions to the main query to get customers that are not included in the subquery.

SQL NOT IN Operator (mssqltips.com)

For example:

select
    *
from
    Sales as s
where
    s.CustomerName not in (
        select
            CustomerName
        from
            Sales
        where
            Year(Sales.Date) < 2021
    )

Regards,

Xiaoxin Sheng

[Whitewater100]

Thank you Xiaxin and Ibendlin for replyimg to my question. Very much appreciated!

[lbendlin]

you posted this in the Power BI forums?

[Whitewater100]

Hi:

Do you know where I should ask this? I asked on Developer forum, on this web site. Thank you

[lbendlin]

Here maybe ?

Technet forums - SQL Server (microsoft.com)