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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-09 : 08:03:34
|
| Patty writes "I have to create a query to list mismatches on three different columns. There are numerous entries(9 pages) in these 3 columns, so ideally I would put these in a table for comparison purposes. Ex: If plan code is not a valid plan for the program code then print it out. If plan and program are valid, check the term to make sure it is valid for the program and plan. If not, print it out. What do you think would be the most simplistic way to accomplish this?" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-07-09 : 08:53:29
|
| To make this a bit more clear, post your ddl and some sample data, along with your expected rowset....<O> |
 |
|
|
|
|
|
complex case statement?