|
|
Show all posts by user
You are welcome to ask questions or to comment anything around the formatter and the website. You can also give positive feedback :-)
Page 1 of 1 Pages: 1
Results 1 - 6 of 6
I will like to be able to format my SQL CASE Statements like so
CFE_Contin_Readonly = CASE WHEN(r.Contingence = 1 OR s.Cat = 1) THEN 0 ELSE 1 END,
Or so
CouleurBase = CASE WHEN r.OnlyPCC = 1 THEN 'Orange'
WHEN s.Cat = 1 THEN 'Rose'
WHEN r.Contingence = 0 THEN 'Jaune'
WHEN r
by TazQuebec
- Suggestions, Questions, Comments
When I format my SQL string with the June version here the result
SELECT
IIF(TbTransit.FkCategory = 2,
IIF( IN('CA' ,
'US' ,
'MX'), 5, 6), 7) AS Ligne,
SUM(TbTransit.BO_Qty * TbTransit.) AS
FROM TbTransit
by TazQuebec
- Suggestions, Questions, Comments
What is "current formatting"?
Here what I got now.
SELECT TbChangeRequest.RequestedDate,
SUM(
IIF( <> 2 AND RequestedDate = DATE()-1, 1, 0)) AS ,
SUM(
IIF( = 2 AND RequestedDate = DATE()-1, 1, 0)) AS ,
SUM(
IIF( <> 2 AND RequestedDate = DATE(), 1, 0)) AS ,
SUM(
IIF( = 4, 1, 0)) AS ,
SUM
by TazQuebec
- Suggestions, Questions, Comments
How do I customize the application to format the following code.
SELECT TbChangeRequest.RequestedDate, Sum(IIf(<>2 And RequestedDate=Date()-1,1,0)) AS , Sum(IIf(=2 And RequestedDate=Date()-1,1,0)) AS , Sum(IIf(<>2 And RequestedDate=Date(),1,0)) AS , Sum(IIf(=4,1,0)) AS , Sum(IIf(=1,1,0)) AS , Sum(IIf(=3,1,0)) AS
FROM TbChangeRequest
GROUP BY TbChangeRequest.RequestedDate;
H
by TazQuebec
- Suggestions, Questions, Comments
Is there an option to remove unnecessary bracket?
The following code
SELECT tbvilles.VilleID, tbvilles.Ville
FROM tbvilles
LEFT JOIN tb_lbxown_villessel
ON tbvilles.VilleID = tb_lbxown_villessel.VilleID
WHERE (((EXISTS(SELECT tb_dw_owner.villeid
FROM tb_dw_owner
WHERE tb_dw_owner.villeid = tbvilles.villei
by TazQuebec
- Suggestions, Questions, Comments
|
] Need help in formating