code_junkie

Convert NVARCHAR to INT skipping non convertibles

Nov 12th, 2011
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. GROUP BY age / 10
  2.  
  3. CREATE TABLE #temp (age NVARCHAR(20))
  4.  
  5. INSERT INTO #temp
  6. SELECT '22'
  7. UNION
  8. SELECT '24'
  9. UNION
  10. SELECT '20.10.1984'
  11. UNION
  12. SELECT '50'
  13.  
  14. SELECT age/10, COUNT(*)
  15. FROM #temp
  16. WHERE ISNUMERIC(age) = 1
  17. GROUP BY age/10
  18.  
  19. DROP TABLE #temp
Add Comment
Please, Sign In to add comment