Solved

With myCTE as

Posted on 2010-09-21
5
366 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
  • 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
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…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

821 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