Guest User

Untitled

a guest
Jun 24th, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. CREATE TABLE ValueCodes
  2. (
  3. Value INTEGER NOT NULL PRIMARY KEY,
  4. Meaning VARCHAR(32) NOT NULL UNIQUE
  5. );
  6.  
  7. CREATE TABLE Results
  8. (
  9. TestID ...,
  10. TestCode ...,
  11. Value INTEGER NOT NULL FOREIGN KEY REFERENCES ValueCodes
  12. );
  13.  
  14. ORDER BY IsNumeric(Results.Value) DESC,
  15. CASE WHEN IsNumeric(Results.Value) = 1 THEN Len(Results.Value) ELSE 99 END,
  16. Results.Value
Add Comment
Please, Sign In to add comment