Given an XML id list pulled out from a User Profile, how can we best program to use that list to retrieve text records from a SQL table and populate a dropdown list which contains ids from the XML list and text values from the SQL table.
View 3 RepliesI have 2 tables ( having one to many relation )
SELECT CAT.CAT_TYPE, Agencies.Name
FROM CAT INNER JOIN
Agencies ON CAT.CAT_ID = Agencies.CAT_ID
CAT_A Val1
CAT_A Val2
CAT_A Val3
I need the select statement to list only the last records of the Table Agencies , see the red color at the top , if this can be only acheived using SP
im learning t-sql, infact i needed its while-loop to loop through records of a table, i found this code in some book:
[Code]....
i understand here that setting the rowcount variable to 1 will force the select statements to return only one record, do all above select statements return one record only?
if the underlined select statement returns one record everytime it is executed, isn't it supposed to return the same first record of the table everytime? is there a better way to loop through a table's records?
I have some duplication that I need to clean up. I wrote a SQL query that is supposed to return duplicate customers who are located in the same city and zipcode.
I have 2 questions regarding it:
1. Is the query syntax correct to find duplicate records by same city and zipcode, data is being returned but it just returns the same customer a few times?
2. I only need to do the GROUP BY clause for Fullname and City however it gives an error when the other columns are left out. The error is Address, State and Zip not being in the aggregate function or in the group by clause.
Adding all the remaining columns to the GROUP BY clause works.
Query is as below:
[code].....
I have to retreive all records from a table except 1 record. For example: I give example from default database in SQL ie "master" In "master" DB we have "spt_values" table. Now if I want to retreive all records from spt_values table except 1-1 record of type = A and type = B. To retreive all records its a simple query "Select * from spt_values where type in ('A','B')" -- this will returns 16 records. Now I want to retreive all record except 1-1 record left in each type, so it will return 14 records in result.
View 6 RepliesI want to retrieve particular no of records from table with Condition..
my table structure is
QID Question Status
1 ssssss True
2 ssssss True
3 ssssss False
4 ssssss False
5 ssssss False
here i want to 3 questions condition is Status Filed TRUE Questions are must be getting..
Equivalent of recordset.Edit, Movefirst,NoMatch of vb6 in vb.Net? I want to fetch records from single table of database(Sql server 2005) and collect in collections. How can we do that by dataset and dataadapter ? We want to fetch not to display.
View 1 Repliesi am new to this linq concept,
i have used the following code to delete multiple records in my table,
but when i hit the button insteading deleting multiple records only one record is getting deleted
below is the code
protected void Button1_Click(object sender, EventArgs e)
i need to create 2 temporary tables.The records inserted into the 2nd table is the same as that from table1.
Now, i am inserting some other records into table 2.what i need is, to retrieve the count of the recently added records into table2.How to achieve this?
I have a data table with 20 records i have to get the 15 unique records randomly and have to store it in Arraylist but now problem is that how i select the 15 unique records from Data table each time .
View 9 RepliesI have a table with a structure and records as follows,
Record ID Applied From To
01 01/01/2010 01/01/2010 10/01/2010
02 12/03/2010 13/03/2010 15/03/2010
03 21/05/2010 22/05/2010 12/06/2010
I have a stored procedure which must be provided with a requested FROM date and TO date. If a given FROM date and TO date is in between any record set available in the table, it must return an error. For example,
According to above table, there is a request FROM 01/01/2010 TO 10/01/2010, and If the user enters 06/01/2010 as FROM date [Requested FROM date is already in between the Record ID 01 - FROM date and TO Date] , thus, it must display an error, or print a message.
Why do I get this nasty error? I have taken a table, and I have made an exact copy to another table. The new table hold the purged records from the other table. I want the records out of my other table to speed up the site. I don't want records from banned sites cluttering up the table.
So my procedure has gotten the thing to write the row to the table, but I get an error about a conversion to an integer. What could this be referring to?
[Code]....
I want to delete recodrs from based on some join condition between two tables.
One table belongs to my DB ( table name : FeeDetails)
and second table ( TargetTable) is on different server.
I have delete records from TargetTable table based on join condition between two tables.
I am able to select records
[Code]....
I have two tables dept and employees those table have parent and child relation ship link column is deptno i want to delte department even this departmetn contains employees i want to write storedprocedure for first delte employees and after department if i wrtie these two querys in storedprocedure will i get any problems
Begin
Delete from tbl_employees where Department_Id=@Department_Id
Delete from tbl_Department where Department_Id=@Department_Id
RETURN
END
I've got a sp as below:
The functionality I want to achieve is that when isHomePageFeatured is checked then this record is set to 1 for that column and for all the other records in the table it is set to 0.
This is fine for update as I can use the property Id to compare against, but for the newly inserted record it doesn't yet have a propertyId so I wondered if using newID() to affect all other records would have the same affect.
[Code].....
i am using an ImageButton with onClick Event above a profile on a footballer.
On Click event, a logged in user on the site can save the footballer to a Junction table called FavouriteFootballer that has
a GUID UserId and FootballerId GUID as Primary Keys.
The problems is I need to warn the user if they already have the Footballer Stored as a favourite in the database
(With a Label or MessageBox PopUp) and not sure how to with the code I have.
In code behind I have the following
[code]....
how can I insert a list (of int) to table?
View 1 RepliesSome ids are pulled out from the XML field of a certain User Profile . Those ids have their text values stored in a SQL table.
What is the best way to map that xml list to the SQL table in order to populate a dropdown list which contains ids from the XML list and text values from the SQL table?
I am trying to populate table column names into a dropdown list . how can I query using Linq to SQL to just get the list of few Column names ? in a method in DAL which I can use to load in my UI page !!
View 2 RepliesI have been working with this database for some time. Here is the situation...
I inherited a MS SQL database that has hundreds of tables with similar data. For instance:
FordTampa_customer is a table,
ChevyAtlanta_customer is a table, etc....
All of the columns are the same...just different tables with their own ID field. All I have done...Inside of another database id is created a table called 'Customer' and added an 'Dealer ID' column along with the rest of the other columns in the other tables...
So the combination of the 'Dealer ID' and the 'ID' field are unique.....I know...its not the best way to do things...but I cannot change the old data structure because I cannot have access to it. I am give back-ups on a weekly basis, so this is all I have to work with.
All right, on to the real point of my post...
Currently, I have an application that I use to select all of the data from the 'Ford_customers','Chevy_customers',etc... and inserts them into my new main 'Customer' table. I do this by selecting the table names, bind it to an arraylist, loop through the list and execute an insert statement.
I do this in VB.NET, but I would prefer to do it in a Stored procedure of some kind....I just am not sure how to accomplish it. I use this syntax to get my list of tables:
[Code]....
I am not sure how to take those names from the table and do another select based on that list of names.
I have a datagrid control which is bound to a table which containing more than 1000 records. And i want to show only 25 records once a time. I have used paging in datagrid. But each time the next page index is set, query is fired again. This takes lots of time. So what is the easiest way to bound data in this case to improve performance.
View 3 RepliesThe List Page display child Entity using the gridview each row will have link to the parent
How can I change the link so it shows the parent but in list view(using list.aspx) not detailes (detailes.aspx)view
In my table of entries, there are other entries commenting on the orig entry. The comment entries are marked in the table by having a commentID field that matches the ID field of the post being commented on. Follow?
How would I sum the nbr of comments for each orig entry?
I want it displayed in upper superscript fashion like the "2" in E=MC "2"
My Requirement is to display values of selected record from a drop down into respected textboxes
suppose i select a recordname in dropdown
the record details iam filling in a dataset and showing in textboxes .
after that My new record is if i need to select all records and display it instead of displaying it in gridview.
I need to display it in same way i.e in textboxes one by one ...even their are multiple records.
i need to display it in textboxes one by one so instead of creating table with texboxes to fill the record details.
can i create one table which keep on executing the records one by one shows the result .
I 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?