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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SELECT SUBQUERY - using % wildcard with IN CLAUSE
Hi, I'm trying to write the following DELETE FROM TABLEA WHERE TABLEA.ID IN (SELECT DISTINCT(ID)||'%' FROM INVALID_IDS) The idea is that table INVALID_IDS could have an entry of '12' and so all entries starting 12xxx would be deleted. INVALID_IDS could also contain ABC so all entries...- JMB70
- Thread
- Replies: 3
- Forum: Oracle: All versions
-
Add in a dialog confirmation box to Save button in Office
Hi, I have a document management system that is the desired location for saving documents. The intention is that I will move the Save button to a less prominent location than the new applications save button. I would like a dialogue box to appear whenever the standard Save button is used that...- JMB70
- Thread
- Replies: 10
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Cursor Error Trapping.
Hi, I'm new to this place (and to sql server), I'm having trouble and a friend reccomended I ask here... hope someone can help? I have an insert statement that is trawling through thousands of records from the source table. When the cursor finds a bad record from the source(e.g. a null...- JMB70
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
