Who is online?  0 guests and 0 members
Home  »  search results

Search Results: Cursor

36 results found
  • Using a T-SQL Cursor
    In this article, Dustin covers the basics on how to use a cursor, when you should use a cursor, and when you should not use a cursor.
    Author: DustinRyan DustinRyan     Date: 11/29/2009     Section: Article
    tags : Cursor, T-SQL, SQL
  • Replacing a Cursor with SSIS
    Learn how to set up a For Loop in SSIS to replicate the same work performed by a cursor in SQL. The SSIS package will perform much faster than the cursor because the cursor is row by row and the SSIS package performs the data flow in batch.
    Author: MikeDavis MikeDavis     Date: 5/20/2010     Section: Article
    tags : Cursor, For Loop, SSIS
  • Replacing Cursor in SSIS
    yes, you were clear. Ok, than I would suggest you to insert in your dts: 1. SQL Task with your atual select that populate the cursor and return a resultset You should configure Resultset to Full result set. In this way you can return you query into a Vari
    Author: marcoadf marcoadf     Date: 1/24/2012     Section: Forum
  • Passing an argument to an Oracle Stored Procedure and returning a record set to SSRS 2008 R2
    Hi all! I am having an issue retreiving data from a Stored Procedure in Oracle to SSRS. First, I have to keep this Stored Procedure in Oracle because it is passing data of the LONG data type to SSRS and I can not seem to find a way to get a SQL Storded Pr
    Author: EvilEd209 EvilEd209     Date: 5/6/2011     Section: Forum
  • Don't be too quick to use a cursor
    A quick explanation and example of using the OUTPUT clause of a T-SQL Insert statement to capture an Identity column value for further processing
    Author: jtarnott jtarnott     Date: 12/22/2009     Section: Article
  • My Cursor Notes
    In my journey to become better at writing T-SQL code, I began studying cursors this week. For anyone who is interested, I have included some of my notes from Murach's 2008 Developer Book. Enjoy! A cursor is a database object that points to a result set. Y
    Author: acoleman acoleman     Date: 8/3/2012     Section: Blog
  • Getting Previous Row in SSIS Data Flow
    There is no native Transform built in to SSIS to get the previous row in the data flow. But with a little work you can do this and make it perform much better than a SQL cursor and you don’t have to use the dreadfully slow OLEDB Command transform. In this
    Author: MikeDavis MikeDavis     Date: 8/20/2010     Section: Blog
  • SSRS Report Catalog Path
    This has a few loops in it ( not cursor, but a WHILE loop ) - but it might do what you're after: NOTE: The contents of the ReportPaths table gets modified with this method - so make sure if you use this method, you're using a COPY of your report paths tab
    Author: KeithHyer KeithHyer     Date: 10/25/2011     Section: Forum
  • What is the best way to use OpenQuery to Access Oracle DB with Parameter
    Hello, I am using openquery and database link to access data from an Oracle database. I have created a cursor and want to get the data into the cursor. It does work very well but I am trying to filter the data before I get the data. Here is what I do now
    Author: rv7a99cv rv7a99cv     Date: 11/2/2010     Section: Forum
  • Splitting Raw Files to Fill in Missing Date Ranges
    Actually solved it myself: Cursors. A little unexpected, but it works great. Went through 21K part numbers in a little over 5 minutes. So to do the entire Inventory table will be an hour. If anyone has other ideas of how to do this quickly is SSIS, I'm st
    Author: aabundez aabundez     Date: 8/26/2011     Section: Forum
  • Replacing Cursor in SSIS
    Hi vree. Personally, I'm against the use of cursors. So far I was able to adapt any cursor solution to an T-SQL or SSIS solution. Mainly because of the disavantagens such query performance and logical reads. In SSIS you have for each loop container, wich
    Author: marcoadf marcoadf     Date: 1/23/2012     Section: Forum
  • Creating a One Row List from Multiple Rows with a Common ID Using a Cursor
    A couple weeks ago I ran into a situation where I needed to create a comma delimited list of accounts that shared the same ID. For example, I needed this... to look like this... Now, I'm sure that there is more than one way to go about doing this, but the
    Author: kylewalker kylewalker     Date: 1/5/2011     Section: Blog
    tags : Cursor
  • Replacing Cursor in SSIS
    Seeking help for topic of replacing a cursor in SQL 2000 to SSIS. I am new to SSIS and we use a cursor all the time to produce top n list of users for a QA list. If somone would be willing to walk me thru it I would very much appreciate it.
    Author: vree vree     Date: 1/23/2012     Section: Forum
  • Replacing Cursor in SSIS
    SQL Server 2000 Use cursors regularly to return a Top n list for a QA review of data. (it could be any topic, but same use over and over.) List of people who attended a meeting, or list of people who made phone calls...... Migrating to 2008 and upgrading
    Author: vree vree     Date: 1/23/2012     Section: Forum
  • Replacing Cursor in SSIS
    I wrote a blog on replacing a cursor with SSIS. http://www.bidn.com/articles/ssis-development/125/replacing-a-cursor-with-ssis
    Author: MikeDavis MikeDavis     Date: 1/24/2012     Section: Forum
    tags : cursor
  • cursor
    hi i need to put fetch next in my cursor.its goig endless. declare @P1 nvarchar(32) declare @mtd2 float declare c1 CURSOR FOR select account, MTD from #temp2 open c1 FETCH NEXT FROM c1 INTO @P1,@mtd2 WHILE @@FETCH_STATUS = 0 begin if(@mtd2 IS NULL ) BEGIN
    Author: ssrsnew ssrsnew     Date: 4/18/2012     Section: Forum
  • HOW to Get values from stored procedure into a field in a Report
    Thank you for your reply and keeping me posted, here what I end up to do. I decided to do everyting in the procedure level this way I don't have to do the stuff over the reort layer (my first project in reports and am learning). Created #temp table create
    Author: rv7a99cv rv7a99cv     Date: 10/19/2010     Section: Forum
  • Query question
    Hi Sherz, If the name and number of tables is static then you could use the solution suggested by nrgrovem, similiarly if there are a large number of tables then dynamic sql is a good solution as well. If, however, the number of tables varies then conside
    Author: TonjaB TonjaB     Date: 2/23/2010     Section: Forum
  • Notepad Basics
    The other day my colleague showed me the menu item "View -- Status Bar" in the notepad. I always used to see a grayed out option of the status bar in the past. But this time I could choose the option to actually show the status bar in the notepad. This st
    Author: indupriya indupriya     Date: 10/3/2010     Section: Blog
  • Alternate approach to replacing a cursor
    Introduction: Mike Davis, a frequent contributor and insightful writer, published an article today demonstrating a method to convert cursor code into an SSIS package loop. http://www.bidn.com/articles/ssis-development/125/replacing-a-cursor-with-ssis Foll
    Author: KeithHyer KeithHyer     Date: 5/21/2010     Section: Blog
  • Stupid SQL Tricks
    Although this is not directly related to BI, I thought I would share some T-SQL tricks that I've picked up over the years. The reason I chose the title is because at first glance these SQL statements might not look like they would work or the reason they
    Author: BillBrannen BillBrannen     Date: 2/23/2010     Section: Blog
  • Is it a good idea to use a temp table? Well, maybe.
    I remember sitting in a session several years ago listening to the speaker talk about some bad habits that SQL Server professionals fall into and, therefore, create less than optimum T-SQL code. I’m sure it was titled something like “T-SQL Wor
    Author: KathiKellenberger KathiKellenberger     Date: 9/24/2012     Section: Blog
  • Don't get left behind: Learn to use LAG
    Two of the most exciting developments in the T-SQL world are the enhancements to the OVER clause and the new analytic functions. These particular enhancements will enable us to write code to solve complex problems in a very efficient way. As they say in s
    Author: KathiKellenberger KathiKellenberger     Date: 10/20/2012     Section: Blog
  • Welcome
    This is a great experience, learning new way of looking at MS T- SQL and understanding what being done is wonderful. I am so grateful to have this chance to learn from pragmatic had in some time, this is challenging I think this will be fun. Thanks
    Author: kenham kenham     Date: 12/13/2010     Section: Blog
  • Post Foundation Internship
    I finished my internship at the end of March, however, my learning continues at a steady pace. Last week I spoke via phone with Tom Brenneman the VP of Recruiting at Pragmatic. He has been instrumental in helping me reframe my thought process such as the
    Author: LTRedding LTRedding     Date: 4/9/2012     Section: Blog