Not exists will be slow and use DATEDIFF(seconds instead of DATEDIFF(minute

Thank you EIJ for taking the time and atleast responseding. It is better to post any solution which you can think as many time we forget the most basic answer....

Already done and no help

The actual wild character is "*" and not "%" and even the search should be part of double quote (")

FROM ColumnName

WHERE CONTAINS(FulltextCatelogueName, '"men*"')

Nope it does not work as men in part of the word and not the whole word or the start of the word

If it does not match, I'd like to display that seperately.

I think he wants the one which does not match or may be both.

DateDiff(ss,A.Call_Time,B.Call_Time)   is better than DateDiff(mm,A.Call_Time,B.Call_Time)  

Something like this , Check for syntax

FROM A JOIN B ON A.PhoneNumber = B.PhoneNumber

AND A.Date=B.Date AND ((A.Minutes - B.Minutes) NOT BETWEEN (-0.5 AND 0.5))

AND (DateDiff(mm,A.CallTime,B.CallTime) NOT Between (-1 AND...

Here is the correct answer

('(/Test[1]/@GUID)','int')

I have tried that , but is gives an syntax error

Msg 2256, Level 16, State 1, Line 5

XQuery [value()]: Syntax error near '[', expected a "node test".

SQL 2005

is your database case sensative ?

check this

http://www.wasarrested.com

You are welcome to submit you resume. You might have to got through a technical interview or if you have submitted 7381 post in SQL Server Central

Just try the SHRINKDATABASE without TRUNCATEONLY option. This will answer all your questions.

what was your initial size of the database ?

the above script will do it

Just add "|"

like @String + "|" + <ColumnName>"