Archives of the TeradataForum

Message Posted: Mon, 03 Dec 2007 @ 11:06:51 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Soumya,

When I face a situation like yours, I typically replace the first line of the query (Delete Fac) by something like (Select fac.acct_id, fac.acct_sfx_num, .... ), so that gives me a clue of what is happening, and helps me to debug the query. I keep the rest of the query, starting with the FROM clause unchanged!

This always worked for me and I have never had a situation before where the select clause was returning 6500 rows and when I changed the SELECT by the DELETE, the delete clause was affecting less rows (6300 rows).

I hope this helps.

	<Prev	Next>		<<First	<Prev	Next>	Last>>