Error Encountered With This Code

[tksnota]

Hi,

Need assistance. Using same table gbkmut with different fields as shown.

Thanks...tksnota...

WHERE
transtype IN('N','C','P','F') AND gbkmut.datum >= ?
AND gbkmut.datum <= ?
AND gbkmut.verwerknrl <> 0
AND grtbk.bal_vw IN ('W')
AND gbkmut.remindercount <= 12
AND gbkmut.reknr BETWEEN ' 70000' AND ' 90000' AND
ISNULL(gbkmut.transsubtype,'') <> 'X'

or

transtype IN('N','C','P','F') AND gbkmut.datum >= ?
AND gbkmut.datum <= ?
AND gbkmut.verwerknrl <> 0
AND grtbk.bal_vw IN ('W')
AND gbkmut.remindercount <= 12
AND gbkmut.reknr = ' 40010' AND
ISNULL(gbkmut.transsubtype,'') <> 'X'

ORDER BY 4,5

[v-menakakota · Accepted solution]

Hi @tksnota ,

Thank you for reaching out to us on the Microsoft Fabric Community Forum.

"Could you provide more details about the issue? This will help in identifying and resolving the error more effectively."

[v-menakakota]

Hi @tksnota ,

I hope that your query got resolved. If it resolved by yourself please let us know so that it will help other community members to find it more quickly.

Thank you.

[Greg_Deckler]

@tksnota Can't validate it without the full SQL code. Also, what is the source system? Including version number as SQL syntax can vary between systems and even versions.