|
IS THERE ANY PROVISION TO ASCERTAIN NEXT AND PREVIOUS RECORD IN SQL SERVER 2000 ?
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
|
Sonia Gupta wrote: IS THERE ANY PROVISION TO ASCERTAIN NEXT AND PREVIOUS RECORD IN SQL SERVER 2000 ?
Databases are set based. There is no concept of next and previous row. Any database that does this is working on a fiction.
ORDER BY can be used to impose an order on the result set, but again this is a fiction to make things easier for the calling application.
It may appear that a database is returning data in a specific order all the time, but this is merely a side-effect of the physical implementation and not something you can rely on.
|
|
|
|
|
Don't shout. Please use mixed case.
You can find next and previous records, but the queries are likely to be fairly "hairy". As Colin states, SQL is set based so you have to figure out how to work on the set.
|
|
|
|
|
oK PeTE, iT's miXeD CAsE fRoM heRE oN In. 
|
|
|
|
|
|
what are the minimum tables required to many to many relation ship.?
raja
|
|
|
|
|
You need three tables: two tables that represent entities that are related with each other and a third table to link them.
|
|
|
|
|
|
Hi,
I am woking with SSRS Matrix Control.
I have the column header -- year, Row--Programme and Data -- No of Students.
YEAR
----------------
PROGRAMME | NO OF STUDENTS
The Matrix will display all the years as columns which i have in the dataset. I have tried hiding the colums by giving a condition in the Hidden property. It does work leaving blank spaces between the columns.
Can anyone tell me How to getrid of the blank spaces between the colums or how to delete the colums of a Matix based on a condition Please?
Thanks & regards,
Payal
|
|
|
|
|
Hi all
How i can remove identity property of a column.
I will be graetful to you
Thanks
Sebastian
|
|
|
|
|
If you are Using SQL 2005,
Go to your Table (Object Explorer) and select you table, Right Click and Click Design,after that, Go to the Column that has Identity and Click once or select it, Below you will see its Properties and look for a property name "Identity Specification" user "Table Designer" , Click the "+" to Expand and Under it you will see the property named "(Is Identity" and is selected "Yes", change it and set it to "NO" And Close the Designer and if it ask you to save the changes say "YES" Then your Identity will be gone.
Hope this Helps
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Thanks for your quick reply, but i want to do this in run time, so should i get any query snippet for that
once again thanks
sebastian
|
|
|
|
|
|
ok,i am looking into it, thanks once again
sebastian
|
|
|
|
|
Mention database type(access/sql server2000 / 2005).
Do good and have good.
|
|
|
|
|
its sql server 2005
Thanks for your response
sebastian
|
|
|
|
|
Hi all, thanks for looking
I need a storedprocedure that retrieves rows based on parameters
Example 1:
SELECT * FROM Users WHERE Name LIKE '%' + @str + '%'
This will return all rows that have the word @str in Name column
If i pass '' or '%' it will return all the rows
I need the same but for an int column
Example:
SELECT * FROM Users WHERE UserID = @UserID
If i pass a number, it will return a row of the user with UserID = @UserID
But if no parameter is passed it wont work
My question is
Is there any way i can make this last query to return all the rows if no @UsersID is passed
Ill be calling this SPs from ASP.NET
Im giving this examples, i know they might seem very easy, and you may say, make 2 SPs
But in fact, Ill have more than 5 diferent filters, all applied to the same table, and any combination of this parameters is valid (param 1 and param2, param 1 only, param 5 only, param 1 2 and 4, and so on), so if i implement this in separated SPs ill end up having more than 20 almost equal SPs
Any advice will be appeciated
Thanks in advance
Alexei Rodriguez
|
|
|
|
|
Google[^] is your friend...
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hey, thanks for the link
I solved part of my problem with this:
select * from table where col1 = isnull(@param1,col1)
works great
But i have a little different scenario here
One of the parameters is for a function that returns a table, it accepts a string and splits it returning the values as one column rows, like:
select * from fnSplitString ('1,2,4,5,6') Will return:
Value
1
2
3
4
5
6
select * from table where col1 = isnull(@param1,col1)
and col2 in (select * from fnSplitString (@param2))
This works when i pass param2, but if param2 is null i need all the rows
Can this be done with a single query or do i have to make N queryes
I was gonna use for the function something like this:
select * from fnSplitString (isnull('1,2,4,5,6,','String with all posible values but seems inefficient and values can change'))
Any way to omit the second condition when @param2 is null (with single query and without SQl concatenation)?
Thanks in advance
Alexei Rodriguez
|
|
|
|
|
use if else statement in stored procedure and use this condition
If @UserID IS Not NULL
'write your query
Else
' write query without where clause, it will display all the records
Do good and have good.
|
|
|
|
|
Thanks for your reply
But as i explained in my post, i might have up to 5 optional parameters and if i use if else stataments ill end up having more than 20 almost equal combinations, which i dont want to do, not beacuse i cant (they would be almost the same), but because i believe that there is a better solution for this problem
Thanks
Alexei Rodriguez
|
|
|
|
|
Hello,
I need some help with a SQL query.
Example table:
Table myTable
Columns
myId, myDate
If I have rows in the table with the same id like this:
myid mydate
---- --------
1 01/01/1999
1 blank
1 01/01/1999
2 01/02/1999
I would like to filter out the id completely if I find the id has a record with a date and a record with a blank date.
If the filter works my results should be:
myid mydate
---- --------
2 01/02/1999
Id 2 remains because it does not have records with a blank date.
Thank you so much for the help.
|
|
|
|
|
Your request is somewhat confusing but, I think I grasped the basic concept. I assume you are using blank as a term that represents NULL.
SELECT
myid,
mydate
FROM
myTable
WHERE
myid NOT IN (SELECT
myid
FROM
myTable
WHERE
mydate IS NULL)
|
|
|
|
|
Try
SELECT myid, mydate<br />
FROM myTable mt1 <br />
WHERE not exists (select 1 from myTable mt2<br />
where mt2.myID = mt1.myid and mt2.mydate is null)
Assuming the table is properly indexed this should execute quicker as a not exists is quicker than a not in.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Does anybody know where there is an article about how to write a .HLP help file? It is my understanding that it can be done in Windows and can also be done in a web type application.
modified on Wednesday, March 5, 2008 5:27 PM
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
