Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. melontek

    Problem with TIME field

    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.
  2. melontek

    Problem with TIME field

    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).
  3. melontek

    Does anybody know about the _hypmv_ indexed views?

    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...
  4. melontek

    I am a Looser or Winner?

    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...
  5. melontek

    Does anybody know about the _hypmv_ indexed views?

    Is it possible that these views came from .NET? Found out a business user created a home-grown VB.NET app that he was using to query the table.
  6. melontek

    Does anybody know about the _hypmv_ indexed views?

    It was a custom job written by a consulting firm. They've been out of the picture for quite awhile now and this view was created yesterday afternoon.
  7. melontek

    Does anybody know about the _hypmv_ indexed views?

    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...
  8. melontek

    New need help in writing triggers

    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...
  9. melontek

    Foriegn key indexes.

    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...
  10. melontek

    Passing text from a file to an array??

    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)...
  11. melontek

    Passing text from a file to an array??

    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...

Part and Inventory Search

Back
Top