|
Thanks i worked out myslef, it should use or instead of and like this:
date < '2008-08-01' or date > '2008-08-31'
but still thanks
Andie
|
|
|
|
|
listen, use this way instead
use function month()
declare @mydate smalldatetime
set @mydate = '1-6-2005'
select month(@mymonth)
if you run that you get 1
So, code like this:
if month(mydate) <> 8
begin
...
end
easyer 
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
I am developing a software with SQL 2005 Express backend and i want to know how can i protect my databse from being viewed or modified by any DBMS?
|
|
|
|
|
Authorisation and authentication
Unless the app/dbms has the right credentials access is denied.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
|
By default, you can't do anything in the database unless you have the permissions to do so.
May be you need to get some introductory knowledge on SQL Server, in which case, get a book.
|
|
|
|
|
thanks for your reply.
any web resources you recommend?
|
|
|
|
|
isn't user-password good enough?!
Intelligence is almost useless for those who have nothing else!
Email: caiokf@gmail.com
|
|
|
|
|
Hello Friends,
I have got a requirement in which I have an Excel Workbook (latest version) as my source and SQL Server table as my destination. The scenario is that I have similar column names in both - source and destination.
So, now what I have to achieve is, if I insert some value in my excel sheet, then it should get updated in the SQL Server destination table. I have to avoid using SSIS for this.
I am not even sure if there is anyway to do this. I am researching on it and I would appreciate your help if you can also let me know your ideas.
Thank you,
notes4we
|
|
|
|
|
I suggest you use VBA to move the data to SQL. Probably fired by a button on your form.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hello,
Thank you for you reply. But do you know anyother way rather than using VBA, as Visual Basic is not installed on my local machine and there are only few excel sheets where I have to set this sort of link. So, I want to know if there is some other way to achieve this.
Thank you,
notes4we
|
|
|
|
|
notes4we wrote: Visual Basic is not installed on my local machine
No, but VBA should be installed, its part of Excel.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Ok. Is there any way to check if VBA is installed? And if it is there, then how do I exactly use if to achieve my objective. Can you please provide a brief note about it, as I have not used it before, so......
|
|
|
|
|
notes4we wrote: Is there any way to check if VBA is installed?
VBA need not be installed separately - it is part of the MS Office suite, and has always been present, at least since MS Office 97, and also exists in the latest MS Office 2007 version.
notes4we wrote: And if it is there, then how do I exactly use if to achieve my objective.
Search here[^]?
|
|
|
|
|
I found Visual Basic.
I am researching on the code now and how to use it exactly to achieve my objective.
I know google is the place where I can search for it and I am doing that, but still any thoughts from experienced people would be appreciated.
Thank you,
notes4we
|
|
|
|
|
Hi
Good that you were able to locate the IDE... there should be an in-build help facility within the IDE.
This forum is probably not a place where you can get a complete tutorial on how to use VBA. You can try out various samples that are available on the net and post here if you have a specific problem.
One such site you could try out for your learning is this site[^]
HTH
|
|
|
|
|
I found Visual Basic, but now I am researching on the code and how to use it exactly to achieve my objective. Any thoughts would be appreciated.
Thank you,
notes4we
|
|
|
|
|
Well, reaseach is all part of the job.
Good luck
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Ashfield wrote: reaseach is all part of the job.
Yes, research is an important part of the job that seems to be lacking more and more these days.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Hi there,
I need to write a query that gets overlapping date ranges from a table and also generate a random unique number for each group of overlaps. I was able to write the code below in SQL 2005 to get the overlaps for each employee in my table but I'm stuck on pairing up the overlaps.
My code currently generates the following:
Payment_Key Emp_No Start_date End_date
55 JDOE 2008-01-13 2008-01-26
56 JDOE 2008-01-16 2008-01-31
100 MPOE 2007-01-01 2007-01-15
104 MPOE 2007-01-10 2007-01-13
145 MPOE 2007-12-16 2007-12-31
150 MPOE 2007-12-16 2007-12-31
151 MPOE 2007-12-31 2007-12-31
But I need to generate the following:
Payment_Key Emp_No Start_date End_date Dup_Pair
55 JDOE 2008-01-13 2008-01-26 1
56 JDOE 2008-01-16 2008-01-31 1
100 MPOE 2007-01-01 2007-01-15 2
104 MPOE 2007-01-10 2007-01-13 2
145 MPOE 2007-12-16 2007-12-31 3
150 MPOE 2007-12-16 2007-12-31 3
151 MPOE 2007-12-31 2007-12-31 3
Here's my current code:
select distinct
t1.payment_key,
t1.emp_no,
t1.start_date,
t1.end_date
from tbl_empl_pymt_rate t1 join tbl_empl_pymt_rate t2
on t1.emp_no = t2.emp_no and
(t2.start_date between t1.start_date and t1.end_date or
t2.end_date between t1.start_date and t1.end_date or
((t1.start_date between t2.start_date and t2.end_date) and (t1.end_date between t2.start_date and t2.end_date)))
and t1.payment_key <> t2.payment_key
order by t1.emp_no, t1.start_date
Any help would be greatly appreciated.
modified on Thursday, September 18, 2008 12:07 PM
|
|
|
|
|
Hi,
If the dup_pair is a unique value for each overlapping date range, I believe that the easiest way would be to create a stored procedure and use cursor to read the data returned by your select.
You can use temporary table in sp to ease the logic if necessary. For example store duplicates first then do a second pass on the table and mark corresponding duplicates with a unique counter value.
Hope this helps,
Mika
The need to optimize rises from a bad design
|
|
|
|
|
Which software does i need to create a student database. plz help me.
|
|
|
|
|
Whichever database software you're happy with. It shouldn't make that much difference overall.
|
|
|
|
|
You can use whatever database you want. Do check and see what your requirements specify, if there are any requirements.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
sql server 2005
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
