you have posted in "SQL Server 7,2000 ".....what MS SQL version are you really running?

February 6, 2018 at 8:02 am

#1978709

as a side issue what is the datatype for [ie].[DateTime]
am just wondering what this bit of code is for?
CONVERT(varchar(10),REPLACE(CONVERT(varchar(10), [ie].[DateTime],101),'/','-')) AS [Void_Date]

Data Tab > queries and connections >> right click your query >edit
New Query editor opens....Home tab > advanced editor.

hope this helps

https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

@paul-2

for clarification please.......if you use these dates 1^st October 2017 to 31 December 2017 for your report and a customer has orders in Oct and Dec but...

wild guess.....

SELECT ABS(id)
FROM yourtable
GROUP BY ABS(id)
HAVING(COUNT(DISTINCT grp) > 1);

first off...please read this link https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/    You will be surprised how you get faster and better answers by following the advice.
secondly why return -102 and not 102?

some sample data would help please.....your question doesnt really make any sense without data that shows your problem