Viewing 15 posts - 1 through 15 (of 38 total)
Hello Brian!
The bulk insert is continues. The table gets truncated only at the end of the business date. Insertion of the data is most important. Our requirement is that just...
July 3, 2025 at 7:28 am
Hi,
I have changed the query. It was a typo mistake. Else actually it is as below
C.nSerialNo = B.nSerialNo
Thanks
Saumik Vora
June 5, 2025 at 9:35 am
we captured the cause of deadlock and hence introduced tablock. any other option kindly revert.
September 11, 2024 at 11:08 am
Yes there is interdependency between the procedures and yes error handling and roll back is done. In each procedure explicit transaction is done with its error handling. Table 1 is...
September 11, 2024 at 7:19 am
Hello Dennis. Thanx for reply. Yes MS SQL will be used. But Wouldn’t trigger be resource expensive. Our system is going to be live 24x7. The data are time incremental...
June 6, 2024 at 9:44 pm
Hello,
Thank you all for your efforts in replying. I could trace back the issue. The flow of the stp was not proper and hence the issue.
Regards,
Saumik Vora
October 6, 2023 at 1:24 pm
Hello,
Of course the COMMIT TRAN have been put within IF and the same has been deployed already.
The question here is why in first couple of days this error did not...
October 5, 2023 at 8:52 am
Hi,
thanks for replying back. due to policies i will not be able to provide actual code but i can replicate with dummy tables. Following is the details for your ref
tblA ...
October 2, 2023 at 11:29 am
Hello,
@Jeffery and @dennis, The reason i am creating temp table with all the columns is because it will be used multiple times in the stp and all the columns will...
October 1, 2023 at 6:10 am
Hi,
Thanks for reply. I had thought of the same of pulling the data from source. the flow will be as
Source stp calls Destination stp. This destination stp connect and pull...
February 2, 2021 at 5:41 am
Hi Erland,
We have used the profiler and included SP:StmtStarting and SP:StmtCompleted events but today will check with the error ones. However i am still looking out ways to debug the...
November 8, 2019 at 7:20 am
Hi Erland,
Thanx for the help. i figured out the issue. there was space between Param variable and the value in Param definition.
October 31, 2019 at 5:57 am
Noted about the type of the question as well as insert/edit code.
Now i passed the parameter without quotes, but still blank value is getting passed to the stp instead of...
October 30, 2019 at 1:53 pm
Hi Erland,
I followed the step as you guided. however the output did not come. On checking the profiler i found that parameter value is not getting passed. The value of...
October 30, 2019 at 1:02 pm
Viewing 15 posts - 1 through 15 (of 38 total)