Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- ppl.[Fio]
- ,ppl.[Email]
- FROM UserInfo AS ppl
- LEFT JOIN AccountDP AS os ON ppl.[ID] = os.[UserID]
- WHERE (1=1) AND
- if ("переменная" = 1) {
- ppl.adp1=1 AND ppl.dpflag = false
- --Выполняется условие 1
- }
- else
- if("переменная" = 2) {
- ppl.fdp10=10 AND ppl.dpflag = false
- --Выполняется условие 2
- }
- else
- if ("переменная" = 3) {
- ppl.idp300=1000 AND ppl.dpflag = true
- --Выполняется условие 3
- }
- SELECT
- CASE "переменная"
- WHEN 1 THEN 1
- WHEN 2 THEN 10
- WHEN 3 THEN 1000
- END AS adp1,
- CASE "переменная"
- WHEN 1 THEN false
- WHEN 2 THEN false
- WHEN 3 THEN true
- END AS dpflag ,
- ppl.[Fio],
- ppl.[Email]
- FROM UserInfo AS ppl
- LEFT JOIN AccountDP AS os ON ppl.[ID] = os.[UserID]
- IF условие
- BEGIN
- запрос
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement