SQL Server :: Query Slow In Loading / Trying To Display Query Result?

Feb 1, 2011

I am trying to display this query result in an aspx page.

It is very slow in loading. Here is the query. The inner query inside the outer quesry is the problem.(Please see the underlined part in the query) - (If I remove that part it is very fast.)


top 500

--This column is the issue
,Governing_Class=( case when exists (select top 1 tqc.class_code from
t_quote_class tqc
inner join t_quote_class_premium tqcm on tqc.class_code =tqcm.
where tqc.appid=pi.appid and tqc.class_code not in('8742' ,'8810','7380')
order by tqcm.premium_amt desc
then ( select top 1 tqc.class_code from
t_quote_class tqc
inner join t_quote_class_premium tqcm on tqc.class_code =tqcm.
where tqc.appid=pi.
order by tqcm.premium_amt desc
......... From tables

View 7 Replies

Similar Messages:

SQL Server :: How To Copy Result Query To Another Query

Nov 4, 2010

i have tow query in one stored procedure

first query and the second one every of them return only value

i want to copy the result of tow values in a new row in new table

as i want to check on this tow values in ado.net

i want to get only this tow values as a row not first and secon query

only a row has result of first and second query results


View 3 Replies

SQL Server :: Query Is Running Very Slow

Mar 19, 2011

The below SQL query is running extremely slow. Im using this query on other tables and its processing about 5 rows per second. The below version is running 1 row every 10 seconds when @SQLNew is executed.


View 5 Replies

Slow Query When Connecting To Linked Server?

Nov 18, 2010

I've got this query UPDATE linkeddb...table SET field1 = 'Y' WHERE column1 = '1234' This takes 23 seconds to select and update one row But if I use openquery (which I don't want to) then it only takes half a second.

The reason I don't want to use openquery is so I can add parameters to my query securely and be safe from SQL injections. Does anyone know of any reason for it to be running so slowly?

View 4 Replies

SQL Server :: Query Slow On Large Volume Of Data?

Dec 27, 2010

In my database when I fire query it takes 40 secs on 1 crore data, similar when I use join with other table then it take more time. I have taken care non cluster index such thing. But still I want to optimize my query, what other thing I need to take like buffer, disk size etc. I am not sure on this area.

View 11 Replies

SQL Server :: Slow Running Query Based On Multiple Tables Using Joins

Nov 15, 2010

One of my peer wrote a query based on multiple tables using joins. One of the table is in a different database The query was taking much time

1. Create an SP
2. Create a temp table and copy all records from the external db
3. Avoid using Left Join as much as possible and use Inner Join
4. Create and use indexes
5. Remove tables/columns that are not necessary

In this scenario, I would like to suggest to use Covering Index, but how can it be created for multiple tables and a temp table?

View 3 Replies

SQL Server :: Query - How To Make Total Sum Of The Result

Nov 3, 2010

this script work with join and sum

and works good,but i want to make total sum of the result of this query for all rows of sum column


View 4 Replies

SQL Server :: How To Store Query Result In Variable

Oct 7, 2010

i am wishing to store the query result in any variable, have look at below code.


I have marked the code with bold, where I am getting error.

how do I store query result in any variable.

View 8 Replies

SQL Server :: Export A Query Result To .txt File ?

Feb 7, 2011

i need to export a query result to a .txt file , how can i do it ?

View 4 Replies

SQL Server :: Reduce Query Loading?

Dec 30, 2010

SELECT t1.Assign as [User Id],(t2.Name)as [Name],

View 5 Replies

SQL Server :: Query - Get A Result With The Latest 10 Offers For All Products With One Offer Per Product

Aug 8, 2010

I have a sql table (ProductsOffers) in which I store all the offers posted for each Product it consists of columns

offerId int
ProductId int
ProductSpec nvarchar 50
OfferDate DateTime
OfferId + ProductId = My primary Key

everyday there will be many offers for each model and some of them may have no offer in this day. Now Suuppose that I have 10 Products with 15 offers. I want a sql sentence or function that let me select the latest offer for each product. When I select by date it returns the last inserted offer and they may have repeated products and also there will be some products not appear in the result. how can I get a result with the latest 10 Offers for all my products with one offer per product

View 8 Replies

Forms Data Controls :: Displaying Correct Result Inside DropDownList From LINQ Query Result

Jul 1, 2010

I have this ListView that has a Drop Down List.Everything works fine (I think/hope) except that the drop down list are not showing its result correctly.This is the code.


The code behind consist of the page_load and the ItemDataBound

View 3 Replies

Linq To XML - Getting Correct Query Result, But It's Buried Deep In The Result Var?

Mar 1, 2011

I'm having a problem with my Linq to XML query. I'm getting the result data I want, but it's nested so deep that there must be a better way.Here is my XML:


I'm trying to get a list (simple string[]) of all Item IDs where Category Names contains "Other".Here is my Linq:



Here is a snapshot of my result from Visual Studio:The results I want are there ("item100", "item400", "item500"), but buried so deeply in the results var.

How can I get the query to return a simple

string[] = { "item100", "item400", "item500" }

View 4 Replies

DataSource Controls :: Can't Find Query's / By Right Clicking On Database Created A Query In Server Explorer?

May 17, 2010

By right clicking on my database i created a query in server explorer. But where are this query stored can't find them back. I should aspect that their is a folder query's like there is a folder tables but this isn't the case.

View 10 Replies

SQL Server :: Sub Query In Cross Table Query To Create Statistics

Mar 2, 2011

I am trying to create statitics for game downloads and am having dificulty with a sub part of my query. the goup by command is not having the disired result and i think i have been looking at it too long to see what i am doing wrong. [Code]....

At the moment it is producing each result in many rows when only 4 rows should appear. its the download column that is doing it. needs to be sub queried or something to display total in relation to month,gameid,userid.


1 1
1 1

1 1
1 1

View 2 Replies

Databases :: Oracle Query Convert To Sql Server Query

Sep 3, 2010

I am a biggner in SQL DB . but i started a complicated and painfull work in SQL SERVER 2008. the problem convert Oracle hierarchical query to SQL query. the query


View 1 Replies

Forms Data Controls :: How To Display Records After Going Through The Query Builder And Select "Test Query"

Nov 5, 2010

I have a SQL Data Source that displays records after going through the Query Builder and select "Test Query" yet when I save it, go back to the design mode and select View in Browser I get nothing but a blank screen.

View 3 Replies

Access :: OleDB Query Is Too Slow?

Jun 15, 2010

im using an access database with less than 50.000 records on a single table, no relations.

ive put the following code inside a two for cycles as per the respective variables (i, j) the connection is opened outside the outer cycle and closed after it, im holding the connection open to save up on open/close time and im using OleDB thinking it would be faster than ODBC. The ds fill operation takes nearly 3 seconds in debug mode, the total process will require almost 4 hours. How is it possible to speed it up?


View 4 Replies

How To Get The Result Value From SQL Query

Feb 9, 2011

I use the follwoing code to get a value from the SQL query. But now i would like to use some sql function like Sum() count() ... and i would like to get the result of that.
vb Code:
Dim constg As New SqlConnection
constg.ConnectionString = "Data Source=m......."
Dim payrollquery As String '= ("SELECT * FROM xxxxx.nnnnn WHERE ID IN(" & ID & " ) AND sent = 'U' ")
Dim cmd3 As New SqlCommand(sqlstr, constg)
Dim reader As SqlDataReader = cmd3.ExecuteReader

View 3 Replies

SQL Server :: Select Second Query If First Query Returns Nothing?

Oct 14, 2010

How can I SELECT second if first SELECT returns nothing?

View 8 Replies

DataSource Controls :: Query Slow And Timedout Error?

Jun 6, 2010

I have 2 tables with Primery Key in both table and 700k in each tables and i am direct executing following Query in SQL Server 2008


Its speed very slow and then timedout error. My system configuration is good and i am not executing it online but offline on my laptop.

View 3 Replies

How To Make A Result In A Query(with Var.)

Oct 31, 2010

i need to make 2 funtions on an ASP.NET c# page working with an SQL server (using Visual Web Developer 2010 Express) the 1st one is a simple serach and i've done the 2nd thing is an update , the sp is like:(it works in SQL)

UPDATE [lens] SET [qty] = @b+@c WHERE [id] = @a

@a is the id which user input in the textbox1

@b is an number user input in the textbox2

now @c should be the result of an query "select [qty] from [lens] where [id] = @a"

so ,the new value of [qty] will be the "old valus"+"valus in textbox2"

View 2 Replies

C# - SemWeb - Get Query Result In Xml?

Jun 30, 2010

I'm trying to use SemWeb library to make my SPARQL queries on an remote SPARQL endpoint.

this is what i'm using fort testing, since this is an example that came with Semweb

SparqlHttpSource source = new SparqlHttpSource("my_endpoint");

source.RunSparqlQuery("SELECT * WHERE {?entity dcterms:title 'someentity' }", new SparqlXmlQuerySink(Console.Out));

Now, what happens is that my query isn't returning xml, but javascript, how do i know that?
using this simpler example:

SparqlHttpSource source = new SparqlHttpSource("my_endpoint");

source.RunSparqlQuery("SELECT * WHERE {?entity dcterms:title 'someentity' }", Console.Out);

So my question is, how do i tell semweb to get my results in xml format?

View 2 Replies

SQL Server :: Display The Sum Of Hours And Month Year Using Query?

Sep 10, 2010

I have,hours(in varchar),Id in table tbl_x ,i need the sum of hours, monthyear(eg. mar 2010)for the last three months.But with two separate queries i am getting these results.but actually i need in the following format

Month/Year TotalHours
----------------- ----------------
Mar 2010 0400
Apr 2010 0450

to get month/Year i am using this query


View 5 Replies

How To Export Sql Query Result To Excel

Jan 4, 2010

I want to export the sql query result to excel workbook. Diffrent query results in diffrent work sheets but in a same excel sheet.

View 3 Replies

Copyrights 2005-15 www.BigResource.com, All rights reserved