Код

ТекстЗапроса = "
	|select k.karta_num,
	|	ltrim(rtrim(k.fam)) + ' ' + ltrim(rtrim(k.im)) + ' ' + ltrim(rtrim(k.ot)) as patient,
	|	k.birthdate,
	|	p.pol_ser,p.pol_num,p.begin_date,p.summa,p.permit,p.extrasumma,
	|	ISNULL(sum(serve.price),0) as sumprice,
	|	ISNULL(sum(serve.price),0)-(p.summa+p.extrasumma) as credit,
	|from serve
	|	left outer join talon on talon.talon_id=serve.talon_id
	|	left outer join karta k on k.karta_id=talon.karta_id
	|	left outer join policy p on talon.policy_id=p.policy_id
	|where p.policytype_id=5
	|	and p.begin_date>='20080101'
	|	and YEAR(serve.close_date)>1900
	|	and serve.close_date<='20111231'
	|	and credit>0
	|group by k.karta_num,
	|	ltrim(rtrim(k.fam)) + ' ' + ltrim(rtrim(k.im)) + ' ' + ltrim(rtrim(k.ot)),
	|	k.birthdate,
	|	p.pol_ser,p.pol_num,p.begin_date,p.summa,p.permit,p.extrasumma
	|order by k.karta_num, by credit desc"
	;