October 7, 2008 04:43pm pdt

1. chapmandew 2,223,259
2. angelIII 1,997,731
3. mark_wills 631,410
4. aneeshatti... 607,479
5. ScottPletc... 456,851
6. EugeneZ 366,402
7. ee_rlee 353,240
8. BrandonG... 340,310
9. acperkins 335,429
10. dtodd 304,879
11. momi_sa... 194,132
12. cs97jjm3 188,038
13. matthews... 169,999
14. appari 166,334
15. nmcdermaid 165,158
16. rickchild 165,060
17. brejk 163,902
18. dqmq 156,258
19. Thomasian 153,702
20. dportas 141,305
21. ptjcb 140,761
22. dbaSQL 139,392
23. bhess1 134,605
24. mwvisa1 128,997
25. MohammedU 125,975

1. angelIII 10,954,144
2. aneeshatti... 4,665,358
3. acperkins 4,323,889
4. ScottPletc... 4,270,903
5. arbert 2,245,195
6. chapmandew 2,223,259
7. Lowfatsp... 2,174,384
8. EugeneZ 1,642,564
9. imran_fast 1,482,261
10. rafrancisco 1,460,132
11. Hilaire 1,221,775
12. nmcdermaid 1,149,742
13. Nightman 1,146,504
14. Mr_Peer... 1,087,815
15. ptjcb 1,074,620
16. bhess1 1,071,597
17. dtodd 891,222
18. adathelad 777,208
19. Sirees 776,352
20. appari 753,571
21. BriCrowe 722,959
22. matthews... 692,331
23. amit_g 683,229
24. mark_wills 631,410
25. ShogunW... 619,598

03.28.2008 at 04:40PM PDT, ID: 23278801

	[x] Attachment Details

Converting Access SQL to SQL server (IIF statement used)

Asked by Misledman in MS SQL Server, .Net Editors & IDEs

This query works great in Access: SELECT dbo_Sales.LPS, dbo_Sales.RM, dbo_Sales.OrderNumber, dbo_Sales.CustomerNumber, dbo_Sales.CustomerName, dbo_Sales.Program, dbo_Sales.QtyAmt, IIf([Program]='Pinnacle Promotion',[QtyAmt],0) AS Pinnacle
FROM dbo_Sales;
Surely I can do the same in SQL Server.Start Free Trial

Keywords: Converting Access SQL to SQL server…

	Title
1	IIF statemnt in SQL Server
2	iif function
3	converting access sql to t-sql (iif an…
4	Having difficulties with a Calculated fiel…
5	Access IIF & AND query
6	Distinct COUNT inside IIf Statement

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Converting Access SQL to SQL server (IIF statement used)

Asked by Misledman in MS SQL Server, .Net Editors & IDEs

About this solution