Re: selecting Fields for Report

Thanks for the help!
but it seems I can only create a union for the first sql statement
(system1)
I keep getting errors 'Characters after end of sql staement' or syntax
errors
if i try to add the additional unions

any ideas?

.

Relevant Pages

  • Re: Stipping all alpha characters from a string
    ... hi alyx, ... insert into t select 'call me' union all ... select strn, dbo.fn_numeric'numeric' ... > I need to strip the characters down to only a number so I can evalute ...
    (microsoft.public.sqlserver.mseq)
  • Re: RunTime Datatype Determination in C
    ... Richard Tobin wrote: ... a union of the possible types, ... "Consideration shall be given to the need for as many as 32 characters ... in some alphabets" - X3.4, ...
    (comp.lang.c)
  • Re: Newbie question on unions
    ... patleonard wrote: ... > Characters: XY ... > union test_union{ ... > short int i; ...
    (comp.lang.cpp)
  • Re: help neeed statement
    ... length would not exceed 8000 characters: ... from sysobjects ... > i need to create a union select statement with all tables that have 'Mail' ... > how would i creat the statement? ...
    (microsoft.public.sqlserver.programming)
  • Re: field limit
    ... You can try switching to a UNION ALL query vice a UNION query. ... The union is finding only distinct rows of data and to do so it automatically ... truncates the Description to 255 characters. ... BUT looking at your query I don't understand why you are using a UNION query at all. ...
    (microsoft.public.access.queries)