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

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

Path	csiph.com!weretis.net!feeder8.news.weretis.net!feeder5.news.weretis.net!news.solani.org!.POSTED!not-for-mail
From	Ammammata <ammammata@tiscalinet.it>
Newsgroups	microsoft.public.sqlserver.programming
Subject	Re: [SAP B1] create a VIEW with UNION and WHILE
Date	Tue, 6 Apr 2021 15:45:16 -0000 (UTC)
Message-ID	<XnsAD04B49DF6460ammammatatiscalineti@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> <XnsAD04B0D4F2832ammammatatiscalineti@127.0.0.1>
Mime-Version	1.0
Content-Type	text/plain; charset=us-ascii
Content-Transfer-Encoding	7bit
Injection-Date	Tue, 6 Apr 2021 15:45:16 -0000 (UTC)
Injection-Info	solani.org; logging-data="28985"; mail-complaints-to="abuse@news.solani.org"
User-Agent	Xnews/??.01.30 Mime-proxy/2.3.c.1 (Win32)
X-Face	s5/Tl9"^@"z`/]&NeE,Wl.^B~E2x9PA?1n:XZq2^T2Prz},H~M'2.@~v9MXx\|OL8<EqC0MU$v+`Pu;`eq$N12\Nc*)cp$iBgD/wysO=)P%n6)\Xf}L\E$-0s\mD::Dx\6QwNh<U!LBH1Xj(=zy?OV.\|=]We",DS\6[:
Cancel-Lock	sha1:bryho4T32MgTPvDgXvduU9jtMxM=
X-User-ID	eJwFwQkBwDAIA0BLfAEqp6TDv4TdwVOTFYkMLHaeHmU1GqnfHTeDjBe9QqvFLmhXh6/GW2LOPrLzLPNTlR87nhUk
Xref	csiph.com microsoft.public.sqlserver.programming:31377

Show key headers only | View raw

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

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

ok, once I removed the CREATE command it worked in SQL MMS

then I copied the code in the VIEW but I got another error because of a 
couple of DECLARE statement

finally, removed also those lines, the VIEW now works fine and Excel can 
create the PIVOT table

well done, thank you once more

-- 
/-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ 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