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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can any one help me to make this query to run using teradata assistant

Status
Not open for further replies.
naren044

naren044

Programmer
May 1, 2008
7
IN
Hi all

In this query the syntax is correct but I dont no why its not running...
Can you check it out please?

Query:
SELECT CASE
WHEN party_x_source.partytypeid IN
(SELECT party_x_source.datasourceid
FROM party_x_source)
THEN 1
ELSE 0
END
FROM party_x_source;

Thank you
Regards,
Narendra
 
Status
Not open for further replies.

Similar threads

RJKumar
  • Locked
  • Question
How to build Dimensional model for commission received and return
Replies
1
Views
297
johnherman
johnherman
Ulianna
  • Locked
  • Question
Loading files from different sources into one database table
Replies
1
Views
129
johnherman
johnherman
AvgMoJoe
  • Locked
  • Question
Help designing star schema
Replies
1
Views
209
johnherman
johnherman
ye9out
  • Locked
  • Question
How to choose solution 1
Replies
5
Views
273
blom0344
blom0344
yashgoley
  • Locked
  • Question
how to develop decision support system (DSS) with open close principle
Replies
3
Views
248
blom0344
blom0344

Part and Inventory Search

Sponsor

Back
Top