SELECT (1=1);

seriously, SQL Server 2000 says this is not a valid query, what the fuck?

6/24/2007 4:05:17 PM

what on earth are you trying to ask the server?

6/25/2007 1:04:21 PM

i think he is looking for the meaning of the universe

6/25/2007 1:13:24 PM

I second the "what the hell are you trying to do" question

6/25/2007 1:46:12 PM

I third the "what the hell are you trying to do" question

6/25/2007 1:53:23 PM

i fourth it - what use would that ever have?

6/25/2007 2:35:38 PM

http://thedailywtf.com/Contact.aspx

6/25/2007 2:39:26 PM

What data are you trying to select (besides the obvious) and from which table(s)?

6/25/2007 4:46:37 PM

wow

6/25/2007 6:36:21 PM

http://sqlzoo.net/ ftw

6/25/2007 6:46:43 PM

well, I was trying to run a query on a subquery which is perfectly valid, and it kept bitching at me around the area of the = sign, so I tried reducing it down to the area where it was complaining and making sure I was using the SQL right, and I reduced it down to that. crazy shit, aint it? I figured out another way to sort of accomplish my task.

6/25/2007 9:09:32 PM

your task sucks

6/26/2007 9:34:38 AM

good to know you found another way of doing it. hopefully it was the correct way.

what was the original query?

6/26/2007 1:51:20 PM

Original query was something along the lines of:

SELECT
   NOT EXISTS ('false')
FROM
   (SELECT 
      (s.val = p.val) 
   FROM 
      somelongtable s,
      anotherlongtable p
   WHERE 
      s.id=p.id)

6/26/2007 6:10:50 PM

righto

6/27/2007 4:43:37 PM

Delete that code. It's wrong. That's cool, though, because we're here to help. We're not here to judge.

Ask yourself, what is the goal of my query? What is the logical question i want to ask the database? It helps if you can phrase this along the lines of "Please give me all of the ______s, where they have a _______ in the _______ table"

6/27/2007 5:28:43 PM