Query about Queries
As a relatively new user to Sybase I am hoping someone can point me in the
right direction. We are getting ready to go live with our database and I am
wondering what types of queries I should be running for system performance
purposes. If anyone has any suggestions they would be more than appreciated.
Thanks in advance,
...How to Query A Query
I have been trying to build a crosstab report that reports everydate
within a selected range across the top and specific row information.
7/1 7/2 7/3 . . .
What I get as output is only the dates that contain information in the
rows. I can get the information I need by using a query within a query
Can a nested query be done in Informaker 5? What about version 6 or 7?
Thanks for your help
Convert your SQL to syntax, and you can write anything you want. So if your
DB support...How to query a query...
I'm working on converting an Access DB that I created into an ASP.NET application (and attempting to learn ASP at the same time...). One of my queries was very complex and required running a different query first, and then working off of that one. Any suggestions on the best way to do this in ASP?
The following is a sample of code I'm using so you can see the type of data-binding I'm using. Thanks for the help!
myConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; " +"Data Source=" + Server.MapPath("/EquipmentCheckout.mdb"))
strS...Query a Query
I have a result set in a query.
Is it possible to query this query?
(no specific SQL dialect, can it be done generically?)
PETROS GAVRIELIDES wrote:
> I have a result set in a query.
> Is it possible to query this query?
> (no specific SQL dialect, can it be done generically?)
There is a generic answer to your question: Yes, there is a construct
called a sub-query that allows you, in 1 SQL statement, to query from a
But, generically speaking, not all DB engines support this construct.
For instance, Firebird only added it just over a y...C# Ado.net Sql query parameter query
I'm trying to pass in a parameter value from an array in a loop that is used in a sql query and the results are populated to an xml file. The trouble is that I'm only getting the colums values in the outputted xml file. So I feel that the paramter is not being read.
So can anyone help as I'm really stuck on this one. The code is as follows :
public void DisplayUserInfo()
ArrayList UserIdArrayList = IdentifyUserID();
foreach(string ShowUserIDString in UserIdArrayList)
SqlConnection SqlConn = new SqlConnection(DBConnString)...run a query while looping through a query
I need to query a database and then run a query on each resulting row.When I do this, what all do I need to re-do to run the new SQL query?I am especially worried about not closing my conn and getting non-updated data on my application but am not exactly sure under what conditions this will happen.Thanks,Andrew Here is the code for accessing my database...//Data Accessstring strSQL = "SELECT * FROM Users WHERE email = '" + txtUser.Text + "' AND password = '" + txtPass.Text + "'";string strConn = System.Configuration.ConfigurationManage...Can sql queries be nested in sql queries?
I am having problems with a template that uses the information from one sql
query to generate a query on another table. Let me be more specific. The
template in question receives a category ID value from a web page that
provides a menu of several categories to choose from. Each Category ID
represents several Items or products to choose from. When the template
receives the category ID, the first thing it does is run a query on my
item_category table (this table lists all of the items and associates them
with the appropriate category). This query returns several itemIDs that are
all...Query and Sub-Queries
I have a SELECT statement that has two sub queries in it. The 'where'
clause in the main query filters a TRADE_DATE field, for example: ......
where TRADE_DT >= '2003/01/01' and TRADE_DT <= '2003/01/31'.
Since I only have one date field(TRADE_DATE), I want the sub-query to query
where TRADE_DT <= '2003/01/31'. But its not working. I have to hard code
the '2003/01/31'. Now I know I can make a dynamic view in VB, but an ideas
of how I can do it in SQL? Here's my statement:
select T.BROKER_SEQ_NO,B.BROKER_NAME,B.B...Query Within A Query?
I have a table that looks kinda like thisTag Info SignOutDate1 Hi 09/03/20051 Hi 09/02/20051 &n...Having trouble querying a query?
I'm trying to transition my reports from Access 2000 into Infomaker 7.0 but
I'm having trouble combining two queries together. In Access you had to
option of pulling tables or queries as your data, I don't see this option
in Infomaker, am I missing something. Thanks from a newbie...
IM doesn't have this feature, since it adheres to general Ansi SQL
standards. If you show me the Access query, maybe I can give you a
workaround. Are you querying an Access DB or a different DB, e.g. Oracle?
Terry Dykstra (TeamSybase)
Please state PB / OS / DB versions in your ...Querying a Queried result...
Hi, is there such a thing as querying a queried result?
Example, query 1 produces Result A. Result A's table is stored 'somewhere' to be queried by query 2 which produces Result B
If there is, could you kindly direct me to a website with the appropiate article on this topic?
Yes there is, querying a View is querying a query rewrite. Send me an email the address is in my profile I will send you a Views tutorial I wrote a while back and run a search for query results from View in your BOL(books online) for code samples. Hope this helps.
...Query Plan Query
We have a sql query that is causing a few issues in terms of
performance as the optimisor is choosing to table scan where
an index will certainly yield significant gains. As proven
when snapshotting the query and adding an index hint
Unfortunatley since the query is dynamically created by a
3rd party application, we are unable to influence this with
index hints and are dependant on the optimiser.
The table that is table scanning is partitioned (has also
hust been repartitioned to address a slight inbalance across
partitions) and has 7.6M records. It has been recently
r...Query a query in linq
Hi, I have some code that gets some results:var GlobalTable = from p as db.table select p; Now I want to run a query in link on the results stored in GlobalTable. Whats the best way to do this? keepin' it real in the ATX.
Exactly the way you ran the first query:
var GlobalTableSubset = from gt as GlobalTable ...Exacute query against query
I have a query which selects all dates from my database between 2 date values which is then entered into my dataset. I thin want to run through the dataset totalling the value of a certain column but only if dates match e.g.
27/02/2007 2.10 Tota...