stored proc on typed tables

wishlister · #1 (**permalink**) 03-08-07, 10:59

db ESE
i have typed tables. i will create a stored procedure where i will store all the data from the 2 subtype tables in one table. for example, if i have supertype person with subtypes employee and student. in the new table that i will create, all the data will be included regardless of their type and having nulls to those fields that are not appropriate for each.
sample
personID name type studentID empNo
1 abc S 123 <blank>
2 def E <blank> 456

wishlister · #2 (**permalink**) 03-08-07, 12:03

how can i perform union of those two tables?

stolze · #3 (**permalink**) 03-09-07, 04:05

Typed tables already provide that functionality. So what exactly are you asking here?

Internet Services

Web Development

Digital Marketing

Consumer Tech