My bad...misread your post. Sorry about that.
I would check to see how you are entering that date. I would use the date as well as the time. DATEDIFF won't ignore the date.
I think you have an issue with the data. It appears that the time is reversed. The operation ended at 12:32 AM and began at 11:05 PM. Since the end time is less than the begin time, you can't avoid the negative (unless you swap the values).
I haven't gone too far. I've had people suggest that it's the Index Tuning Wizard (?) that created those views.
It's possibly related to a VB.NET app a business user created and didn't tell anyone about. He had a data grid on the app that may have created the views.
The .NET framework is...
Gorkem is right. Check out this function:
---------------------------------------------------------
Function SendMail(pstrFrom, pstrTo, pstrSubject, pstrBody)
Dim objCDOMail 'The CDO object 'Declare the Mail Object
Set objCDOMail = Server.CreateObject("CDONTS.NewMail") 'Create an...
I'm hoping that someone can help me. We had issues on our production database. We found two indexed views, "_hypmv_0" and "_hypmv_1" on a table that we were trying to insert some logging information into. Our app's connection did not have ARITHABORT set correctly so we...
If you are used to Oracle triggers, you will probably not like SQL Server triggers. Here's one I had to write. It's more complicated the the prior examples but will show you how to handle not having the :old and :new bind variables.
Sorry, no comments but hopefully the code is readable. Note...
Hey everyone. Some great info in these posts!
I'm reviewing a not-so-great database and I've noticed that the foreign key columns on some of the tables have an additional index on them.
My question is, are those additional indexes necessary? Won't SQL Server 2000 use the index created for...
If you want to avoid reading the text file one character at a time...try the following:
[code]char sString[100];
if ((hInFile=fopen("./test.txt", "r")) == NULL) {
printf("Couldn't open file.\n");
}
while (!feof(hInFile)) {
memset (sString, '\0', 100)...
If you want to avoid reading the text file one character at a time...try the following:
[code]if ((hInFile=fopen("./test.txt", "r")) == NULL) {
printf("Couldn't open file.\n");
}
while (!feof(hInFile)) {
memset (sString, '\0', 100);
fgets(sString, 100...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.