Suresh, thanks for the reply. Under logins, the login name is DomainName\UserName with Windows Authentication.

Under Credentials, the Identity is DomainName\UserName and the passwords have been entered (being an...

Thanks, GM, I think a light bulb went on...

Thanks for the links, I'll pursue both.

Ok, so setting this:

If @AuditYear = 1 Set @AuditQuesTypeParameter = '1 And 4'

Else

Set @AuditQuesTypeParameter = '13 And 16'

and expecting this:

And tblAuditQuesLkup.AuditQuesType BETWEEN @AuditQuesTypeParameter

to work...

Ok, got this. Each variable has to be converted.

convert(decimal, Variable)/convert(decimal, (DateDiff("d",DateVar,DateVar)))

Hey everyone,

This topic seems to be the closest to what I'm looking for. I've got a calculation that needs to return a decimal, however, I get the same error...

Hey, y'all, when I click on the video screen with 'Play' on it, it justs redirects me back to the main article. Is there something I'm missing? Thanks.

Ignacio,

My developer has indicated that this issue is very similar, but that he cannot run it locally as indicated above. He'd like to pursue another tangent and didn't want...

Definitely hope someone has come to a conclusion on this issue, a fellow developer has encountered this exact same problem. Looking forward to a resolution. Thanks!