Web Technology Kitchen

We provide the general public with website and other technology services. We'll create new great websites, maintain them, do security for them, and we also do automation and any other workflow you need. Drupal, Python, C#, Unity, automation, VR/AR, gaming, mobile, responsive design, please be in touch for a consultation at jbarnett@barnettech.com. Feel free to peruse our blog postings below.

insert into temporary table in sql server


DECLARE @result1 TABLE(subtype VARCHAR(5), total INT)

INSERT INTO @result1(subtype, total)
select DISTINCT top 2 t.subtype, t.total
from [test] t, [person] p
where (t.[record] = 'fc2765f2-ca90-48c2-a705-d2526c92d56d')
and p.[id] = t.[record]
and (t.[type] = 'SATII')
/*and (t.[rank_confirmed_subtype] = 1)*/
and (confirmed != 0 or confirmed IS NULL)
order by t.[total] desc

select total from @result1