Is it possible to merge date from 2 or 3 tables into a View?

Suppose I have three tables Type1Events, Type2Events, and Type3Events where
each table has a DateTime column for the date and time the event occurs,
along with some data specific to the event. Can I pull all events from the
three tables into a single View so that the data appears as if it were one
single table, and use a where condition for the date range so that only
events in a certain date range for all three tables appear? So my output
might look like this
EventDate Type
=================
1/1/2001 1
1/2/2001 2
2/1/2003 3
... etc...
Not sure if this makes sense but. I really don't care about the data in the
tables for this example, only the ocurrances in dates ranges for all three.
thanks,
JIM
EventTables
CREATE TABLE dbo.Type1Events (
id int NOT NULL IDENTITY (1, 1),
eventDate datetime NOT NULL,
somedata text NOT NULL
) ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE dbo.Type2Events (
id int NOT NULL IDENTITY (1, 1),
eventDate datetime NOT NULL,
somedata text NOT NULL
) ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE dbo.Type3Events (
id int NOT NULL IDENTITY (1, 1),
eventDate datetime NOT NULL,
somedata text NOT NULL
) ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
INSERT INTO Type1Events ( eventDate, someData ) values ( '1/1/2001',
'data1' )
INSERT INTO Type1Events ( eventDate, someData ) values ( '1/1/2002',
'data2' )
INSERT INTO Type2Events ( eventDate, someData ) values ( '1/1/2003',
'data3' )
INSERT INTO Type2Events ( eventDate, someData ) values ( '2/1/2002',
'data4' )
INSERT INTO Type3Events ( eventDate, someData ) values ( '3/1/2001',
'data5' )
INSERT INTO Type3Events ( eventDate, someData ) values ( '4/1/2002',
'data6' )
INSERT INTO Type2Events ( eventDate, someData ) values ( '5/1/2006',
'data7' )
INSERT INTO Type1Events ( eventDate, someData ) values ( '6/1/2004',
'data8' )
INSERT INTO Type3Events ( eventDate, someData ) values ( '7/1/2005',
'data9' )
GOcreate view events
as
select eventDate, someData from Type1Events
union all
select eventDate, someData from Type2Events
union all
select eventDate, someData from Type3Events
go|||Sorry, a more complete solution is:
create view events
as
select 1 as eventType, eventDate, someData from Type1Events
union all
select 2, eventDate, someData from Type2Events
union all
select 3, eventDate, someData from Type3Events
go|||Jeff,
Thanks a lot!, I figured it should be easy but havn't used union much so...
thanks,
JIM
"JeffB" <jeff.bolton@.citigatehudson.com> wrote in message
news:1142016783.270339.21280@.u72g2000cwu.googlegroups.com...
> Sorry, a more complete solution is:
> create view events
> as
> select 1 as eventType, eventDate, someData from Type1Events
> union all
> select 2, eventDate, someData from Type2Events
> union all
> select 3, eventDate, someData from Type3Events
> go
>

Is AUTOGROW info recorded?

Is the before & after size, autogrow start & complete time , or any other
info related to auto-growing of datafiles recorded in an error log / event /
sql log / anywhere?
tia
chris
It's not audited, AFAIK.
-oj
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:1AE8AB19-BE65-489A-91BA-F35FC4049D90@.microsoft.com...
> Is the before & after size, autogrow start & complete time , or any other
> info related to auto-growing of datafiles recorded in an error log / event
> /
> sql log / anywhere?
> tia
> chris
|||Chris wrote:
> Is the before & after size, autogrow start & complete time , or any
> other info related to auto-growing of datafiles recorded in an error
> log / event / sql log / anywhere?
> tia
> chris
You can detect an auto grow op in Profiler under Database - Data Auto
Grow /Shrink and Log Auto Grow / Shrink.
David Gugick
Imceda Software
www.imceda.com

Is AUTOGROW info recorded?

Is the before & after size, autogrow start & complete time , or any other
info related to auto-growing of datafiles recorded in an error log / event /
sql log / anywhere?
tia
chrisIt's not audited, AFAIK.
-oj
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:1AE8AB19-BE65-489A-91BA-F35FC4049D90@.microsoft.com...
> Is the before & after size, autogrow start & complete time , or any other
> info related to auto-growing of datafiles recorded in an error log / event
> /
> sql log / anywhere?
> tia
> chris|||Chris wrote:
> Is the before & after size, autogrow start & complete time , or any
> other info related to auto-growing of datafiles recorded in an error
> log / event / sql log / anywhere?
> tia
> chris
You can detect an auto grow op in Profiler under Database - Data Auto
Grow /Shrink and Log Auto Grow / Shrink.
David Gugick
Imceda Software
www.imceda.com

Is AUTOGROW info recorded?

Is the before & after size, autogrow start & complete time , or any other
info related to auto-growing of datafiles recorded in an error log / event /
sql log / anywhere?
tia
chrisIt's not audited, AFAIK.
--
-oj
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:1AE8AB19-BE65-489A-91BA-F35FC4049D90@.microsoft.com...
> Is the before & after size, autogrow start & complete time , or any other
> info related to auto-growing of datafiles recorded in an error log / event
> /
> sql log / anywhere?
> tia
> chris|||Chris wrote:
> Is the before & after size, autogrow start & complete time , or any
> other info related to auto-growing of datafiles recorded in an error
> log / event / sql log / anywhere?
> tia
> chris
You can detect an auto grow op in Profiler under Database - Data Auto
Grow /Shrink and Log Auto Grow / Shrink.
--
David Gugick
Imceda Software
www.imceda.com