Solved

With myCTE as

Posted on 2010-09-21
5
372 Views
Last Modified: 2012-05-10
Hello,
when I use the  --- With myCTE as --- on my local SQL machine, it works,
when I connect to the network Domain  server, I get an error,
Incorrect syntax near the keyword 'With'.

Any ideas?
thanks
0
Comment
Question by:W.E.B
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 50 total points
ID: 33725247
is that othe server a sql 2005 + ?
with sql 2000 or lower, it won't work ...
0
 

Author Comment

by:W.E.B
ID: 33725276
Hello,
Good point,.
Mine 2005
Domain, 2000

Any way around it?

tx
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 33725298
no (unless you upgrade the domain server to sql 2005 or higher
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 33725301
or change the query to solve without the CTE
0
 

Author Closing Comment

by:W.E.B
ID: 33725353
Thanks
0

Featured Post

Why You Need a DevOps Toolchain

IT needs to deliver services with more agility and velocity. IT must roll out application features and innovations faster to keep up with customer demands, which is where a DevOps toolchain steps in. View the infographic to see why you need a DevOps toolchain.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question