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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How do I create PK's off another tables data?
I have two tables. My forms are set up so I have one form embedded into another each form using a table. tables: SYSTEM - contains general system data DETAIL - contains individual discrepancies by date forms: SYSTEMF - contains SYSTEM table with DETAILF form embedded DETAILF - contains DETAIL...- ragepro
- Thread
- Replies: 3
- Forum: Microsoft: Access Tables and Relationships
-
SQL Syntax in ASP
I am having some trouble applying extended queries in an ASP environment. I'd like to use the following: SELECT Name, alphaOrder = CASE WHEN (LEFT(Name,2) LIKE '[a-d]') THEN 1 WHEN (LEFT(Name,2) LIKE '[b-c]') THEN 2 ELSE 0 END FROM table ORDER BY AlphaOrder, Name I've tried...- ragepro
- Thread
- Replies: 3
- Forum: Microsoft: ASP (Active Server Pages)
-
SQL output problem
Hello, I'm trying to output my database by column 'CompanyName' in alphabetical order. Too simple. Now, here's the kicker, I want to start not from A, but from a predetermined letter, say L and have it loop back around to K. Is this possible with just an SQL query? Or do I have to write a...- ragepro
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
