Hello,

I am trying to create a view in SQL Server 2008. I am fairly new to SQL, so I am hoping someone with more experience will see what is wrong with my WHERE statement.

I can run this query just fine without the WHERE clause, but it will not work with the WHERE clause.

SELECT     PROJECTID, WORKORDERID, PROJECT2PROJTEMPLATE, PROJECTWORKORDER2WORKORDER, DLSPA_PROJECT_NAME, PROVISIONSTATUS, EWO,

FROM         OPENQUERY(PRNLDB,

                      'SELECT CRAMER.PROJECT.PROJECTID, CRAMER.WORKORDER.WORKORDERID, CRAMER.PROJECT.PROJECT2PROJTEMPLATE, CRAMER.PROJECTWORKORDER.PROJECTWORKORDER2WORKORDER, CRAMER.PROJECT.NAME AS DLSPA_PROJECT_NAME, CRAMER.PROVISIONSTATUS.NAME AS PROVISIONSTATUS, CRAMER.PRO_EXT_DSL.EWO, CRAMER.WORKORDER.NAME AS WORKORDER, CRAMER.PROJECT.CREATEDDATE , CRAMER.PROJECT.LASTMODIFIEDDATE , CRAMER.PROJECT.CREATEDBY AS PROJECT_CREATEDBY, CRAMER.PROJECT.LASTMODIFIEDBY AS PROJECT_LASTMODIFIEDBY, CRAMER.PROJECT.PLANNEDFINISHDATE

FROM (((CRAMER.PROJECT INNER JOIN CRAMER.PROVISIONSTATUS ON CRAMER.PROJECT.PROJECT2PROVISIONSTATUS = CRAMER.PROVISIONSTATUS.PROVISIONSTATUSID) INNER JOIN CRAMER.PRO_EXT_DSL ON CRAMER.PROJECT.PROJECTID = CRAMER.PRO_EXT_DSL.PROJECTID) INNER JOIN CRAMER.PROJECTWORKORDER ON CRAMER.PROJECT.PROJECTID = CRAMER.PROJECTWORKORDER.PROJECTWORKORDER2PROJECT) INNER JOIN CRAMER.WORKORDER ON CRAMER.PROJECTWORKORDER.PROJECTWORKORDER2WORKORDER = CRAMER.WORKORDER.WORKORDERID

WHERE (((CRAMER.PROJECT.NAME) Like ReassignCP%) AND ((CRAMER.PROVISIONSTATUS.NAME)=Planned/Planifi) AND ((CRAMER.PRO_EXT_DSL.EWO)=Yes/Oui) AND ((CRAMER.WORKORDER.NAME) Like DSLPA%/PI/% Or (CRAMER.WORKORDER.NAME) Like DSLPA%/PO/%) AND ((CRAMER.PROVISIONSTATUS.PROVISIONSTATUSID)=1900000110))

')                  AS derivedtbl_1

Thanks in Advance for your help!

Since you're attempting an OpenQuery, you need to double single quote inside the query.

Does your query work correctly when you run it standalone on that server?

Great that Worked!!!! Yes, it does work on the Host server.  Thanks!!