|
|
Posted by IW2FIV on 05/26/06 15:50
I'm a really beginner about sql2000.
During my test I have created the following query. It's works ok until I
do't add the code included in section A, when I add it the i obtain the
error: Cursor not returned from query
Anyone can help me?
Thanks Carlo M.
set nocount on
IF OBJECT_ID('storico_big') IS NULL --- section A begin
create table storico_big( data datetime,
bcarrier varchar(20),
bda CHAR(30),
bzone char(50),
bdur int) ;
insert into storico_big --- section A
end
select top 10000
adetdate,bcarrier,bda,bzone,bdur
from pp_cdr (nolock)
where
adetdate < :data_fin and adetdate > :data_in order by adetdate
set nocount off
------ end of query
Navigation:
[Reply to this message]
|