Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Convert IIF with switch statement to Case
I have a column in a query that calculates regsales base on some Id's and dont think my CASE statement is correct. SUM (LOTOSMIS_ACC_TYPE.sing_ind * LOTOSMIS_RET_DAILY.grs_amn * iif( gm_cd in (1105, 2123, 2124, 2150, 2152, 2191, 2192, 5143, 5145, 5146, 5245, 5253 )...- Bomac8
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
Convert Ms Access IIF to SQL Server Version
Thanks really helpful.- Bomac8
- Post #10
- Forum: Microsoft SQL Server: Programming
-
Convert Ms Access IIF to SQL Server Version
Sure. I have an access application tht I m trying to convert to SQL server. I have to get the data from an Oracle database accessed thru a link server. I bring some of the data in to two temp tables and I run this query to insert the data into an SQL server table. The table BEGIN TRANSACTION...- Bomac8
- Post #8
- Forum: Microsoft SQL Server: Programming
-
Convert Ms Access IIF to SQL Server Version
THanks for all the help.The statement "IIf(([LOTOSMIS_RET_DAILY]![GM_CD]=6150 Or...- Bomac8
- Post #6
- Forum: Microsoft SQL Server: Programming
-
Convert Ms Access IIF to SQL Server Version
I am in the process of converting an msaccess application to SQL Server and I am having trouble converting this code to a case statement IIf(([LOTOSMIS_RET_DAILY]![GM_CD]=6150 Or...- Bomac8
- Thread
- Replies: 9
- Forum: Microsoft SQL Server: Programming
