RE: Maximum Length Issue

instead of '[' ,']' (square baracket ) use '(' ,')' and do not use '.'
before 'AS'.
your problem will be solved

"Travis" ने लिखा:

> Hi ,
>
> I perform the query show below to find the duplicate records within the
> table itself
>
> "SELECT f_table.flt_Id, f_table.Psg_Id, f_table.Flt_dt_Id
> FROM
> [SELECT
> Count(F_Sgmt_History.flt_Id),
> Count(F_Sgmt_History.Psg_Id),
> Count(F_Sgmt_History.Flt_dt_Id),
> F_Sgmt_History.flt_Id, F_Sgmt_History.Psg_Id, F_Sgmt_History.Flt_dt_Id
> FROM F_Sgmt_History
> GROUP BY F_Sgmt_History.flt_Id, F_Sgmt_History.Psg_Id,
> F_Sgmt_History.Flt_dt_Id
> HAVING (((Count(F_Sgmt_History.flt_Id))>1) AND
> ((Count(F_Sgmt_History.Psg_Id))>1) AND
> ((Count(F_Sgmt_History.Flt_dt_Id))>1))]. AS f_table INNER JOIN F_Sgmt_History
> ON (f_table.Flt_dt_Id = F_Sgmt_History.Flt_dt_Id) AND (f_table.Psg_Id =
> F_Sgmt_History.Psg_Id) AND (f_table.flt_Id = F_Sgmt_History.flt_Id)"
>
> But I get the following error
>
> "Server: Msg 103, Level 15, State 7, Line 3
> The identifier that starts with 'SELECT
> Count(F_Sgmt_History.flt_Id),
> Count(F_Sgmt_History.Psg_Id),
> Count(F_Sgmt_History.Flt_dt_Id),
> F_Sgmt_History.flt_Id, ' is too long. Maximum length is 128.
> Server: Msg 156, Level 15, State 1, Line 3
> Incorrect syntax near the keyword 'AS'. "
>
> I am not sure wat's wrong with the statment , please help
>
> --
> Travis Tan
.

Relevant Pages

  • Maximum Length Issue
    ... I perform the query show below to find the duplicate records within the ... Travis Tan ... Prev by Date: ...
    (microsoft.public.sqlserver.mseq)
  • Exist Return Values
    ... I like to use a variable to store the return values of the ... I unable to do that from my query show ... Travis Tan ... Prev by Date: ...
    (microsoft.public.sqlserver.mseq)
  • Delete Query
    ... I'd like to create a query that checks for duplicate records and deletes the ... record that, on an autonumber field, has the smaller value? ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Hide duplicate records
    ... Is there a way to hide duplicate records in a query, I tried to do it in a ... report and it still shows the duplicate records. ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Identifying Duplicate Records
    ... response to what appeared to be a barely relevant question. ... in the list of options is Find Duplicates query. ... or bring up the dupe records to look at them. ... have a find duplicate records wizard. ...
    (microsoft.public.access.formscoding)