Groups > microsoft.public.sqlserver.programming > #31376

Re: [SAP B1] create a VIEW with UNION and WHILE

From	Ammammata <ammammata@tiscalinet.it>
Newsgroups	microsoft.public.sqlserver.programming
Subject	Re: [SAP B1] create a VIEW with UNION and WHILE
Date	2021-04-06 15:22 +0000
Message-ID	<XnsAD04B0D4F2832ammammatatiscalineti@127.0.0.1> (permalink)
References	<XnsACFE7390C25D5ammammatatiscalineti@127.0.0.1> <XnsACFEE5428854AYazorman@127.0.0.1> <XnsAD04686AF35FEammammatatiscalineti@127.0.0.1> <XnsAD04B03D21BE6ammammatatiscalineti@127.0.0.1>

Show all headers | View raw

Il giorno Tue 06 Apr 2021 05:19:27p, *Ammammata* ha inviato su 
microsoft.public.sqlserver.programming il messaggio 
news:XnsAD04B03D21BE6ammammatatiscalineti@127.0.0.1. Vediamo cosa ha 
scritto:

> INNER JOIN [@a_pippo_resp_salesm] f ON f.code = d.u_responsible
> INNER JOIN oitb pt ON pt.itmsgrpcod = e.itmsgrpcod
> 
> where h.U_F_YEAR=2021 and h.U_F_MONTH=1
> 
> cross join (values(1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12)) as 
> V(n)
> 

found ONE mistake: cross join must stay before where  :/


the create view is still underlined, maybe it's not available in SAP B1 
environment...

-- 
/-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
-=- -=- -=- -=- -=- -=- -=- -=- - -=-
........... [ al lavoro ] ...........

Back to microsoft.public.sqlserver.programming | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

[SAP B1] create a VIEW with UNION and WHILE Ammammata <ammammata@tiscalinet.it> - 2021-03-31 09:21 +0000
  Re: [SAP B1] create a VIEW with UNION and WHILE Erland Sommarskog <esquel@sommarskog.se> - 2021-03-31 22:32 +0200
    Re: [SAP B1] create a VIEW with UNION and WHILE Ammammata <ammammata@tiscalinet.it> - 2021-04-06 08:15 +0000
      Re: [SAP B1] create a VIEW with UNION and WHILE Ammammata <ammammata@tiscalinet.it> - 2021-04-06 15:19 +0000
        Re: [SAP B1] create a VIEW with UNION and WHILE Ammammata <ammammata@tiscalinet.it> - 2021-04-06 15:22 +0000
          Re: [SAP B1] create a VIEW with UNION and WHILE Ammammata <ammammata@tiscalinet.it> - 2021-04-06 15:45 +0000
            Re: [SAP B1] create a VIEW with UNION and WHILE Doc Tree <davidleerothshairpiece@gmail.com> - 2023-09-02 20:14 -0700

csiph-web