текст View до безобразия прост
select * from sent_tlg
where
doe beteen convert (datetime, '01,08,2004', 103) and convert (datetime, '01,09,2004', 103)
Структура таблицы
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
if exists (select * from dbo.sysobjects where id = object_id(N '[dbo].[sent_tlg]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[sent_tlg]
GO
CREATE TABLE [dbo].[sent_tlg] (
[st_id] [int] IDENTITY ( 1 , 1 ) NOT NULL ,
[tlg_txt_ID] [int] NOT NULL ,
[res_id_email] [int] NULL ,
[DOE] [datetime] NULL ,
[xHost] [varchar] ( 8 ) COLLATE SQL_Latin1_General_CP1251_CI_AS NULL ,
[x_sysUser] [varchar] ( 50 ) COLLATE SQL_Latin1_General_CP1251_CI_AS NULL ,
[SendRetry] [char] ( 1 ) COLLATE SQL_Latin1_General_CP1251_CI_AS NOT NULL
) ON [PRIMARY]
GO
