sql - Cursor while loop never stop. what is wrong in this code? - 


/*create table m_b (code varchar(10),itemcount int,type varchar(30),amount  money)         insert m_b values ('b001',1,'dell',10) insert m_b values ('b001',1,'dell',10) insert m_b values ('b001',1,'apple',10) insert m_b values ('b001',2,'apple',20) insert m_b values ('b001',2,'apple',20) insert m_b values ('b114',1,'apple',30.5) insert m_b values ('b114',1,'apple',10) */   --select * #temp m_c  1=2  declare cur_test cursor   select jobid,start,end_date,dayrate m_c    go  declare @jobid int declare @start date,@end_date date declare @dayrate int   open cur_test fetch cur_test @jobid,@start,@end_date,@dayrate  --begin  declare @jan int  set @jan=0  while (@@sqlstatus != 2)  begin    if month(@start)=1    begin      select @jan= @jan + datediff(dd,'2013-01-31',@start)     -- testing purpose     insert #temp values (@jan,@start,@end_date,56)   end     if month(@end_date)=1    begin      select @jan= @jan + datediff(dd,'2013-01-31',@end_date)     -- testing purpose     insert #temp values (@jan,@start,@end_date,57)    end     fetch cur_test @jobid,@start,@end_date,@dayrate  end   select @jan  waitfor  delay '00:00:10'  close  cur_test  deallocate cursor cur_test --end   select * #temp  --truncate table #temp

i'm not sure why never stop, use below condition

while @@sqlstatus = 0

so try use instead of

while (@@sqlstatus != 2)

Comments

Post a Comment

Popular posts from this blog

curl - PHP fsockopen help required -

i trying work on cloudflare api , have found in documentation. unfortunately have no idea how can use in fsockopen or through curl. here example of post request. need know how can make request below data post using curl or fsockopen curl https://www.cloudflare.com/api_json.html -d 'a=cache_lvl' \ -d 'tkn=8afbe6dea02407989af4dd4c97bb6e25' \ -d 'email=sample@example.com' \ -d 'z=example.com' \ -d 'v=agg' here link cloudflare https://www.cloudflare.com/docs/client-api.html#s4.2 try one: $ch = curl_init("https://www.cloudflare.com/api_json.html"); curl_setopt($ch, curlopt_returntransfer,1); curl_setopt($ch, curlopt_followlocation, 1); curl_setopt($ch, curlopt_ssl_verifypeer,false); // handling of -d curl parameter here. $param = array( 'a' => 'cache_lvl', 'tkn' => '8afbe6dea02407989af4dd4c97bb6e25', 'email' => 'sample@example.com', 'z' =...
Read more

HTTP/1.0 407 Proxy Authentication Required PHP -

i working in restricted network/limited access internet. since have use proxy make web service call. here php code calling web service , response . $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' => $proxy_host, 'proxy_port' => $proxy_port, 'proxy_login' => $proxy_login, 'proxy_password' => $proxy_password)); response is fatal error: uncaught soapfault exception: [wsdl] soap-error: parsing wsdl: couldn't load ' http://www.xyz.com/abc/wsdls/login.wsdl ' : failed load external entity if copy url error message , paste in browser(with same proxy settings) works. 2nd scenario is, if pass values instead of variables giving me diffarant response $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' ...
Read more

c# - Resource not found error -

i have problem accessing method on homecontroller. show code of method : [httpget] public actionresult decriptidentifiantetredirige(string login_crypter, string mdp_crypter) { string loginacrypter = _globalmanager.protegemotdepasse(login_crypter); string mdpacrypter = _globalmanager.protegemotdepasse(mdp_crypter); user userapp = new models.user(login_crypter, mdp_crypter); if (userapp.authentificationvalidee(userapp.userlogin, userapp.password)) { session["name"] = userapp.userlogin; return redirecttoaction("accueil", "home"); } else { return redirecttoaction("validerauthentification", "home"); } } then in routeconfig.cs wrote route : routes.maproute( name: "authentificationapresdecryptage", url: "{controller}/{action}/{login_crypter}/{mdp_crypter}", defaults: new...
Read more