|
hi experts
in my table i have a column with name Date and id
Date id
2009-7-13 218665
2009-7-14 218665
2009-7-15 218665
2009-7-16 218665
2009-7-19 218665
2009-7-20 218665
2009-7-21 218665
i want to know weather rows r present from one date to another like from date and to date
if i have give from date =2009-7-13 and to date = 2009-7-20 it shuld compare with the date column it should not show all the rows are present because 200-7-17 is not available....
if i have given from date = 2009-7-12 and to date= 2009-7-16 even it shuld not show because 2009-7-12 is not present and vice versa
plz guide me
|
|
|
|
|
How about this?
if(exists(select col1 from temptable where col1 = @fromDate or col1 = @toDate))
begin
select col1,col2 from tablename
where (col1 between @fromDate and @toDate)
end
else
begin
select 'Table does not contains one of the date.'
end
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
no friend it was not working even the columns r getting which r out of dates
|
|
|
|
|
Missed out the first part. Sorry.
AFAIK you will need to write a while loop to do this matching all the dates between the range. But beware, from whatever I have read in the forums, looping techniques might cause performance related issues.
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
can u work out on that iam not getting good idea abt while loop
|
|
|
|
|
venu656 wrote: can u work out on that
Will I get paid for that? I guess no. Then I wont.
Here are the links that will help you.
While loop in SQL[^]
DateAdd function in SQL[^]
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
no yaar i cant pay iam still under bankrupt so let me describe that
|
|
|
|
|
your database should store dates and datetimes as such, not as strings. stringed dates just beg for problems.
|
|
|
|
|
thats not a big problem of string i want to know how to check each and every field in the date
|
|
|
|
|
when you store dates as real dates, not strings, you could use date functions[^]; stored as strings, you can try and apply string substringing, however you could be subject of regional setting difference problems.
|
|
|
|
|
If there can only be one entry per date then you can compare the number of rows returned with the number of days between the two dates.
Other than that I cannot help.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
hai sir
the date is one fiels but we are comparing here one fiels with fromdate and todate
|
|
|
|
|
A date does not contain subfields. You're prolly referring to the parts called "day", "month" and "year", but it takes all three to create a date.
A date is not internally stored as a combination of "day, month, year", but as a number, representing "days passed since <startdate>".
The date that you "see" (the string) is a visual representation of the same fact, but formatted for your local culture. It's a visualisation of the date (the plain number in the database) in a specific, culture-dependant string.
In other words; if it fits in a DateTime , then you won't have to check whether the month is larger than "12"
|
|
|
|
|
Hi everybody.
I would like to know about dictionaries: How do they work?
By "dictionary" I mean a program that translates a word from one language to another.
So my questions are:
1. What kind of database do they usually use to store data?
2. How do they search so quickly?
3. Where can I get more info about dictionaries/their development?
PS if it's not the right place I posted at.
|
|
|
|
|
msn92 wrote: 1. What kind of database do they usually use to store data?
A fast, embedded database. Often some custom format.
msn92 wrote: 2. How do they search so quickly?
Indexes
msn92 wrote: 3. Where can I get more info about dictionaries/their development?
Download the Ergane[^] dictionaries, and take a look at the structure. The dictionaries are in MS-Access format, and they should provide a decent starting point.
Measuring programming progress by lines of code is like measuring aircraft building progress by weight.
-- Bill Gates
|
|
|
|
|
Thank you for your reply Eddy Vluggen!
Could MS-Access database be "A fast, embedded database" ?
|
|
|
|
|
msn92 wrote: Could MS-Access database be "A fast, embedded database" ?
Yup, those databases are actually the datafiles that the Ergane-application itself uses
"The wine is good, but the meat is rotten"
|
|
|
|
|
Hello. I was tried figuring out how to use my different pc to perform DML/DDL operation in Mircosoft SQL Server and whose effect will be shown in Main PC. There demo is described below.
3 PC. 2 PC = Client for DML/DDL Operation. 1 PC = Server to reflect changes.
OS in 3 PCs = XP Pro.
All 3 PCs have Sql Server 2005 installed.
Now.. what I want to do is .. if I do any DML/DDL operation from those two pcs which acting as a client the changes should affect in the Main Server PC.
I m not figuring out the way to LINK those two PC's SQL Server with the Main PC's SQL Server.
Please assist me in finding a technique to solve this problem. We already connect these 3 pcs successfully with LAN but not getting a way to solve this problem.
|
|
|
|
|
Is the SqlServer on these PCs the Express version?
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
This sounds weird and not very good.
Do you want all 3 servers to reflect the changes made in 1?
There is not way that I know of to do this 'on the fly', you can use something like Red-Gate SQL Compare and data compare to synchronise the structure but this is a seperate operation, it generates a script that could be run on each server.
Backup/Restore will include the data (obviously)
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I have Developer Edition of SQL Server.
What actually will happen is 2 data entry operators will enter datas from 2 pcs and the changes should be made in the database reside in my Server PC. It doesn't matter for me if those 2 pcs are having SQL Server installed.
My main concern if DML/DDL from 2 pc should affect Server PC.
|
|
|
|
|
What is the client the DE users are using?
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Sorry I didn't get you mate.
All PCs have Developer Edition [DE]. And application are made by me and my friends.
Suppose when I open SQL Server 2005 and Run the Insert Query on a table then that insert should ALSO reflect in SERVER. We don't care if that Data will store in Client side too.
|
|
|
|
|
Because this is such a broad issue I have posted a link to a resource that might help you out. Replication[^]
“If you think you are worth what you know, you are very wrong. Your knowledge today does not have much value beyond a couple of years. Your value is what you can learn and how easily you can adapt to the changes this profession brings so often.”-– Jose M. Aguilar
|
|
|
|
|
Thanks.. Sorry to say from my above post regarding this
Suppose when I open SQL Server 2005 and Run the Insert Query on a table then that insert should ALSO reflect in SERVER. We don't care if that Data will store in Client side too
This will provide inconsistency if 1 client is used to re-enter the data already entered by other client.
So I think, continuous Synchronization should be there between databases as soon as any DDL/DML operation will done. How to achieve this ?
|
|
|
|