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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
UPDATE multiple items in JOIN
Can someone tell me why this is allowed: update (select su.sec_usr_id,su.is_enbl_ind,t.asn_usr_id,t.stat_typ_cd,su.lst_updt_dt from sec_usr su, tsk t where su.is_enbl_ind = 0 and su.sec_usr_id = t.asn_usr_id and t.stat_typ_cd = 'OPEN')u set u.stat_typ_cd = 'CLOSED'; but this is not...- Shelby500
- Thread
- Replies: 2
- Forum: Oracle: All versions
-
UPDATE that uses DISTINCT
I have been working on an UPDATE query that will update one column based on results from a join select query. [highlight #FCE94F]I am looking to update the column "stat_typ_cd='OPEN'" to "stat_typ_cd='CLOSED'".[/highlight] At the bottom of the page is the SELECT query that pulls the data that...- Shelby500
- Thread
- Replies: 4
- Forum: Oracle: All versions
-
Format Date for SQL query
Below is my code. I need to create some variables that I can put in my SQL query. They need to increment by 15 minutes each time the script runs....therefore pulling data every 15 minutes. Below is what I have so far. I'm just not sure how to do the incrementing each time the script runs? Dim... -
Allow for more or less data
My code is below. The amount of data in my query changes and I'm having a hard time make it so the code can allow for the changes in the data. Right now it is all hard coded. The code is very simple and I'm learning slowly. Dim strCon Dim SQLArray theDate = date() newDate = DateAdd("D", -1...
