0 - 6 of 6 tags for sql query

Hi Team,

 

I have data like this.

 

Recommendation Identifier   Audience Identifier  Directory Service Identifier  Start Date    End Date   Surrogate Key Value

-------------------------  --------------------  ----------------------------  ----------  ----------  --------------------

Hi
    How can i schedule Teradata SQL queries. I need to run particular set of queries at a scheduled time. I am not allowed to use Teradata Query Scheduler. Apart from that is there anyway we can schedule Teradata SQL Query? Is it possible to do it in IBM Tivoli Workload Scheduler? Please guide me on this. Thanks.
 
--Arun

Hello Folks,
We have to remove duplicates from our teradata table. If 3 similar records are there then 2 duplicates should be deleted and 1 actual record should be present in the table.
Could any one help me on this. 
Thanks,

Hi Gurus,
I have a rule table which look slike
Mark_SL#      STRT_VAL       END_VAL        DESCR
1                     0                     35                  FAIL
2                     36                   60                  SECOND CLASS
3                     61                    70                 FIRST CLASS 

One of ouy node is down and we need to figure out on which operatin system is our teradata box installed . 

Any pointers would be appreciated .

DBA is out for couple of days :)

 

 

 

My input data is as follows:

 

Product

category

value

1

Entry

2400

1

Secondry

1200

1

Premium

2500

1

Entry

1200

2

Secondry