how to join 2 sql select statements in Oracle, which has different number of rows. That is I have first select statement which fetchs around 80 records in below format.
Second statement will give reocrds like below. That is it will give only distinct dates. Please tell me how to join these two queries. So that I can get
DATE Rank
12-01-2010 a
12-02-2010 b
12-03-2010 c
how to join these two queries. So that I can get result set in below format.
DATE MONEY Rank
12-01-2010 10 a
12-01-2010 15 a
12-01-2010 15 a
12-02-2010 15 b
12-02-2010 15 b
12-03-2010 15 c
12-03-2010 15 c
I have some text files I need to parse in order to display my data, and what I have now are two text files with lots of redundant data. Instead of this I would like to replace the redundant data with a number referencing the text in another text file.
I want to add Sum contents from the two tables, Realize the rows could be different, Only like rows to be added rest of the rows from both tables are listed.
SELECT TYPE AS CashFlow, Sum(AceData.InCredit) AS Credit, Sum(AceData.OutDebit) AS Debit, Sum([InCredit]+[OutDebit]) AS Totals FROM AceData where case=1 GROUP BY Type; CashFlow Credit Debit Totals Advert $0.00 ($5,816.52) ($5,816.52) BOND $0.00 ($3,060.00) ($3,060.00) Cash $18,619.57 ($34,824.75) ($16,205.18) Charity $0.00 ($6,578.00) ($6,578.00) DayCare $0.00 ($2,360.00) ($2,360.00) SELECT TYPE AS CashFlow, Sum(AceData.InCredit) AS Credit, Sum(AceData.OutDebit) AS Debit, Sum([InCredit]+[OutDebit]) AS Totals FROM AceData where case=2 GROUP BY Type; CashFlow Credit Debit Totals BOND $0.00 ($3,060.00) ($3,060.00) Cash $18,619.57 ($34,824.75) ($16,205.18) Charity $0.00 ($6,578.00) ($6,578.00) DayCare $0.00 ($2,360.00) ($2,360.00) Entertainmen $0.00 ($12,258.18) ($12,258.18) Equipment $0.00 ($7,085.00) ($7,085.00) Fee $1,957.63 ($27,611.85) ($25,654.22)
Before I get too far down the road I just want some advice. I'm building a web app using VWD2008 and MySQL 5. I've got the membership provider stuff working fine and have an odbc connection setup which works "fine". what I've noticed is that when I configure a new sqldatasource (that will be used to provide data to a listview or something) the Advanced -> generate Insert,Update..... option is disabled. I'm assuming its because of the sql syntax difference of the square brackets issue between MS SQL Server and MySQL.
Before I start writing all my own insert and update statements does anyone know if there is a way to get MySQL and VWD to talk the same language, maybe a different connector or something. I'm using mysql-connector-odbc-3.51.15
i need to join two tables in different databases, how it can be done??? and if i want to use sqldatasource control to bind results to some data-bound control how can I configure my sqldatasource control???
I would like to create a gridview where all of the items in one table are listed and a checkbox is checked if that item also shows up in another table. The difficulty comes in the fact that table are not only in different databases, but possibly on different servers.
Is there any way to do this via ASP.NET connection strings, so that it doesn't matter where the databases live? I'd rather use connection strings, because I don't want to hard-code credentials into the queries (OPENROWSET or whatnot).
I am having an issue with a join statement. The join is based on the customer id in both databases, however, I just happen to have the exact same spelling for the email field which is contained in both the customer database and the office database. How do I display the proper email address. The email I am sending sends to the office email address rather than the customer address.
I'm using the 'Configure Data Source' wizard to connect to my database and show the dataset in Gridview. I want to be able to update, insert and delete entries but am unsure how to build the query. I can write simple update statments to change database entries but how can I do this for entries that have been changed within the gridview?
I got a checkboxlist in which I bind the items with data from the DB.Means the rows in my table re directly bind tochkboxlist to display as the 7 listitems in it.Together with that am binding the state also(ie,whther it is previously checked or not by the user).Now the user have the option to edit this settings by checking or unchecking the listitems in it.We need to update this in the DB accordingly.
I need to pass the Id's of the checkd items separated by a "|" along with the state 1 or 0.Meaning if the user check 1st threecheckboxes in the list my parameters shud be (userId,1|2|3,1|1|1)..I tried in the below way..
public void UpdateNotificationSettings() { NotificationDO notifyDO = new NotificationDO();
To write a join query with or condition. It means a query has two inner join, here it is possible to fetch the records, if one inner join is true and other is false. I got a record when only two join conditions are true.
I'm trying to build a linq2Entity/gridview function for a forum, that draws data from multible tables.The result should be: Get the latest 10 threads that user(xx) has replyed in, that is not disabled or has a subject that is not allowed.Include information on the last post, thread owner user, and last post user, in each thread. ere is my code... is returns the correct threads and some that should not be there.
string sqlstring = "SELECT DISTINCT STAFF_ID, SCHOOL_CODE FROM MODULE_TIMETABLE_STAFF WHERE STAFF_ID != '" +userId + "' AND STAFF_ID LIKE '%" + Searcht + "%' ORDER BY STAFF_ID ASC";
can anyone explain this statement for me? especiallythese signs !=,+ +
How can I schedule several statements that involve select ... into ..., delete, and exec one other stored proc, periodically? For instance, every 6 hours, in Sql server DB
I'm using MySql in my asp.net project. But I don't want to type every "using MySql.Data.MySqlClient;" statement in every aspx.cs/aspx.vb file. How can I define this lines in web.config file?
I've defined some namespaces like below but this only works for aspx pages:
I've got a repeater on my asp.net (VB): <asp:Repeater ID="Repeater1" runat="server"> <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Eval("Question_Number") %>' /> <%#Eval("Question_Desc")%>
Now what I want to do is, check a value that I haven't used called "Question_Type" which could be = 1, 2 or 3 depending if it is multiple choice, short answer, etc. I have tried this:
<% if Eval("Question_type") = 1 then Response.Write(" <asp:RadioButton runat=""server"">test1</asp:RadioButton>") Response.Write(" <asp:RadioButton runat=""server"">test2</asp:RadioButton>") Response.Write(" <asp:RadioButton runat=""server"">test3</asp:RadioButton>") end if %>
and I get this error: Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control. HOW can I use this value in a if statement?
I have a ListView with many advanced controls and html tags. ListView is bound to collection of profiles when first profile in collection is current profile. current profile has few differences from other profiles ie. flash embed, js and some other stuff. I can access inside of my ListView Container.DataIndex property which gives me 0 as first item in index but i'm unable to use inline If statements like so
<% If Container.DataIndex = 0 Then %> do stuff <% EndIf %>
this is because i must place pound to access databound item but neither this
<%# If Container.DataIndex = 0 Then %> do stuff <% EndIf %>
The @( ) syntax enables a code block to have multiple tokens. For example, we could re-write the above code to concatenate a string and the number together within a @( code ) block
