Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

optimising the update query

Status
Not open for further replies.
muktad

muktad

Programmer
Jul 7, 2009
1
US
please help me in optimizing this query ..
UPDATE DealReq_DealReqDtl_BB_T1 from

(select CASE WHEN (T1.BGSTOR='')
AND (T1.BSSTOR='')
THEN
'01*'
Else
''
END ||
CASE
WHEN (T1.NTUPCN='')
THEN
'04*'
ELSE
''
END from DealReq_DealReqDtl_BB_T1 T1 ) as E(E1)
SET Error_Code = E1
 
Status
Not open for further replies.

Similar threads

micjohnson382
  • Locked
  • Question
Teradat 13.10. Need to split the string with a delimiter.
Replies
0
Views
154
micjohnson382
micjohnson382
tmcrouse
  • Locked
  • Question
Tera SQL Update help
Replies
2
Views
131
tmcrouse
tmcrouse
peac3
  • Locked
  • Question
Dynamic Join help please... tough query
Replies
0
Views
107
peac3
peac3
dprayner
  • Locked
  • Question
Teradata SQL Assistant query - Condition in WHERE statement
Replies
1
Views
96
glenntb
glenntb
btrini
  • Locked
  • Question
Fastload logon shows as invalid but I can log on to Teradata SQL Assistant with the same credentials
Replies
1
Views
126
SamBones
SamBones

Part and Inventory Search

Sponsor

Back
Top