-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Rishi61
Message 1 in Discussion
Hi Guys, Below is the problem description. This is very urgent as I am sitting on
the client side. SOURCE TABLE S
------------
CLIENT NO TYPE CAT
--------- ---- ----
1 A 1
1 B 2
1 B 3
2 A 2
2 B 4
3 D 1
3 B 5 I HAVE TO WRITE A QUERY WHICH WOULD RESULT
IN THE FOLLOWING TARGET TABLE T
------------
CLIENT NO TYPE FLAG1 FLAG2 FLAG3 FLAG4 FLAG5
--------- ----- ----- ----- ------ -----
--------
1 A 1 0 0 0
0 1 B 0 1 1
0 0
2 A 0 1 0 0
0 2 B 0 0 0
1 0
3 D 1 0 0 0
0 3 B 0 0 0
0 1 I HAVE TO SET THE FLAG IN TARGET TABLE 'T' DEPENDS ON THE VALUE
OF S.CAT
FOR EXAMPLE IF CAT = 2 THEN SET FLAG2 = 1 1.FLAG FIELD CANNOT BE NULL - EITHER 0
OR 1 2.INSERT A ROW IN THE TARGET TABLE FOR EACH CLIENT HAVING HAVING DIFFERENT HAS
TYPE AND UPDATE FLAG IF THE HAS TYPE IS SAME.
3.IF CLIENT RECORD IS NOT IN THE TARGET TABLE THEN 'INSERT' OTHERWISE UPDATE THE
APPROPRIATE FLAG. Thanks and Regards, Rishi Girdhar
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
