I'm trying to get a dynamic list list to work using the following expression but I keep getting the error ...
Cannot insert the value NULL into column 'customer_no', table 'impresario.dbo.T_LIST_CONTENT'; column does not allow nulls. INSERT fails. The statement has been terminated
SELECT DISTINCT a.customer_noFROM T_ORDER_SEAT_HIST AS a WITH (NOLOCK)
join VS_PERF AS p WITH (NOLOCK) on a.perf_no = p.perf_no
where p.perf_dt between getdate() and Getdate()+2
Any tips?
Cheers,
H
Can you just stick a 'and a.customer_no is not null' condition?
Yeah just worked that out Damn you line 195!!!!
And thanks lovely man - hope you are all OK at the Brandy!
Surviving, just. But I think we're all in the same situation. Hope you are all well too!
By the way, you've got me curious now why there are null customer numbers in T_ORDER_SEAT_HIST but I think my curiosity will have to wait a little bit...
Because that table holds all the hold code changes and stuff before you put a person in there. DOH!
Ingenious! Well I can go back to my cancellations then.