Reply to post:

Plusnet vows to shove a sword in members area 'White Screen Of Death'

Rudolph Hucker the Third

/*

SQL script used to count the number of complaints.

Guaranteed to always be a small number.

*/

declare @Today date = getdate(), @CountComplaints int;

select @CountComplaints = count(distinct P.CustomerID)

from SupportForum.dbo.Post P

where P.PostDate > @Today

and P.PostTitle like '%billing system%';

if @CountComplaints = 0

print 'We are not aware of any issues with the Billing System';

POST COMMENT House rules

Not a member of The Register? Create a new account here.

  • Enter your comment

  • Add an icon

Anonymous cowards cannot choose their icon

Biting the hand that feeds IT © 1998–2019