topic Re: SQL Code in Developer

SQL Code

Whitewater100 — Fri, 04 Mar 2022 21:51:41 GMT

Hello:

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

lbendlin — Sat, 05 Mar 2022 21:43:28 GMT

you posted this in the Power BI forums?

Whitewater100 — Sun, 06 Mar 2022 00:12:04 GMT

Hi:

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

lbendlin — Sun, 06 Mar 2022 00:44:02 GMT

Here maybe ?

Anonymous — Thu, 10 Mar 2022 05:48:43 GMT

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.

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

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 — Thu, 10 Mar 2022 12:55:46 GMT

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