n.elzaatari-openware-com-kw-esridist

Query Date on a FeatureClass joined with Table from SQL SERVER 2008 R2

Discussion created by n.elzaatari-openware-com-kw-esridist on Dec 27, 2010
Latest reply on Nov 29, 2011 by raywillis
ENVIRONMENT:

ArcGIS DESKTOP 10 SP0
ArcSDE 10
SQL SERVER 2008 R2

hello,

im going through something weird here..

I have a feature class joined with a table from SQL SERVER, the datasource shows properly no problem, but when i try to attribute query by date selecting the value from the unique list, i get a message "expression verified but it retuned no results" !!

Digging more into this, i viewed the bussiness table in sql server and noticed that its sotres the date with "00:00:00" so i tried to query with 'date 00:00:00' but i got a message "expression verified but it retuned no results" !!

trying to work it out, i tried to query the datatable that is added the mxd when you do a join and this time it returned an error "Invalid Sql Statement" although i have built the expression using arcmap expression builder and selected the value from the unique list.

i have attached a word 2003 document with all the screen shots with description hopping that someone can help with this

thank you

Attachments

Outcomes