Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE [dbo].[mt_tst-metric1_metric]
- @username nvarchar(128),
- @itemID nvarchar(64)
- AS
- BEGIN
- select id hide_id, name, fio, age, iif(vip=1, '<i class="fa fa-dove"></i>', '') VIP,
- (select count(*) from tst_orders where customerID = cust.id ) orders
- from tst_customers cust
- end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement