Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jason Carlton Aguilar
Starting Member
5 Posts |
 Posted - 2012-02-09 : 21:14:30
|
| I have the following question and can not seem to get the correct code."Write a SELECT statement that determines whether the PaymentDate column of the Invoices table has any invalid values. To be valid, PaymentDate must be a null value if there's a balance due and a non-null value if there's no balance due. Code a compound condition in the WHERE clause that tests for these conditions."Any help at all will be greatly appreciated!Jason Aguilar |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
Jason Carlton Aguilar
Starting Member
5 Posts |
Posted - 2012-02-09 : 22:14:49
|
I am very sorry if I have upset you. I truly appreciate the help and did not realize I had posted this. Again I thank you for the help and sorry if it has bothered you.quote:
Originally posted by visakh16
how many times you'll post the same question?http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=171039------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
Jason Aguilar |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-10 : 09:23:21
|
quote:
Originally posted by Jason Carlton Aguilar
I am very sorry if I have upset you. I truly appreciate the help and did not realize I had posted this. Again I thank you for the help and sorry if it has bothered you.quote:
Originally posted by visakh16
how many times you'll post the same question?http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=171039------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
Jason Aguilar
No problem  Actually I dont have problem with thatBut I dont want others to waste time on this thinking that this has not been answered. Also keeping it single thread, it will have more reads and you'll get various suggestions in same thread itself------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Looking for help