Imported View has Top part missing

[Bill Egge]

Anyone else having this issue?  I am using SQL Server 2005 and imported a database and some imported views have a few first lines missing.  Others imported ok.

Example

SQL Server Correct Definition

Code: [Select]

ALTER view [dbo].[vHE_NextFilesToSend]
as
with Loaded as
(
  select
    distinct
    [Partner],
    DepositDate
  from
    HealthEquity_DeductionFile
),
NotSent as (
  select
    L.*
  from
    Loaded L
  where
    (not exists (
      select
        *
      from
        HealthEquity_Log X
      where
        (X.[Partner] = L.[Partner])
        and (X.DepositDate = L.DepositDate)
    ))
)
select
  [Partner],
  Min(DepositDate) as DepositDate
from
  NotSent
group by
  [Partner]

EA Imported Definition

Code: [Select]

CREATE VIEW [dbo].[vHE_NextFilesToSend] AS
(
  select
    L.*
  from
    Loaded L
  where
    (not exists (
      select
        *
      from
        HealthEquity_Log X
      where
        (X.[Partner] = L.[Partner])
        and (X.DepositDate = L.DepositDate)
    ))
)
select
  [Partner],
  Min(DepositDate) as DepositDate
from
  NotSent
group by
  [Partner]


Here are the tables if you want to test this

[HealthEquity_Log]

Code: [Select]

CREATE TABLE [dbo].[HealthEquity_Log](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Partner] [varchar](50) NULL,
[DepositDate] [datetime] NULL,
[ts] [datetime] NULL DEFAULT (getdate())
) ON [PRIMARY]
[HealthEquity_DeductionFile]

Code: [Select]

CREATE TABLE [dbo].[HealthEquity_DeductionFile](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Partner] [varchar](50) NOT NULL,
[SS_Alpha] [varchar](11) NOT NULL,
[DepositDate] [datetime] NOT NULL,
[ContributionType] [varchar](2) NOT NULL,
[clientId] [varchar](50) NULL,
[VoucherId] [varchar](50) NULL,
[Amount] [decimal](18, 2) NULL,
[MemberFirstName] [varchar](50) NULL,
[MemberLastName] [varchar](50) NULL,
[EmployeeId] [varchar](50) NULL,
[ts] [datetime] NULL CONSTRAINT [DF_HealthEquity_DeductionFile_ts]  DEFAULT (getdate()),
 CONSTRAINT [PK__HealthEquity_Ded__01142BA1] PRIMARY KEY CLUSTERED
(
[Partner] ASC,
[SS_Alpha] ASC,
[DepositDate] ASC,
[ContributionType] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]