I have a table named dups. There are 4 columns in the table.
id, name, path, hash
I want to return only the name, path, hash of each row where the hash field is the same. Example there are 100 rows but only two qualify the return would be.
file1 c: 10909
file4 d: 10909
For some reason this seems to be a more difficult task than I though it would be.
I have location #s, date, time, the sales amount, and tax in a excel file. The system pulls sales numbers throughout the day from each store location and places the total sales and tax numbers along with the polling date into a file.
So the most current date/time has the most upto date sales numbers at the time for that location number, but it also lists the older entries so mgmt can see how sales went during the day, and this is where my issue is, I don't need to see the old numbers from this generated file (atleast at this part of the program).
What I would like to do is write a query that only selects the most recent sales numbers for each location. I will output this to a table in ASP.NET. The query I tried using the TOP 1 clause only gave me the very first row listed below.
[code]....
Using SQL server and C# to build my web site. I need to do a bulk upload Employee data from Excel to SQL.
I use the following code to perform this. The code works fine.
[Code]....
In the Employee table there is a field called ID which is of type int and auto incrememntral . This is the primary key.
There cannot be duplicates in the combination of EmployeeName and Location. If the user tries to upload ( through the Excel file) the combination of EmployeeName and Location which is there in the database, I need to flag it.
How can I identify the duplicates in an easy way rather than going through all the records again and again? Any functaion in SQL I can use to identify the duplicates?
I have two columns first name and last name , that have duplicates, how can i remove the duplicates and only leave the distinct members intact?
View 6 RepliesI'm currectly tryin to access a specific value in my database in a specific column. I'm tryin to use the primary key of the table to access the actual value in the row of that ID.
The current code:
[Code]....
Just iterates through the table and looking for any row with the boolean 'checkin' value is True, then it takes the 'id' value of that row and stores it into an array. Is there a way that I can access a another entry, and only that entry, in the table with the 'id' stored in the array?
Like if my data base contained and int, primarykey, `id` value, a boolean, `checkedin` value, and a `time` value, is there a way to access, lets say, the row with `id` equalling 3 and and the checkIn value from that row?
I'm trying to retreive a column value from gridview5 to use it in a query to display resuls in gridview, Also how do you hide a column in the grid?
Where (p.Link_ID Like GridView5.?
[code]....
i have a datatable with several columns and rows. now i want to copy the last column fully (all rows) and create the new column with that values.
it means last column values sholud be moved to new column (now this is the last column).
Scenario:
I am creating a custom gridview control which has a custom CheckBoxTemplateField column (deriving from TemplateField class). This template field column has custom Checkboxheadertemplate (implementing ITemplate) and CheckboxItemTemplate (also implementing ITemplate). In InstantiateIn method of both templates (header as well as Item template), I am adding a checkbox control which has Autopostback = true.
My requirement is:
I want to mark all the values in the binding column of datasource if checkbox in headertemplate is checked. I dont want to mark only rows visible on grid. I WANT TO MARK ALL ROWS IN DATASOURCE. I want to do this in _CheckedChanged event of checkbox in header template.
Problem I am facing: When I check/uncheck the checkbox in header, it postbacks. so in OnCheckedChanged event, gridview's datasource is null. Secondly, in any event of gridview, I could access only those rows of datasource for which corresponding rows are visible in gridview through Gridviewrow.DataItem property. But I want to set it for all rows in datasource.
I create a table as picture below :
when I insert any character to column Name then A new string random will auto insert into column Random (picture below) I had used Trigger but It was error !
I want to column Random use to code :
DECLARE @myid uniqueidentifier
SET @myid = NEWID()
insert into table_1 values(@myid, substring(CONVERT(varchar(255), @myid), 1, 5))
but It must auto like column Number (column Number is Identity)
Is there a way to use two adrotators controls on one page and stop the same advert appearing at the same time in both controls?
I have the following but it doesn't work:
protected void AdRotator1_DataBound(object sender, EventArgs e)
{
if (AdRotator1 == AdRotator)
AdRotator1.DataBind();
}
I have a gridview that I loop through to get the x and y values of the chart control, and upon the first execution of this code, it looks great. But when the page posts back and it "refreshes" data, the original points on the chart control are still there, as well as the new values.
Is there any way to "delete" all data in the chart control to ensure this doesn't happen?
I have query that returns a line that looks like this belowA NEWYORK PROGRAM AA NEWYORK PROGRAM Bnow, the NEWYORK is inputted into a dropdownlist and the program A and program B is inputted into a dropdownlist as wellI am using utility.ControlTools.SetListControl for my dropdownlist. I would like a situation where my dropdownlist only contains one NEWYORK instead of two and my dropdownlist for programs to contain Program A and program B. Can this be done.
View 2 Repliescould some one help me how can i get max number of a column in sqlserver2005.
actually in my column records are,
1,2,3A,3B,3C LIKE this format.
so how can i get max numer i.e 4 here.
I have a simple list of data in my database that I call to my page. I have used the asp.net 'reorder list' ajax control to provide a drag and drop way of managing the sort order of my data. It uses a 'position' column in the database to do this.
How do I go about making sure that when inserting data to this table, the new item gets assigned the correct 'position' value? For example if I have 9 items already in my table, I want this newly inserted list item to get assigned a value of 10 in the position column.
i have a button and in click event i want to take the SUM() of a one cloumn and assign it into a integer and if that integer is > 20 display "pass" or something
i've tried many ways but non worked.
I was woundering if its possible for me to check for accesslevel value from the database using objectdatasouce.... From my coldfusion experience... i could just use an "if statement"
e.g: <cfif> (datasouce.column = x) then
<cfoutput> msg</cfoutput>
</cfif>
Am not so sure about .net.... All i am trying to do is to check for one value on the db and i dont mind puting it on code behind... i just need a way..
I know there is a way to get all the column name from a table, but that is not what I want
I want to get only a few column name from the table, is there a way to do this?
Let say, table A has three columns that is A1, A2 and A3, I only want A1 and A2 column names, again, can this be done?
BY the way, I am using SQL Server 2005 with asp.net application.
How to search through a Database column C# and display only what you want like a number 2 in a Gridview ..
View 12 RepliesExample:-
column values:- Microsoft Java
I like to update above record using below SQL, so that new values are appended to old values instead of removing old values.
[Code]....
Output:- Microsoft Java some text
Customers of hours buy packs of hours, these are credited and debited on their account. We have a prepayhours table and that has various columns in it, one credit and one debit. I have written a query using the Query building and SQLDS to total these columns, which is fine. What i really want to do is get that query, or if there is an easier way to add up all the debits and subtract them from the total of credits so you would end up with a + or - totalThen with that i can put it into a label or if there was a way to add a row at the end of my gridview which just said total in one column and the total of the hours in the next.
I have some SQL code which seems to work in SQL 2008 but not in the SQL designer for VWD.
CREATE VIEW dbo.prepayhrstotals
AS
SELECT COUNT(Debit) AS cntDebit, COUNT(Credit) AS cntCredit
FROM prepayhrs
GO
SELECT (cntdebit - cntcredit) AS totalhours
FROM prepayhrstotals
i dont know why this happens and when happens......i have one employee table that contain date field and that field contain two different values one is -'2008-10-01 00:00:00.000' and second is '2008-10-01 12:00:00.000'.can anyone explain when this type of value insert in database.
View 2 RepliesResetting IDENTITY column to a new valueDuring application development we always entry some test data also our tester test with test data and as a result if the table contains IDENTITY columns( specially ID column) which incremented to the number of data already entered.
However, when the application goes running with real data to the client and the client want his ID values from starting 1, then we need to RESEED the value of the IDENTITY column of the table after clearing all data. This can be done as bellows:
DBCC CHECKIDENT (TableName, RESEED, 0)
However, can be reseed with any values instead of zero(0) in the above statement.
I have an identity column that increment by 1 on every insert. I have deleted all the rows using delete query but the identity coulumn is still not reseting to zero, how do i reset it, as it was when the table was first created.
View 4 RepliesI am looking to display the value of a column and divite it by 1.175and display only the result do you know how to adjust the value of a column through a select statement in SQL?
View 7 RepliesI have following tables.
Items
ItemId
ItemName
GroupId
CatId
1
Apple
5
6
2
Banana
5
6
3
Blackberry
5
6
4
Grapes
5
6
5
Guavas
5
6
6
Beans fresh
5
7
7
Bitter Gourd
5
7
8................
