March 9, 2020 at 6:47 am
In SQL Server, Currrently i having an SSIS
May i know beside of above mechanism, any other alternative technology
March 9, 2020 at 11:42 am
Without seeing the code, it's hard to know for sure if this is the best way to get things done. It is possible within T-SQL to reference a data set where by you order the data and then refer to previous rows as part of a calculation. I would not say it's always best to put things into a single T-SQL statement. However, frequently, if you can turn your operations into a single set-based command, it has enormous benefits. Here is a very rough example of that kind of processing.
That's about all I can suggest based on the information at hand. I'm not saying you should change things, but there are a number of ways to get around this sort of functionality. The devil is in the details.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply