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 |
|
Nageswar9
Aged Yak Warrior
600 Posts |
 Posted - 2008-12-31 : 04:11:42
|
| Can Any One Suggest that is there any case where we can use except,union all or intersect in Derive Tables. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-31 : 04:14:36
|
| yup. you can use union all, execpt,... inside derived tables. some of cases are where you want to get records from two tables and merge them onto third table, or get those records which are in one table not in other,... |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
raky
Aged Yak Warrior
767 Posts |
Posted - 2008-12-31 : 04:17:51
|
| Hi,Sure you can use except,union all or intersect in Derive Tables.Be cool... |
|
|
|
Nageswar9
Aged Yak Warrior
600 Posts |
Posted - 2008-12-31 : 04:18:55
|
| Ok, Thanks visakh,Peso |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-31 : 04:23:54
|
| welcome Nageswar |
|
|
|
|
|
|
Derived Tables