Post New Web Links

FETCH API_CURSOR

Posted By: Posted Date: October 06, 2010 Points: 0 Category :Sql Server

Hi everybody,

When I view activity monitor, under the recent expensive queries and under query column, there i see a "fetch api_cursor0000000000000003=".

So what is this?

Is this a query? Then how to see the actualll sql behind this?

Thanks

Snehal

View Complete Post

More Related Resource Links

Cutting Edge: Predictive Fetch with jQuery and the ASP.NET Ajax Library

Dino Esposito builds upon his exploration of new data binding features coming in the ASP.NET Ajax Library, explaining how to implement the predictive fetch design pattern.

Dino Esposito

MSDN Magazine February 2010

Fetch Identity column just after inserting a row in table

Hi, Please help me with this question. I have a table and I insert a row into it. How can i select the latest inserted row? Can the 'inserted table' keyword be used outside trigger? ( I mean can we use it in above scenario?? If yes how) Thanks in advance Tiya

How to fetch data from textbox dynamically in a gridview

How to fetch data from textbox inside a gridview

Data Binding a DataGrid to a list fetch the same data multiple times

Hi, I'm using DataGrid to show data through data binding. My data are provided in a list. The setup I have is the following: DataGrid "binded" to the default view of my list that implement IList<T> and IList interfaces (MyList<T> : IList<T>, IList, INotifyCollectionChanged) CollectionViewSource.GetDefaultView(_myList); // Set the data context DataContext = view; T: is here my 'business object' that hold the data, called 'MyRow'. Then the columns of the DataGrid are bound to public properties of 'MyRow' object. MyRow class has a public property of type 'object' (public object data[int index]) and first column of datagrid is bound to myRow.data[0], second column is bound to myRow.data[1] and so on. When the datagrid is displayed, databinding kick in and my data are showed in the control. The issue I'm having is that data fetching is very repetitive even for the same rows. For example for a datagrid with 20 visible rows, the first row is fetched multiple times even if the datagrid is not resized or moved. I put break point inside my list (MyList<T> into This[T] property (public T this[int index]) and i got multiple hits into the property for the same index. Fetc

fetch data from cursor(what wrong?)

hi there i have a SP that send mailbut in the cursor does not appears no one record, i written PRINT'-------' , and it seems no recordwhere is wrong here?the query returns 200 records here, but not in cursoralter PROCEDURE [dbo].MAIL (@date date) AS BEGIN declare @MonthlyTimeInterval int declare @WorkingDaysBeforeOpen int declare @WorkingDaysBeforeClose int ----valorizzazione parametri MAIL--------- select @MonthlyTimeInterval=MonthlyTimeInterval, @WorkingDaysBeforeOpen=WorkingDaysBeforeOpen, @WorkingDaysBeforeClose=WorkingDaysBeforeClose FROM ParameterData --------market in apertura------------- DECLARE @getMktOpen CURSOR declare @PeriodEND date declare @PeriodStart date declare @Market Varchar(300) declare @Status bit declare @MarketID int DECLARE @MarketPeriodID INT SET @getMktOpen = CURSOR FOR SELECT MAX(Period.[Desc]) AS PeriodEND, MIN(Period.[Desc]) AS PeriodStart, Market.[Desc] AS Market, MarketPeriod.Status, Market.MarketID, MarketPeriod.MarketPeriodID FROM MarketPeriod INNER JOIN Period ON MarketPeriod.PeriodID = Period.PeriodID INNER JOIN Market ON MarketPeriod.MarketID = Market.MarketID GROUP BY Market.[Desc], MarketPeriod.Status, Market.MarketID, MarketPeriod.MarketPeriodID -- HAVING (MarketPeriod.Status = 0) -- AND (MIN(Period.[Desc]) = CONVERT(CHAR(11),@date,111) ) OPE

Getting error when trying to fetch the preview of reports

Hi, This is the error I am getting when I try to generate the preview of the report existed in OEMCRM reports cannot be run because the connector for Microsoft SQL Server Reporting Services, a required componentfor reporting, is not installed on the server that is running Microsoft SQL Server Reporting Services. Help me if you have any ideas.

how to fetch client side hardware information??

hi...i wanted to fetch the client side hardware information using the wmi queries please help me ...i have the code for fetching hardware information using the desktop application...i wanted to impliment this onto the web application..i think any code written onto the button click event will be executed onto the server and this will give the hardware information of the server..please help me

Parent child hierarchy & MDX to fetch particular level & all members below it along with measures us

I have a Sales Territory dimension that has employee and parent employee attribute on which parent child hierarchy is defined and it gives below hierarchy while browsing - - Mark Rolls --- Lumin Jacs ----- Larry Gomes ------- Messica Owens ------- Tom Ted ----------- Jackson Lopez ----- Matthew Ron --- Fred jacob - Jason Ron --- Jecy Pedro But beside this parent-child hierarchy I have other attributes like employee address, email and telephone. My facts related sales transaction is tagged to lowest level. For example here facts are available only for Jackson Lopez (being Field Executive). When use below query I get complete sales reporting hierarchy result with some measures like sales amount, sales volume. But while accesing other attributes like address or email, it's repeating address/email/telephone of jackson Lopes everywhere to whom fact record is linked, Actually I want address/email/telephone of each sales employee from that dimension within hierarchy. How do I get it? The query I used is: Here Parent Terr ID is parent child hierachy. SELECT ( Descendants( { [Dim SalesRegion].[Parent Terr ID].[Employee Level 01].&[538018] /* here Mark Rolls is 538018 */ }, 0,AFTER), NONEMPTY([Dim SalesRegion].[Emp Address].[Emp Address].Members), NONEMPTY([Dim SalesRegion].[Emp Email].[Emp Email].Members) ) ON ROWS , { ([Dim Date].[The Year].[The Year].[CY-2010], [Dim

fetch checkbox using jquery

Hi, is there any efficient way to make selectall functionality with grid and fetch selected checkbox using button. I have used mvccontrib. Right now i am writing code as per below : <%@ Import Namespace="MvcContribJquery.Views.Home.Extensions" %> <script language="javascript" type="text/javascript"> $(document).ready(function () { $('.headerClass').each(function () { $(this).click(function () { SelectAllCheckboxes(this); }); }); }); function SelectAllCheckboxes(headerCheckbox) { //Get fieldIndex attribute of th var fieldIndex = $(headerCheckbox).attr('fieldIndex'); $(headerCheckbox).find("input:checkbox").each(function () { var isChecked = $(this).attr('checked'); $('.rowClass').each(function () { //Get rowClass checkbox var rowFieldIndex = $(this).attr('fieldIndex'); if (rowFieldIndex == fieldIndex) { $(this).find("input:checkbox").each(function () { this.checked = isChecked; }); } }); }); } function SelectCheckboxValue(fieldIndex) { $('.rowClass').each(function () { //Get rowClas

Unable to fetch text from a textbox with numeric up-down extender

I have a textbox with numeric updown extender.I want the text of the textbox.I have written code in code file is String a=txtHour.Text// Source FIle COde<asp:TextBox ID="txtHour" runat="server" ReadOnly="True" Width="45" Style="text-align:center" Height="20px"></asp:TextBox> <cc1:NumericUpDownExtender ID="NumericUpDownExtenderHr" runat="server" Enabled="True" Minimum="00" Maximum="23" TargetControlID="txtHour" Width="40"> </cc1:NumericUpDownExtender>

ho to fetch openings and closing of share market from the webservice ?

hi... i want to store openings and closing of the share market ... how i will possible and how i can fetch these openings and closings. please help me... thanks in advance...

Infopath 2007: Cant we fetch data from a list or form library without using a Query to the data conn

I am trying to fetch data from a form library and a list (both secondary data sources). But cant do it without using a rule (Query using a data connection). However when I use the 'Refresh' control on the form it brings the value. I find it quite weird, as the connections are made properly and logically speaking all the data connetions should fetch dynamic data once the form opens or loads. Cant we do it without using a (data query) rule? Update: I am using a web based infopath forms, while using the same form on client its working fine. Why is that?

How Fetch Data from HTML tags

Aslam o alaikum to allI am working in asp.net and vb.net i want to get data from <p>Dta to get in vb code</p> this and from a table like<table><tr><td>ID</td><td>Name</td><td>1</td><td>Saleem</td></tr><table>please help me thanks and best regards

Fetch data from one list and populate another list

How to fetch the details from one list & show it in an another list in Sharepoint 2010.

Example:

List #1 : Total Project/Resource List

   Resources       Projects
         Resource1 Project1,project2
  REsource2 Project1,project3

List #2 : Resources Per project

  Resources
  Resource1
  REsource2

How to fetch details from List1 based on projects (Projects (Multiline text) are comma seperted data)

Thanks.

Fetch specific information(string) from another website and display the same in my website

I am beginner and need help.

I want design a page where the end user enters information on my page and related information is fetched from the another website on my web page.

For example: Capturing City and state name from USPS.com

End user Task : Enter zipcode and click button 'Fetch'

My page perform few task

1. opens usps site backend

2. Enters the zipcode

3. Captures city name and state as temporary value from the usps

4. Displays the same in labels present in my home page.

I need help and designing the same.

Fetch data from JDEdwards

Dear Friends,

I want to fetch data from JDEdwards and put it in Microsoft Sql Server 2005, how it is possible ?, please describe it.

Thanks,

Vikash

Cannot fetch a row from OLE DB provider "ADSDSOObject" for linked server

I run following query in sql server 2005

select * FROM OPENQUERY(collegedc01,
'select samAccountName from ''LDAP://collegedc01/ou=students,dc=mycollege,dc=local''
where objectclass = ''user'' and objectcategory=''person''') ;

I got 17500 records

When I run same script in sql server 2008 64 bit I got the error message

Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "ADSDSOObject" for linked server "collegedc01"

Then I run the following query in sql server 2008 and it is returning result without any error

select top 17401 * FROM OPENQUERY(collegedc01,
'select samAccountName from ''LDAP://collegedc01/ou=students,dc=mycollege,dc=local''
where objectclass = ''user'' and objectcategory=''person''') ;

Maximum I can use 17401 without error. If I tried to use any value more than 17401 or without top clause, I am receiving error messgae.

I filter out 174


Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	Others	All