Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

SQL query

5 posts in DataWindow Last posting was on 2009-08-26 18:17:27.0Z
shk Posted on 2009-08-19 08:30:14.0Z
From: shk <krishnahari18@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: SQL query
Date: Wed, 19 Aug 2009 01:30:14 -0700 (PDT)
Organization: http://groups.google.com
Lines: 33
Message-ID: <5f6b8a16-62a2-4036-922a-244394cea219@g1g2000pra.googlegroups.com>
NNTP-Posting-Host: 121.242.65.82
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1250670614 6175 127.0.0.1 (19 Aug 2009 08:30:14 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 19 Aug 2009 08:30:14 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: g1g2000pra.googlegroups.com; posting-host=121.242.65.82; posting-account=3bgqjwoAAADrrBLTF1jYtu1n86yiCXyU
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!nntp1.roc.gblx.net!nntp.gblx.net!nntp.gblx.net!nlpi057.nbdc.sbc.com!prodigy.net!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!g1g2000pra.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89794
Article PK: 418982

Hi all,
I am Using ASA 8.0 and PB 8.0

The table entries are as follows


Dept_id persons main

1 A1 1

1 A2 0

1 A3 0


By using above table data I want to fill the following table with
values as follows

Dept_id Person1 Person2 Person3

1 A1 A2 A3


Here Dept_id is already present in the table so I want to update only
Person1 person2 person3 information

Is there any way to build the query for the same?

The query should be compactable in SQL server also



Thanks in advance


Millard F. Brown III[Team Sybase] Posted on 2009-08-19 15:53:22.0Z
From: "Millard F. Brown III[Team Sybase]" <millard.brown@teamsybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <5f6b8a16-62a2-4036-922a-244394cea219@g1g2000pra.googlegroups.com>
Subject: Re: SQL query
Lines: 43
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3598
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a8c1ff2$4@forums-1-dub>
Date: 19 Aug 2009 08:53:22 -0700
X-Trace: forums-1-dub 1250697202 10.22.241.152 (19 Aug 2009 08:53:22 -0700)
X-Original-Trace: 19 Aug 2009 08:53:22 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89799
Article PK: 418988

Do you always have three "persons"? Ever any more? Any less?

--
Regards,
Millard[TeamSybase]

"shk" <krishnahari18@gmail.com> wrote in message
news:5f6b8a16-62a2-4036-922a-244394cea219@g1g2000pra.googlegroups.com...
> Hi all,
> I am Using ASA 8.0 and PB 8.0
>
> The table entries are as follows
>
>
> Dept_id persons main
>
> 1 A1 1
>
> 1 A2 0
>
> 1 A3 0
>
>
> By using above table data I want to fill the following table with
> values as follows
>
> Dept_id Person1 Person2 Person3
>
> 1 A1 A2 A3
>
>
> Here Dept_id is already present in the table so I want to update only
> Person1 person2 person3 information
>
> Is there any way to build the query for the same?
>
> The query should be compactable in SQL server also
>
>
>
> Thanks in advance


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-08-19 17:15:19.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <5f6b8a16-62a2-4036-922a-244394cea219@g1g2000pra.googlegroups.com> <4a8c1ff2$4@forums-1-dub>
Subject: Re: SQL query
Lines: 55
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a8c3327$1@forums-1-dub>
Date: 19 Aug 2009 10:15:19 -0700
X-Trace: forums-1-dub 1250702119 10.22.241.152 (19 Aug 2009 10:15:19 -0700)
X-Original-Trace: 19 Aug 2009 10:15:19 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89800
Article PK: 418989

http://en.wikipedia.org/wiki/First_normal_form

--
Report Bugs: http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

"Millard F. Brown III[Team Sybase]" <millard.brown@teamsybase.com> wrote in
message news:4a8c1ff2$4@forums-1-dub...
> Do you always have three "persons"? Ever any more? Any less?
>
> --
> Regards,
> Millard[TeamSybase]
>
> "shk" <krishnahari18@gmail.com> wrote in message
> news:5f6b8a16-62a2-4036-922a-244394cea219@g1g2000pra.googlegroups.com...
>> Hi all,
>> I am Using ASA 8.0 and PB 8.0
>>
>> The table entries are as follows
>>
>>
>> Dept_id persons main
>>
>> 1 A1 1
>>
>> 1 A2 0
>>
>> 1 A3 0
>>
>>
>> By using above table data I want to fill the following table with
>> values as follows
>>
>> Dept_id Person1 Person2 Person3
>>
>> 1 A1 A2 A3
>>
>>
>> Here Dept_id is already present in the table so I want to update only
>> Person1 person2 person3 information
>>
>> Is there any way to build the query for the same?
>>
>> The query should be compactable in SQL server also
>>
>>
>>
>> Thanks in advance
>
>


Millard F. Brown III[Team Sybase] Posted on 2009-08-26 18:17:27.0Z
From: "Millard F. Brown III[Team Sybase]" <millard.brown@teamsybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <5f6b8a16-62a2-4036-922a-244394cea219@g1g2000pra.googlegroups.com> <4a8c1ff2$4@forums-1-dub> <4a8c3327$1@forums-1-dub>
Subject: Re: SQL query
Lines: 65
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3598
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a957c37$1@forums-1-dub>
Date: 26 Aug 2009 11:17:27 -0700
X-Trace: forums-1-dub 1251310647 10.22.241.152 (26 Aug 2009 11:17:27 -0700)
X-Original-Trace: 26 Aug 2009 11:17:27 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89834
Article PK: 419022

??

--
Regards,
Millard[TeamSybase]

"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message
news:4a8c3327$1@forums-1-dub...
> http://en.wikipedia.org/wiki/First_normal_form
>
> --
> Report Bugs: http://case-express.sybase.com/cx/welcome.do
> Product Enhancement Requests:
> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
>
> "Millard F. Brown III[Team Sybase]" <millard.brown@teamsybase.com> wrote
> in message news:4a8c1ff2$4@forums-1-dub...
>> Do you always have three "persons"? Ever any more? Any less?
>>
>> --
>> Regards,
>> Millard[TeamSybase]
>>
>> "shk" <krishnahari18@gmail.com> wrote in message
>> news:5f6b8a16-62a2-4036-922a-244394cea219@g1g2000pra.googlegroups.com...
>>> Hi all,
>>> I am Using ASA 8.0 and PB 8.0
>>>
>>> The table entries are as follows
>>>
>>>
>>> Dept_id persons main
>>>
>>> 1 A1 1
>>>
>>> 1 A2 0
>>>
>>> 1 A3 0
>>>
>>>
>>> By using above table data I want to fill the following table with
>>> values as follows
>>>
>>> Dept_id Person1 Person2 Person3
>>>
>>> 1 A1 A2 A3
>>>
>>>
>>> Here Dept_id is already present in the table so I want to update only
>>> Person1 person2 person3 information
>>>
>>> Is there any way to build the query for the same?
>>>
>>> The query should be compactable in SQL server also
>>>
>>>
>>>
>>> Thanks in advance
>>
>>
>
>


shk Posted on 2009-08-20 11:35:52.0Z
From: shk <krishnahari18@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: SQL query
Date: Thu, 20 Aug 2009 04:35:52 -0700 (PDT)
Organization: http://groups.google.com
Lines: 49
Message-ID: <22f62441-8ba1-494b-8cc7-cace91e3fd6a@y28g2000prd.googlegroups.com>
References: <5f6b8a16-62a2-4036-922a-244394cea219@g1g2000pra.googlegroups.com> <4a8c1ff2$4@forums-1-dub>
NNTP-Posting-Host: 59.96.48.39
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1250768152 20409 127.0.0.1 (20 Aug 2009 11:35:52 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 20 Aug 2009 11:35:52 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: y28g2000prd.googlegroups.com; posting-host=59.96.48.39; posting-account=3bgqjwoAAADrrBLTF1jYtu1n86yiCXyU
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322; FDM),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!news-raspail.gip.net!news.gsl.net!gip.net!aotearoa.belnet.be!news.belnet.be!goblin1!goblin.stu.neva.ru!postnews.google.com!y28g2000prd.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89805
Article PK: 418993

Here persons are noty constant.

On Aug 19, 8:53 pm, "Millard F. Brown III[Team Sybase]"

<millard.br...@teamsybase.com> wrote:
> Do you always have three "persons"? Ever any more? Any less?
>
> --
> Regards,
> Millard[TeamSybase]
>
> "shk" <krishnahar...@gmail.com> wrote in message
>
> news:5f6b8a16-62a2-4036-922a-244394cea219@g1g2000pra.googlegroups.com...
>
>
>
> > Hi all,
> > I am Using ASA 8.0 and PB 8.0
>
> > The table entries are as follows
>
> > Dept_id persons  main
>
> > 1          A1        1
>
> > 1          A2        0
>
> > 1          A3        0
>
> > By using above table data I want to fill the following table with
> > values as follows
>
> > Dept_id             Person1             Person2             Person3
>
> > 1                      A1                    A2                    A3
>
> > Here Dept_id is already present in the table so I want to update only
> > Person1 person2 person3 information
>
> > Is there any way to build the query for the same?
>
> > The query should be compactable in SQL server also
>
> > Thanks in advance- Hide quoted text -
>
> - Show quoted text -