Search results

you are correct .I have changed the Code the other way round and yes thats exactly how I debugged and was still getting the Divide by zero error. This issue has now been resolved. thanks very much

Thanks yes you are correct, it is meant to be the other way round .I have now corrected in my code

I have converted the following access IIF statements to SQL Server TSQL and getting DIVIDE by Zero error . Can anyone help please Access ------([EndDateFor]-(IIf([EndDateLastBase] Is Null,[EndDateBase], [EndDateLastBase])))/(IIf([EndDateLastBase] Is...

fantastic, this works perfect and infact another member gave a different version using Coalesce . they both work perfect .really appreciate the prompt help of people one this Forum.

this is the original access query and ive replaced the IIFs with Case statements SQL Server . the problem is am getting invalid column names because of the AS aliases .not sure how in access the queries run ok without issues . I just need a work around to resolve the issue.Thanks to anyone...

yes ive inherited an access database and I need to rewrite all the queries

I think the reason for the error is that the Case statement is using aliases defined just above it and that doesnt exist yet .

Hello I am trying to create a view and getting Invalid column name error when executing this Select statement CREATE VIEW [dbo].[test] AS SELECT ProjectReturn_Detail.DepartmentID, ProjectReturn_Detail.QTRID, ProjectReturn_Detail.ProjectID, ProjectReturn_Detail.ProjReturnID, Min(CASE...

Can someone please help. need help with translating this IIF's statement to SQL Server CASE Statement . I dont what am meant to do to the minus part of the statement I understand the part that reads CASE WHEN latestbaselineDate is NULL Then OriginalBaselineDate ELSE LatesbaselineDate END...