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!

  • Congratulations strongm 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. woetech

    Bulk File Date Change Based On Other Files

    Ah ha, yes, that would make sense. :-) Thank you. I will try that once I have some time later. I'm here to help. :-)
  2. woetech

    Bulk File Date Change Based On Other Files

    @ChrisHirst Thank you, I've heard of these, but I'm curious: How do I use either tool to do what I need? Again, I don't need to simply change the date/time of files, I need them changed on very specific criteria. Please read my other reply above for further clarification. Thank you. I'm here...
  3. woetech

    Bulk File Date Change Based On Other Files

    Hello, Thank you but I already understand that. I know of and have used some file date/time changing utilities, but none of them had the ability to 'mirror' or 'copy' the time/date of one file to another. I have a huge list of converted videos, probably around 200, with the old raw versions...
  4. woetech

    Bulk File Date Change Based On Other Files

    Hello, I have a bunch of old personal HD movies from a video camera that I took back in 2008/2009. They are in a raw AVCHD format and I'm currently converting all of them into a H.264 (.mp4) format to not only save space but to be able to play from different devices. The conversion has been...
  5. woetech

    Line Breaks when Exporting to Word

    Sorry all, never mind. It was my own dang fault. I've gotten so used to using LibreOffice on my own machine that I forget sometimes that it's not really Microsoft Office. I just found out that my exporting to Word is working fine as if the file is actually opened in MS Word, everything displays...
  6. woetech

    Line Breaks when Exporting to Word

    Hello, I've made a simple website for someone to use to be able to enter/update and review data in a database. I have everything working, even a printer friendly page and exporting to PDF without issue. It's the exporting to Word that's causing problems in only one area: when there's a...
  7. woetech

    SQL Cluster Jobs Issue?

    I actually finally figured it out. There were 2 things that were missing: 1.) SQL Management Studio didn't have the same SP as SQL Server, so once I installed SP2 for it, I could see the jobs fine. 2.) SSIS (Integration Services) for some reason wasn't installed on that node which is why the...
  8. woetech

    SQL Cluster Jobs Issue?

    Hello and sorry if this has been answered before, but I just can't find anything useful on it. The company I work for has a SQL Server 2005 cluster with a couple physical servers. The strange thing that is happening is that if I remote desktop to Server2 and then use SQL Management Studio to...
  9. woetech

    Simplify many joins - how?

    I don't know why I didn't think of that, but that seems to do the trick! Though, I'm wondering if the MIN function will ever skew the results in the SELECT... I don't think it will, but will research it to be sure. Thanks so much!! :D I'm here to help. :-)
  10. woetech

    Simplify many joins - how?

    Thus, it seems, whatever the date range is, the amount of days within, is the amount of extra rows per TID that I get. I'm sure it's something simple I'm missing, but any further help would be much appreciated. :) I'm here to help. :-)
  11. woetech

    Simplify many joins - how?

    I will try to get some sample data though I can't just give the current as it's sensitive. Until then, here's what the report SHOULD look like: And here's what it looks like with your query: Hopefully that helps (as formatting may be off after posting) a bit and thanks so much! I'm here to...
  12. woetech

    Simplify many joins - how?

    Thanks gmmastros, but unfortunately your method doesn't work. Instead of returning (with my example data) 51 rows, it returns 72966 rows, most are just multiples/copies it looks like and there's no data at all in the date columns. I'll have to continue to check out the PIVOT clause and see...
  13. woetech

    Simplify many joins - how?

    It is SQL 2005, so I guess I'll have to look into that. Thanks. I'm here to help. :-)
  14. woetech

    Simplify many joins - how?

    Hello. I'm generating a report that could possibly have 500 rows and over 31 columns. Most of the columns represent a single date in a date range that can go up to a month. The rows represent each of the items in the DB with data for all of those dates. The way I have the SQL now can get...
  15. woetech

    Uncommon IE6 css menu issues

    Thank you for replying. Not too long after I posted, I did finally figure out how to fix everything, at least when I test and go directly to the .html file. I put in some conditional code for IE6 to use the alternative css and used the javascript file above that I mentioned in my first post...
  16. woetech

    Uncommon IE6 css menu issues

    UPDATE: Here's a couple screenshots to help show what I mean: What IE6 displays (ie6_menu_bug.jpg): http://img.photobucket.com/albums/v230/LittlBUGer/Work/ie6_menu_bug.jpg What it should look like (ie6_no_bug.jpg): http://img.photobucket.com/albums/v230/LittlBUGer/Work/ie6_no_bug.jpg I'm...
  17. woetech

    Uncommon IE6 css menu issues

    Hello. I know all about the damn IE6 'hover' menu problem, yet have only just came to not being able to fix it with a new site I edited. In IE7/8 and Firefox and Opera, the menu looks and works great. It's a horizontal menu. Unfortunately, in IE6 each top menu item or header is using the full...
  18. woetech

    Stored Procedure secretly converts to int?

    I'm sorry to bother you guys, but I think I just found the solution. I didn't even notice this or realize what was happening, but in the SP, right above the DressingPercentage code is some code for another column of data (not shown in this topic). In that code it references the...
  19. woetech

    Stored Procedure secretly converts to int?

    Oh, sorry about that. There's actually 2 Views you'll probably need: View_User_Animals [dbo].[View_User_Animals] AS SELECT U.UserId, UN.LastName + ', ' + UN.FirstName AS Name, UN.FirstName + '_' + UN.LastName AS FullName, UN.FirstName + ' ' + UN.LastName AS...
  20. woetech

    Stored Procedure secretly converts to int?

    Hello. I've been having a mind boggling strange problem with a stored procedure I'm using within an ASP.NET website. Basically, I'm importing data from an Excel file/template into an existing table in a database (updating data as necessary). The steps are that I use sqlbulkcopy to get the...

Part and Inventory Search

Back
Top