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 |
immad
Posting Yak Master
230 Posts |
Posted - 2013-09-13 : 02:52:47
|
hello,how i can make a comparison of data.sqlid----foxid1--------42--------33--------2i want this type of datasqlid----foxid-----id1--------4--------22--------3--------33--------2--------please help me outimmad uddin ahmed |
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2013-09-13 : 03:04:43
|
What is the logic here? Can you explain the logic for the above output?--Chandu |
|
|
immad
Posting Yak Master
230 Posts |
Posted - 2013-09-13 : 04:00:30
|
if sqlid columns value and foxid columns value match then its shows in id columnimmad uddin ahmed |
|
|
divya.ce
Starting Member
16 Posts |
Posted - 2013-09-13 : 06:30:49
|
What value is to be shown in ID column? please give complete In and out description, In the output which you have shown, sqlid and foxid do not match, then also you are showing id column value. |
|
|
VeeranjaneyuluAnnapureddy
Posting Yak Master
169 Posts |
Posted - 2013-09-13 : 06:49:53
|
SELECT DISTINCT T.SqlId FROM Temp AS Tinner join Temp TTON T.SqlId = TT.FoxIdORDER BY t.SqlIdveeranjaneyulu |
|
|
|
|
|