I completely missed the different years - so change the where clause to:

WHERE Balance > 0
OR (last_modified_date >= '20210401' AND last_modified_date < '20220401')

So if the item...

How about:

SELECT  A , B , C ...

From Table_A

WHERE ( last_modified_date  between '01/04/2021 00:00:00' and  '31/03/2022 23:59:59' ) 
OR ( balance  > 0 and last_modified_date ...

• This reply was modified 2 years, 5 months ago by  pwalter83.

If you want to exclude, simply reverse your conditions.  For example, rather than "IN" use "NOT IN" or instead of "<" use ">=".  Or, alternately, toss some brackets around...

Actually I want to exclude rows in the dataset not include based on the condition.

Hi,

Thanks for your reply.

just as a general query, could you please help on how to exclude rows in sql if there are multiple conditions involved.

I will try to build up...

Can they select multiple offices or fol_num's?  If so, then it gets a lot more challenging, but if not, then it should be something like this:

AND...

Sounds like homework to me...

AS PP said, no code without DDL and populated tables... but here is my approach:

Q1: CTE to filter cases to 2010H2, CTE to apply RANK()...

This sounds like a homework assignment...

Question 1 is pretty trivial as you are just using datediff on the Cases table with a WHERE to put the date greater than...

Thanks for your kind help. Will try to proceed now.

Thanks, I have tried using Throw as you suggested buts its still showing the same error comment without mentioning the exact stored procedure which is giving the error

Please find the DDL and sample data below.

the requirement is to display the product_ID for the row where the values have changed for the following 5 columns:

Main_Product

Product_Colour

Product_Size

Tax_Class_ID

Outer_Print_Name

Thanks...

• This reply was modified 4 years, 6 months ago by  pwalter83.
• This reply was modified 4 years, 6 months ago by  pwalter83.

Thanks but I need to display the IDs for all the rows for which the values have changed for 4 columns.

DECLARE 
@String VARCHAR(100) = 'CKflower2002-pouch-5AR-OneSize'
select 
SUBSTRING(@string,PATINDEX('%[0-9]%',@string),PATINDEX('%[^0-9a-z]%',@string)-PATINDEX('%[0-9]%',@string))

That will work for whatever the first delimiter is and for any length of string before the numbers.  It...

DECLARE 
@String VARCHAR(100) = 'CKflower2002-pouch-5AR-OneSize'
select 
SUBSTRING(@string,PATINDEX('%[0-9]%',@string),PATINDEX('%[^0-9a-z]%',@string)-PATINDEX('%[0-9]%',@string))

That will work for whatever the first delimiter is and for any length of string before the numbers.  It does assume...

Hi Neil,

Many thanks for your kind response and it would work well in certain situations....

• This reply was modified 4 years, 6 months ago by  pwalter83.
• This reply was modified 4 years, 6 months ago by  pwalter83.