Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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