Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO sovtreposrt (comment, cout, sort) values
- ('Результат', 'Количество','2')
- from dblink('host=**** port=***user=***password=***dbname=Cx_Work',
- ' SELECT 'Отменено в рамках проверки федерального закона' as "Результаты", count("State") as "Количество"' t (comment VARCHAR(50), count VARCHAR(50), sort int4)
- WHERE "StartTime" >= current_date
- and "IDCampaign" in (5030490429,5107806228,5279099748,5100578818,5107806231,5279606886)
- and "State" = 3), "S_CampaignsCalls"
Add Comment
Please, Sign In to add comment