January 22nd, 2013, 09:33 PM
|
|
Registered User
|
|
Join Date: Jul 2012
Posts: 1
Time spent in forums: 44 m 22 sec
Reputation Power: 0
|
|
|
Error: No field number 0 in record
I am brand new to MS SQL. I am trying to execute a query like below from a back-end OS using appropriate dbc..
Code:
SELECT count(*) FROM Table1 with (nolock)
WHERE 1=1
and (begindate >= date '2012-12-01'
or (closedate >= date '2012-12-01' and closedate < date '2013-12-31'));
I am getting an error as
No field number 0 in record
end
Please correct me if made any mistakes in the query. Thanks !!
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
