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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2009-04-23 : 04:40:59
|
| how can check if my join is right?for example i meake join between 2 source, now i want the data,where can i see it? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-23 : 04:43:21
|
Use SELECT.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-04-23 : 05:13:11
|
| How do you mean you want to check the data?, do you mean that you want to make sure that the columns that you are joining on are returning the correct data from the tables |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-04-24 : 10:00:14
|
| to NeilG ,yes.to Peso, i can check just the number of ther rows |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-24 : 10:01:30
|
You can do a SELECT COUNT(*) from ...
E 12°55'05.63"N 56°04'39.26" |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-04-24 : 10:22:08
|
| peso i mean i can just check the numbers of row but ,i can't know if my data is right.if i make merge join and after that derived columns,how can i know if specific row is right or wrong? |
|
|
|
|
|
|
check in process