The problem appears to be that you are trying to put the linked server fields inside the CTE. Try the following:

;WITH CTE AS (

SELECT

lastname

,firstname

, email

,authstatus

,CASE WHEN ISNUMERIC(RIGHT(emplid,len(emplid)-1))=1...

Getting there but not quite there. Still need sample data for the tables as a series of INSERT INTO statements and expected results based on the sample data and...

Actually, no....

Any clues? No. I am still waiting for the information I requested in my last post.

I have to agree, stop complaining about the ball and play the game you are paid quite well to play.

I don't have a copy of the Laws of the Game...

magarity kerns (6/11/2010)

---

No comment!!

PS - I...

Sounds like the visual designer may not support the pivot/unpivot command and isn't handling it correctly when you attempt to open the view.

bteraberry (6/11/2010)

---

Lynn Pettis (6/11/2010)

---

Another option:

DECLARE @filterStart DATETIME

DECLARE @filterEnd DATETIME

SET @filterStart = '10/06/2010'

SET @filterEnd = '10/07/2010'

SELECT ...

WHERE

DueDate BETWEEN @filterStart AND @filterEnd...

Lynn Pettis (6/11/2010)

---

Anybody out there know much about this individual, scott.pletcher?

I know we have several MVP's here on SSC, but most of you don't advertise it, and perhaps its just...

Trey Staker (6/11/2010)

---

Lynn Pettis (6/11/2010)

---

Trey Staker (6/11/2010)

---

Ouch. I'm going to use this thread as an example. I've been dealing with a 3rd party application. They...

magarity kerns (6/11/2010)

---

The foul language generator is definitely the most humorous. The best bad design I've ever seen was designed by a sales manager and had rows for dollar...

Nope. Any error messages?

Another option:

DECLARE @filterStart DATETIME

DECLARE @filterEnd DATETIME

SET @filterStart = '10/06/2010'

SET @filterEnd = '10/07/2010'

SELECT ...

WHERE

DueDate BETWEEN @filterStart AND @filterEnd

...

Trey Staker (6/11/2010)

---

Ouch. I'm going to use this thread as an example. I've been dealing with a 3rd party application. They use SQL Server as...

Anybody out there know much about this individual, scott.pletcher?

I know we have several MVP's here on SSC, but most of you don't advertise it, and perhaps its just me but...