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
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 RepliesI 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.
I have table in database with xml field and data like below
[Code]....
there are no records found
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.
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 RepliesI 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 RepliesI 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.
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 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.
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.
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....
how to sort the records when using union
View 2 RepliesNew 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?
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 + '%')
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.
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]....
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
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.
I have One DataTable Having 500 Records, want to Fetch Top 10 Record. how to do it
View 2 RepliesGiven 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 RepliesConvert records into one string
View 3 RepliesI 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.
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?
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?