I got 8 different tables and i need to represent in Gridview, it need to fetch data from 1st table and show it on first Row then 2nd and so forth till 8th table here constrain is it should show by date. i dont know to do all this i need your expert edvice. i am showing all this in follwoing Picture.
View 3 Repliesi have a store procedure that load data in a table of SQL SERVER 2008 from an excel file.the issue is, that the excel file have a column of DATE type, and i want that the system interprets the format in it, no matter what comes in it.dd/MM/yyyy mm/dd/yyyyi have an argue about this with my parnerts, cause i think is imposible, if you don't have a format before the process runs.
View 3 RepliesHow to create Jobs, I am using SQL 2005, i need a query which should get current date and compare current date with date in table and Send Email according to Job scheduled.
View 4 RepliesI need to write a query to populate a gridview with minimum rates in ascending order for a month from three tables.For example i have three tables A,B,C as follows
TABLE A TABLE B
TABLE C
Id id id
Quote_no Quote_no Quote_ no
Name Rate1 Equip_name
Rate2 E_rate
Date R1_rate
R2_rate
Date
Now if the data is as follows
I need to get the Name from Table A ,minimum Rate1 and Rate2 values for a month in a dropdownlist from date field from Table B and the corresponding minimum rate(E_rate) for Equipment E1 and E2 only from Table C for the month in ascending order group by Name.
TABLE A
id
Quote_no
Name
1
101
XYZ
2
102
ABC
TABLE B
id
Quote_no
Rate1
Rate2
Date
1
101
105
200
12/11/2010
2
102
90
210
15/11/2010
TABLE C
id
Quote_no
Equip_name
E_rate
R1_rate
R2_Rate
Date
1
101
E1
60
0
0
12/11/2010
1
101
R1
0
110
0
12/11/2010
1
101
E2
80
0
0
12/11/2010
2
102
R2
0
0
300
15/11/2010
2
102
E2
100
0
0
15/11/2010
2
102
R1
0
60
0
15/11/2010
2
102
E1
230
0
0
15/11/2010
write the query for merging two rows in a table with same date and time into one row...
2009/12/23 13:46:50 -0.43546 0.02395 -7.1621 0.45529
2009/12/23 13:46:50 0 0 0 0
2009/12/23 13:47:00 -0.47114 -0.00515 -7.1779 0.42751
2009/12/23 13:47:00 0 0 0 0
i want to merge this same datetime rows into one row ..
I am storing date data in sql server as varchar but I want to make comaparisons on this field in where clause- like this field from 2 days before or after etc
View 3 RepliesI'm looking for the best way (Performance) to do gridview columns formating RunTime /Dynamic depending on the datatable Columns type ,I want to bind the datatable to a gridview and format the Date columns to short date, and currency columns formatted with comma ex 10,000.00 inplace 100000.00 at datatable the column type is double run time (without converting them to String) since I do a filtering and sorting at these columns.
View 3 Repliesa table rows contains 02/25/2011,
03/27/2011,
04/25/2011
how to convert it rows in format -25-Feb-2011,
27-Mar-2011
25-Apr-2011
[Code]....
So it works fine i can hover on gridview rows. Now I need to add OnClick event. When Row is clicked I need to pass value from SQL server table to textbox. How can I Add something like onrowclickevent? where I can use clicked row arguments?
This one is probably snap for one for you gurus. I have a SQL table that needs to have every previous date accounted for. The user is not required to submit an entry daily, but is allowed to go back and submit when they have extra time to do so. I would like to display the next day from last date recorded in the SQL Table as a session variable, so when they go to the form to submit, the last necessary date is shown and the user knows where they left off.
View 4 RepliesI have an Access 2010 DB that I have a table of RAW data in. In my scenero when table 'a' has been populated all the rows with the updatedate of Now() get moved to another table... the SQL is like this...
[Code]....
As you can see it is a very simple query but it does NOT return any rows. There are actually 404 rows with todays date in teh Append_Date column.
I am stumped as to why it does not return rows?
i have table that trace views of my page. every row has the id, date view (dd/mm/yyyy hh/mm/ss) how can i distinct the data into gridview (or something else) and display only the days (01/03/2011, 02/03/2001, 03/03/2011) and to sum the numbers of views (01/03/2011 1,290 views, 02/03/2011 867 views.....)
View 7 RepliesI have two tables for storing language translations - tblEN and tblES. They have the same structure which is nvcEnglish and nvcLocal - both nVarChar fields.
In nvcLocal of the Spanish table, I enter the Spanish translations of words and phrases used within my app. Problem is, when I add a bunch of new records to the English table I also have to go in and repeat the data entry into the Spanish table. I am wondering if there is a way to import the newly added records into the Spanish table using Transact SQL?The plain language query would be something like:
If the data in tblEN.nvcEnglish does not exist in tblES.nvcEnglish then insert a new row into tblES with the values from tblEN
[URL]above url contain a html table.I want to save this table value on XML and also want to save this table value on database MS2008.How to save html table values on database
View 3 Repliesi've created one package using ssis ..
That is used for transferring the data from the tableA to tableB daily at evening..
now my problem is ..
i've huge amount of data i.e upto 2GB of data while transferring for first time
the whole amount data is transferred.. and now i want to transfer only the daily updates
i.e what data i've entered today that much only it should transfer instead of whole data (2GB)..
how to do it .
im new to trigger concept
when i insert data in a table [DSR_OUT_PRO] data get enter in another table ie [trg_Insert_DSR_OUT_PRO] but 2 times..
Is it ok, or something is wrong..
In short, I have 3 text box fields on an .aspx page named as follows:-
TextBoxIncident
TextBoxDate
TextBoxDescription
in addition a sql datasource is on the page which is connected to the incident table with an insert query which allows the data entered into the fields to be inserted into the database...
The Textboxincident and textboxdescription fields allow the user to enter data into them...
the TextBoxDate field is a read only and the code behind file enables the text box to show the current date and time the code im using is shown below...
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim TextBoxDate As TextBox
TextBoxDate = FormView1.FindControl("TextBoxDate")
TextBoxDate.Text = DateTime.Now
End Sub
When run in browser the textboxdate field shows the current date and time...and Once the textbox incident and text box description fields have been filled in and the submit button is clicked, the fields should be bound to MS SQL table called Incident. This did work before, however it as suddenly stopped working and now displays the following message to me:-
Arithmetic overflow error converting expression to data type datetime. The statement has been terminated.
I am trying to create a stored procedure that filters data from sql server by date but i get this error:
Conversion failed when converting datetime from character string.
my stored procedure is like:
[Code]....
the parameters are passed to the stored procedures as dateTime variables from c# code...
I am trying to get gridview populated on the basis of Date as a search parameter.Date Textbox is taking date as MM-dd-yyyy.Date format in table is dd/MM/yyyy HH:mm:ss.The problem is that when I give date for example 30-04-2010, the data is not populating to gridview as the date in the table is 30/04/2010 12:00:00 .Actually I want to know query.
View 5 Replies How to get the date at which a record is created in SQL?..i.e, if i add a record to a database table db1 at 8/10/2010 11:30, I want to get the datetime, i.e 8/10/2010 11:30..;.Also let me know how to compare datetime values..
if(8/10/2010 11:30 >8/10/2010 10:30) will work or not?
i have the following query.
[code]....
but if there were no "hits" for a particular date range in the last week i only get the dates returned where there were hits. i need to get all the days returned and where there were no results, i need a zero returned.
hitdate hitsperday
2010-10-07 2
2010-10-06 58
2010-10-04 1645
2010-10-03 1192
what i need to return is this:
hitdate hitsperday
2010-10-08 0
2010-10-07 2
2010-10-06 58
2010-10-05 0
2010-10-04 1645
2010-10-03 1192
I have a start date and end date parameters.
i need to throw an error when the user enter a ' start date' which is more than 'end date' and an 'end date' which is less than a 'start date' .
the error should be displayed whent he user click the run button
This is House_info table in database
Id
Name
Expiredate
date
in admin.aspx page I have register button
I want when users click on button In Table in Expiredate column insert current date+1year
I mean if today is 2013-1-3Â in Expiredate column insert 2014-1-3
for this what should I wrote in SP?
a FormView that is linked to SqlDataSource1a Repeater control (inside the formview) that is linked to SqlDataSource2 Thus representing a simple "1 to many" or "parent/child" relationship in the database!
SqlDataSource1 is simple in that it just retrieves a straight set of records from a table and they are displayed back in the FormView (nothing special happening there).
SqlDataSource2 has parameters that filter the contents of the repeater based on the record that is shown in the Formview. This would normally be simple enough to set up by setting the parameter to the formview.selectedvalue property.
HOWEVER - THE PROBLEM ARISES...
The formview has multiple DataKeyNames because the table that the SqlDataSource1 links to has a compound key. So to filter the Repeater correctly SqlDataSource2 needs to map 3 parameters to 3 data key values in the formview.
I've tried setting the SqlDataSource2 parameters to:
<SelectParameters>
<asp:ControlParameter ControlID="FormView1" Name="Parameter1" PropertyName="DataKey(0)" />
<asp:ControlParameter ControlID="FormView1" Name="Parameter2" PropertyName="DataKey(1)" />
<asp:ControlParameter ControlID="FormView1" Name="Parameter3" PropertyName="DataKey(2)" />
</SelectParameters>
but it doesn't seem to like that approach. I'm expecting the answer is something similar .
I need to pass a table type parameter to a user-defined table valued function in SQL Server 2005.How would I do this?
My function name is udf_t_GetSales ( @financialYearMonthsData as table)
The table @financialYearMonthsData has 3 columns ( MonthId int, DisplayText nvarchar(500), CalendarYear int)