- 1
- 2
- 3
- 4
- 5
- 6
- 7
update #tmpTours1 set pricelink = ('<a target="_blank" title="Прайс-лист на ближайшие заезды" href="../pricelist/Complex.aspx?country=' + ltrim(str(cnkey)) + '&tour=' + ltrim(str(tourkey)) + '&dateFrom=' + dbo.mwFirstTourDate(tlkey) + '">' + ltrim(str(tourprice)) + ' ' + tourrate + '</a>')
set @sql = N'select * from #tmpTours1 where tourprice is not null and quota <> case ' + ltrim(str(@quotaYes)) + ' when -1 then -10 else 0 end '
if len(@sort) > 0
set @sql = @sql + ' order by ' + @sort
print @sql
exec sp_executesql @sql
wvxvw 15.12.2014 22:03 # +3
bormand 15.12.2014 22:06 # 0
3.14159265 16.12.2014 02:00 # +2
bormand 16.12.2014 06:48 # +1
inkanus-gray 16.12.2014 09:40 # +1
bormand 16.12.2014 10:31 # 0
Lokich 19.12.2014 17:41 # +1
guest 16.12.2014 00:55 # 0