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

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

Newsgroups	microsoft.public.sqlserver.programming
Date	2023-09-02 20:14 -0700
References	(1 earlier) <XnsACFEE5428854AYazorman@127.0.0.1> <XnsAD04686AF35FEammammatatiscalineti@127.0.0.1> <XnsAD04B03D21BE6ammammatatiscalineti@127.0.0.1> <XnsAD04B0D4F2832ammammatatiscalineti@127.0.0.1> <XnsAD04B49DF6460ammammatatiscalineti@127.0.0.1>
Message-ID	<15132113-2022-459b-8b3a-5fb0c179db67n@googlegroups.com> (permalink)
Subject	Re: [SAP B1] create a VIEW with UNION and WHILE
From	Doc Tree <davidleerothshairpiece@gmail.com>

Show all headers | View raw

On Tuesday, April 6, 2021 at 11:45:20 AM UTC-4, Ammammata wrote:
> Il giorno Tue 06 Apr 2021 05:22:57p, *Ammammata* ha inviato su 
> microsoft.public.sqlserver.programming il messaggio 
> news:XnsAD04B0D4F2832am...@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 ] ...........
Man my kid told me about this thread and I COULDNT BELIEVE IT

Back to microsoft.public.sqlserver.programming | Previous | Next — Previous 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