DataSource Controls :: Find The Five Last Records?

Feb 19, 2010

How can I find the 5 last records ?

CREATE PROC [dbo].[SP_NEWS_SELECT]
(
@NB_NEWS int,
@ID_NEWS int,
@DT_PUBLICATION datetime
)
AS
SELECT TOP @NB_NEWS *
FROM [REP_CLI].[S_ETATS].[T_NEWS]
ORDER BY [DT_PUBLICATION] ASC

This does not work

View 4 Replies


Similar Messages:

DataSource Controls :: VS 2005 - Can't Find The 'Advanced Properties' For The XSD File - Can't Find The 'Custom Tool'?

Jan 29, 2010

I am trying to create strogly typed datasets for my project. When I right click on the xsd file that I need to generate a strongly typed dataset for I can't find the 'Advanced' properties as described in the below article (almost half way down)[URL]As I do not see the Advanced properties option I can't find the 'Custom Tool' property/option to set its value to 'MSDatasetGenerator'. Do I have to install some kind of patch on my VS 2005?

View 5 Replies

DataSource Controls :: How To Retrieve Corresponding Records

Jul 3, 2010

I have table called "Logs". It has username, sitename, actiondate and lastupdate columns.

From this, I hve created tempLogs (Temp table) using condition where lastupdate >= somedate.

Once I get records in my temp table, I then want to retreive all the records again from "logs" table corresponding to same

username, sitename?

How would I do that.

BTW: Join will not work.

View 1 Replies

DataSource Controls :: Xml.query In Sql And No Records?

Mar 15, 2010

I have table in database with xml field and data like below

[Code]....

there are no records found

View 1 Replies

DataSource Controls :: Insert 10,000 Records In One Second?

Jun 27, 2010

Suppose we have a website with 10,000 viewers each second. And we want to insert the viewer's information to the SQL database. So we must insert 10,000 records to the SQL each second. And it may take long time to do.

My question is: How can we decrease this process.

View 3 Replies

DataSource Controls :: How To Select Top X Records From Each Group

Apr 7, 2010

i have two tables (Users, Roles) and each user belongs to one role. Can I make a sql query that returns 10 newest users from each role in one query?

View 5 Replies

DataSource Controls :: How To Remove Duplicate Records

Jan 29, 2010

I am using visualstudio C# with Sql server. I want to delete previous duplicate values if exists while inserting new values into the table.

View 2 Replies

DataSource Controls :: Calculate SQL Datediff For All Records?

Jun 17, 2010

I am trying to write some SQL to populate a gridview.

The sql should print out 3 columns:

Name, County, LastCollection (the amount of days since the last collection)

I have previously calculated the amount of days since last collection individually like this:

[Code]....

But am stuck on doing it for more than 1 record to populate the gridview which should show all the records and their last collection date.

View 9 Replies

DataSource Controls :: Loop Through The Records Of A Table?

Mar 19, 2010

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?

View 9 Replies

DataSource Controls :: How To Ensure That Some Records Are Not Picked Using Sql

Apr 23, 2010

I am developing web applications using csharp. How can I ensure that some records are not picked using sql. I have a table with records and its content differ from each other dot ".". Table is as follows

Student1 Details2 Details2

1 Musol School Books
2 Musol School Books.
3 Golpp Temo Books
4 Golpp Temo Books.

How can I select records without dot "."at the end only. For example

1 Musol School Books
3 Golpp Temo Books

I have used sql but I am not getting it. My sql is as follows

select * from studentDD where Details2 !=".%"

It is not working.

View 3 Replies

DataSource Controls :: Trying To Query Records From A Db Using A Date

Apr 14, 2010

I'm trying to query records from a db using a date. But somehow the db doesn't return records.

The datetime collums have the data stored in this format in the db as datetime :

12-Apr-10 12:45:12 AM
The string a have available is in this format : 12-Apr-10

I need to somehow strip the time part of so i can use my date string in the query.

When i use the below method the database converts the datetime to a rounded date (12-Apr-10 12:00:00 AM).
But when i query for that date i still get no results.

I tried this:

SELECT ID, PerformedBy, SystemId, ServerId, CAST(FLOOR(CAST(CreateDateTime AS FLOAT)) AS DATETIME) AS Expr1, Reason, Action, Summary, EnteredBy,
Collumn1, Collumn2
FROM Changes
WHERE ('Expr1 = '12-Apr-10 12:00:00 AM')

But this way the Expr1 collumn is not recognized.

View 4 Replies

DataSource Controls :: Inserting Repetitive Records?

Mar 30, 2010

What is the best method in T-SQL 2008 for extending a table's records with the criteria of 'repeating' all fields but the Primary KEY e.g. Consecutive Date for the previous n Records.

So you have for example 7 records (Easy...2 Fields. Date and nvarchar) with th Date runing from Jan-01 to Jan-07

We want to extend the table by 21 records...so

Record 1,8,15,22 will look identical apart from the DateField.

Record 2,9,16,23 will look identical apart from the DateField. etc...etc..

I have tried a number of methods ...all coming up short....

View 4 Replies

DataSource Controls :: How To Sort The Records When Using Union

Apr 8, 2010

how to sort the records when using union

View 2 Replies

DataSource Controls :: Counting Records From A Database?

Jun 26, 2010

New to all this and trying to work out the best of doing what I need to do.

I have a little ddl with a list of 100 or so different items in it. The person clicks the button and it gets logged into a table (ItemLog).

So then where I become unstuck is I want:

A total number of records.A total number of records for each of the items in big long list.Then be able to break the records down by date.... Would I need to write out a lot of count statements in sql?

View 4 Replies

DataSource Controls :: How To Pick Up Just Some Records From Sql Database

Jul 4, 2010

In my employe db i want only employes who has a specific word in a column to be viewed in my repeater.

lets say we have names of the employes in one column and what department they belong to in the other column.

If a employe belongs to "economic" department and i want to only show the persons that works in that apartment.

What sql query could i use for that?

something like this ?:

SELECT * FROM [employes] WHERE ([apartment] LIKE '%' + economic + '%')

View 2 Replies

DataSource Controls :: Retrieving Records From DB Using SQL Class

Feb 3, 2011

When I used the (way #1) below I could retrieve search result from my DB

Way #1:

[Code]....

But When I use( way#2) "separating my code to Presentation layer and data access layer ( using SQL HELPER CLASS )"

Way # 2

Presentation layer: protected void btn_Search_Advance_Click(object sender, EventArgs e)

[Code]....

data access layer:

[Code]....

I keep getting this error: Procedure or function 'SP_Search' expects parameter '@SEARCHTYPE', which was not supplied.

View 6 Replies

DataSource Controls :: SQL Insert - Duplicate Records

Apr 2, 2010

I have code for inserting a record into the db, it works fine from the admin part of my website but when i put it on the customer side duplicate records are inserted into the db, any ideas? I cant for the life of me see why. I have just also noticed that when i add the claim the first time it adds the duplicate entry, if i press the button again it only adds the entry once, if i refresh the page add the info again, 2 entries, click add again 1 entry?

[Code]....

View 4 Replies

DataSource Controls :: Display All The Duplicate Records?

Jul 1, 2010

I want to display all duplicate records in the table.My query has to fetch all the records which are duplicate(First Name or Last Name).Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well.

Table:

ID FirstName LastName
1 Zach H Hoffman
2 Zach Hoffman
3 Troy Hoffman
4 Shawn Livermore
5 Prem S
6 Jony Hoffman H
7 Zach Modan

I need the query to filter.........

ID FirstName LastName

1 Zach H Hoffman
2 Zach Hoffman
3 Troy Hoffman
6 Jony Hoffman H
7 Zach Modan

I hope this example will give you clear idea..... I need SQL Query to perform this

View 6 Replies

DataSource Controls :: Query Returns 0 Records?

Jun 5, 2010

How come my query returns 0 records?

SELECT WebSiteID, BanDate
FROM tblWebSite
WHERE (BanDate <> NULL)

The BanDate is a date column. There are date times through the table in this column. I just want the ones with a date and ignore the rest.

View 2 Replies

DataSource Controls :: Fetch Top 10 Records From DataTable?

Jun 29, 2010

I have One DataTable Having 500 Records, want to Fetch Top 10 Record. how to do it

View 2 Replies

DataSource Controls :: XML Id List Against SQL Table Records?

May 6, 2010

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 Replies

DataSource Controls :: Convert Records Into One String?

Jun 10, 2010

Convert records into one string

View 3 Replies

DataSource Controls :: Divide Records Into Batches?

Jun 14, 2010

I would like to divide a table of 100000 records into batches of 20000. I realize I could use the select top....

but is there a faster way to do this.

View 1 Replies

DataSource Controls :: Search Records In A Database Using Linq To Sql?

Jun 19, 2010

I have a table 'articles' where all the articles are stored and I want to create a search engine for my website.

user types the keywords in the search engine and what code i should use to search the records in my database?

View 2 Replies

DataSource Controls :: Removing Redundant Records From A Dataset

Mar 26, 2010

I have a situation where i have a dataset with many, many rows but few columns (5). Lets say in one row i have A,B then somewhere else in the dataset i could have another row that has B,A. What i want to do is if A,B exists then remove the row where B,A exists.

How does one go about doing this?

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved