Re: Manipulate data use TSQL
From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 02/26/04
- Next message: Andrew J. Kelly: "Re: Proc Validation tool"
- Previous message: Lee Schipper: "Retrieve error text from extended stored proc"
- In reply to: culam: "Manipulate data use TSQL"
- Next in thread: Andrew J. Kelly: "Re: Manipulate data use TSQL"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 26 Feb 2004 06:52:40 +0530
I guess the logic as: YES is preceded over NO
Try:
select acct, max(aff) aff, max(auto_) auto_, max(signa) signa
from aals
group by acct
-- Vishal Parkar vgparkar@yahoo.co.in
- Next message: Andrew J. Kelly: "Re: Proc Validation tool"
- Previous message: Lee Schipper: "Retrieve error text from extended stored proc"
- In reply to: culam: "Manipulate data use TSQL"
- Next in thread: Andrew J. Kelly: "Re: Manipulate data use TSQL"
- Messages sorted by: [ date ] [ thread ]
