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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Better way to combine columns using UNION
Thanks folks. Just needed a confirmation of my suspicions. -
Better way to combine columns using UNION
Ok, so I purposefully omitted the entire block of code because the goal was really to find an alternative to using 3 separate select statements (which means 3 separate passes on the table) with the 2 UNIONS. Here's the code in its entirety. SELECT QUEUE FROM ( SELECT QUEUE FROM... -
Better way to combine columns using UNION
Wondering if someone has a better alternative to the following code. The goal is to combine the record data for 3 columns into a single one. SELECT QUEUE FROM ( SELECT QUEUE AS QUEUE FROM MYSCHEMA.MYTABLE QUEUE1 UNION SELECT SUPERVISOR AS QUEUE FROM MYSCHEMA.MYTABLE QUEUE2... -
SSL Redirect withougt Certificate Error Message
We recently changed our domain name and bought a new SSL certificate. We've been unable to find a way to redirect users pointing to our old secure address to the new one without having the browser message popup with a warning about the domain mismatch. If they click "Ok" to proceed, the url...- bsterner
- Thread
- Replies: 1
- Forum: Linux (server)
