Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
casati74
Posting Yak Master
109 Posts |
 Posted - 2006-09-18 : 09:14:22
|
| hello, i have created one cursor for exec n times the sqme stored procedure but he don't work correctly.I print correct the fifty value of @idRepTag but call only two times a stored procedure, why??? declare @IdRepTag int, @TagError int, @EvError int, @IdRepEvent int --with this cursor retrive a IdTag from table RepTagConfig and pass them to mycursor declare mycursor cursor for select ScDon10.dbo.RepTagConfig.IdRepTag from ScDon10.dbo.RepTagConfig inner join ScDon10.dbo.RepTableConfig on ScDon10.dbo.RepTagConfig.IdRepTable = ScDon10.dbo.RepTableConfig.IdRepTable where (ScDon10.dbo.RepTableConfig.TableName = @InvolvedTable) open mycursor FETCH NEXT FROM mycursor INTO @IdRepTag WHILE @@FETCH_STATUS <>-1 BEGIN print 'tag retirved from doProcessData ' print @IdRepTag --retrive value from RepTagConfig, check ConditionInsert - ConditionValue -- and insert or update data into TagTableValue exec doSetTags @InvolvedTable, @IdRegister,@OperationType, @HeatID, @HeatNumber,@OrderNumber, @IdRepTag, @TagError output if (@TagError <>0) begin set @DoError = @TagError+@TagError end FETCH NEXT FROM mycursor INTO @IdRepTag end CLOSE mycursor DEALLOCATE mycursorthis is the resultchiamo la stored proceduredoProcessDatatag retirved from doProcessData 308tag retirved from doProcessData 309tag retirved from doProcessData 310tag retirved from doProcessData 311tag retirved from doProcessData 312tag retirved from doProcessData 313tag retirved from doProcessData 314tag retirved from doProcessData 315tag retirved from doProcessData 316tag retirved from doProcessData 317tag retirved from doProcessData 318tag retirved from doProcessData 319tag retirved from doProcessData 320tag retirved from doProcessData 321tag retirved from doProcessData 322select DISTINCT @lsres = ScDon10.dbo.cprConfiguration.[Name], @lsval = involved.HeatsCounter FROM ScDon10.dbo.RepTagConfig INNER JOIN ScDon10.dbo.cprConfiguration ON ScDon10.dbo.RepTagConfig.IdTag = ScDon10.dbo.cprConfiguration.IdTag INNER JOIN ScDon10.dbo.crpTagType ON ScDon10.dbo.cprConfiguration.IdTagType = ScDon10.dbo.crpTagType.IdTagType cross Join eVisionDonasid.dbo.CCEquipments as involved where (ScDon10.dbo.RepTagConfig.IdRepTag=322 ) and (involved.CCEquipmentID =5)Sep 18 2006 3:08PMtgpCcNUMTund1Counter 1 direct tagtag retirved from doProcessData 323tag retirved from doProcessData 324tag retirved from doProcessData 325tag retirved from doProcessData 326tag retirved from doProcessData 327tag retirved from doProcessData 328tag retirved from doProcessData 329tag retirved from doProcessData 330tag retirved from doProcessData 331tag retirved from doProcessData 332tag retirved from doProcessData 333tag retirved from doProcessData 334tag retirved from doProcessData 335tag retirved from doProcessData 336tag retirved from doProcessData 337tag retirved from doProcessData 338tag retirved from doProcessData 339tag retirved from doProcessData 340tag retirved from doProcessData 341tag retirved from doProcessData 342tag retirved from doProcessData 343tag retirved from doProcessData 344tag retirved from doProcessData 345tag retirved from doProcessData 346tag retirved from doProcessData 347tag retirved from doProcessData 348tag retirved from doProcessData 349select DISTINCT @lsres = ScDon10.dbo.cprConfiguration.[Name], @lsval = involved.TimeCounter FROM ScDon10.dbo.RepTagConfig INNER JOIN ScDon10.dbo.cprConfiguration ON ScDon10.dbo.RepTagConfig.IdTag = ScDon10.dbo.cprConfiguration.IdTag INNER JOIN ScDon10.dbo.crpTagType ON ScDon10.dbo.cprConfiguration.IdTagType = ScDon10.dbo.crpTagType.IdTagType cross Join eVisionDonasid.dbo.CCEquipments as involved where (ScDon10.dbo.RepTagConfig.IdRepTag=349 ) and (involved.CCEquipmentID =5)Sep 18 2006 3:08PMtgpCcNUMTund1HeatCounter 0.00 direct tagtag retirved from doProcessData 350tag retirved from doProcessData 351tag retirved from doProcessData 352tag retirved from doProcessData 353tag retirved from doProcessData 354tag retirved from doProcessData 355tag retirved from doProcessData 356tag retirved from doProcessData 357tag retirved from doProcessData 358tag retirved from doProcessData 359tag retirved from doProcessData 360tag retirved from doProcessData 361but it must be tag retirved from doProcessData 359exec stored proceduretag retirved from doProcessData 360exec stored proceduretag retirved from doProcessData 361exec stored procedure.......where is the error??? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-18 : 09:23:00
|
What does doSetTag look like?Also, there is no need to check for @TagError <> 0. Any value plus zero is same value.And the code for addition is wrong. @DoError is updated for every run to twice the value of @TagError!if (@TagError <>0)beginset @DoError = @TagError+@TagErrorendset @DoError =@DoError + @TagErrororIF @TagError <> 0 set @DoError =@DoError + 1Peter LarssonHelsingborg, Sweden |
 |
|
|
casati74
Posting Yak Master
109 Posts |
Posted - 2006-09-18 : 09:27:59
|
| doSetTag retrive value from table where idRepTag is equal to @IdRepTagand if i exec select with the all single value he work correctly |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-18 : 09:32:45
|
| The only thing, right now, that I can think of, is that exec doSetTags manipulates the ScDon10.dbo.RepTagConfig table or the ScDon10.dbo.RepTableConfig table.Peter LarssonHelsingborg, Sweden |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-18 : 09:33:46
|
| The stored procedure IS called every time. But somehow, the code in doSetTags only prints twice.To make sure this is the case, addprint 'doSetTags param @IdRepTag' + CONVERT(VARCHAR, @IdRepTag)as the first line the the stored procedurePeter LarssonHelsingborg, Sweden |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-18 : 14:10:05
|
| No answer, no feedback.I wonder if I hit a homerun with my answers?Peter LarssonHelsingborg, Sweden |
|
|
|
casati74
Posting Yak Master
109 Posts |
Posted - 2006-09-19 : 08:52:45
|
| YES thank's |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
|
|
cursor