do you have to put quotes round your dates?

instead of

where EXIT_DT >= " & startFilterDate & " and

you do

where EXIT_DT >= ' " & startFilterDate & " ' and

the CTE declaration must be preceeded with a ';' if there is another Statement above it.

if there isn't a Statement above it, it isn't required for your cte to run.

probably...

A general rule (although not always true) is that if you wrap the column you are searching in a function then it is not SARGABLE, instead you need to wrap...

talking of being SARGable, i was reading this article:

http://en.wikipedia.org/wiki/Sargable

and didn't quite understand this line

The typical thing that will make a sql query non-sargable is to include a function in left...

i didn't know the answer, so i picked 5 [almost] at random and got it right :w00t:

i chose that #1 returned a row with NULL so thought that, by default,...

isn't it just looking for the student_id column, not finding it in the emp table, so its taking it from the student table?

using table alias's would ensure the correct column...

hi.

the errors started in mid october of this year. I only noticed a problem now due to a lack of free disk space on the server that this database (redgatemonitor)...

SELECT

CASE WHEN col1 < 0 THEN 1 ELSE 0 END + CASE WHEN col2 < 0 THEN 1 ELSE 0 END + CASE WHEN col3 < 0 THEN 1...

DECLARE @table TABLE(id varchar(10),descript varchar(10))

INSERT INTO @table ([id], [descript])

SELECT 'a','low'

UNION

SELECT 'b','none'

UNION

SELECT 'c','low'

UNION

SELECT 'd','qwerty'

UNION

SELECT 'e','abba'

SELECT * FROM @table ORDER BY CASE descript WHEN 'none' THEN 0 ELSE 1 end,[descript]

i've given up on trying to get the in-built intellisense working again and found a great free third party tool: http://www.atlantisinteractive.co.uk/products/sqleverywhere/default.aspx

it even suggests the columns to join on...

if you know where the column that you want to Order By, sits, you can do

select

col1

,col2

,col3

from tablename

order by 1

this will order by the first column.

change it to 'order by 2'...

thanks, i've downloaded it and...

just had a quick check and that box is unticked...

just in case it jogs anyone elses memory, i've just installed Service Pack 2 (32 bit version, although i have 64bit windows 7) for Microsoft® SQL Server® 2008 R2...

thanks for the reply.

Ive just tried that, but it didn't work 🙁

i attempted a Repair on:

microsoft sql server 2008 r2 management objects

microsoft sql server 2008 r2 management objects (x64)

Microsoft SQL...