上海受较强降水云团影响预计在未来的6个小时内将会在本市出现一个小时最大50毫米以上的短时强降雨,暴雨蓝色预警信号也更新为暴雨黄色预警信号,居民在出行的时候请加强防范强降雨所带来的城市积涝。上海中心气象台2
I would really like to create a view. I know you can\'t use temp tables in MSSQL2005 views.Without rewriting the sql, is there anything obvious I\'ve missed?