Table A ( Year , period , A_Amount)
Table B ( Year , period , B_Amount)
Table C ( Year , period , C_Amount)
A INNERJOIN B on A.year =B.year and A.period =B.period
INNER JOIN C
on C.year =A.year and C.period =A.period
Above query doesnt work
How can I get all records from 3 tables by joing them ?
I need to Insert TableB from TableA with the records that doesn’t exist in TableB
INSERT INTO TableB
(SELECT A,B,C,D
FROM TableA
WHERE NOT EXISTS
(SELECT A,B,C,D
FROM TableB ))
Please help .. I am not able to work this out !
Code:
dv = New DataView(ds.Tables(0))
GridView1.DataSource = dv
GridView1.DataBind()
Dim bIsGridEmpty As Boolean = True
For j As Integer = 0 To GridView1.Rows.Count - 1
If GridView1.Rows(j).Cells(0).Text <> String.Empty Then...
I have the SSIS package using the wizard on the Visual studio. It basically creates the table and import the data from another database.
How can I edit this package to do the following modifications?
1. I want it to skip the Create table part. I found a CREATE TABLE query and I just deleted...
Code:
oSelection = DirectCast(csheet.Rows("1:2"), Excel.Range)
oSelection.Delete()
How can I delete the first 2 rows in an excel worksheet?
Apprantly the above code does nothing .
Please help
thx
How can I copy only the visible rows from one excel work book to another ?
Is there any property like visible range ?
Is it possible to do. Because I have multiple pivottables on an excel report where I have to hide the headers of certain pivottables . Now when I manually copy them to...
I need to show WTD, Previos WTD, MTD , Previos MTD ,YTD , Previos YTD all in one report
I have created the cube . But I I am not able to put everything on one report. I can create separate reports for each .
I am using SQL Reporting services.
Any ideas as how i should do this?
thanks
I have been able to use the pivot table in Excel and read data from a cube.However I need to be able to create my own MDX queries and
fire them up thru excel or Vb.net and progarmatically populate the
pivot tables. How do I do this ? I know how to connect
to a cube and add to different...
This is going to be my first windows CE app and I am very excited on getting it done. I am very comfortable with Visual Studio.net and I have decided to use VS 2005.
I want to know if can connect to an AS400 database from my handheld app.
I do see articles where you can connect to SQL server...
My code :
***code***
Dim vComment : vComment =request("hComment")
response.write "vIssue=" & vComment
<INPUT style="WIDTH: 547px; HEIGHT: 108px" name=S1 value ="<%=vComment%>"></INPUT >
*** end code***
Now, the INPUT textbox data looks like this
<i>ABCPerson, Sep 1 2006...
My existing ASP page current.asp has a <form> which uses post method to another ASP page called issue.asp.
I need to add another button which will post the same data to another page called feedback.asp from current.asp
How can I get this done?
I am new to asp. But I know VB very well and knows enough html stuff to debug or modify asp pages.
I have this website developed by someone using Visual Interdev and it is up to me to modify it.
Since it is pretty big and users constantly access it I have to copy all the source file to the...
My drill down report has 4 levels .
On the 4th level I need to filter records based on 2 criteria
I right click on the report
Report -> section expert -> supprees no drill down ( X-2)
In the formula editor I have
formula =Trim ({DrillOVB.SYSTEMCONDITIONS})<>"6" and {@OVBJob}>1
It doesnt...
My data.ini resides in the application exe folder contains my connection string.
When I published my app using clickonce the data.ini did not get published .
I manually copied it to the published folder and it doesnt seem to work.
The ini file holds only the connection string.
I found the...
I am not using the Static Parameter. I have set it as dynamic and there I dont have this option available .
Does that mean I have to make my parameter static. But my database changes many times a day and keeping it static doesnt make sense . Occassionally my user does want the capability to...
I am using Crystal XI and using the dynamic list of values from a stored procedure for the parameter field . So I get this interface with a dropdown where all the values are populated and the user can choose the value and run the report.
But it doesnt let the user input any values on his own ...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.