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 |
|
mitwa1990
Starting Member
1 Post |
 Posted - 2013-06-19 : 11:54:05
|
| Hi All,I need to write a code in SQL Server in which I have 4 columns(First Name (2 columns) and Last Name (2 columns)).I have a 5th column name 'Status'.I have set a condition that if value in 1st and 3rd column [First Name]and 2nd & 4th column [Last Name] matches the status is shown TRUE else FALSE.But now I have been told to write Column name even if the data is matching or if it has discrepancy, instead TRUE or FALSE.Can anyone guide me regarding this?I am just a beginner in this field. |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2013-06-19 : 12:01:14
|
| Can you illustrate the issue with the help of an example? by providing sample data in consumable format and the expected output?CheersMIK |
 |
|
|
|
|
|
Need column name in Status column