Advertisement
hecrus

Metric 1

Oct 24th, 2020
2,125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.30 KB | None | 0 0
  1. CREATE PROCEDURE [dbo].[mt_tst-metric1_metric]
  2. @username nvarchar(128),
  3.  @itemID nvarchar(64)
  4. AS
  5. BEGIN
  6.     select id hide_id, name, fio, age, iif(vip=1, '<i class="fa fa-dove"></i>', '') VIP,
  7.         (select count(*) from tst_orders where customerID = cust.id ) orders
  8.    
  9.     from tst_customers cust
  10. end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement