Search results for query: *

Kchaudhry, File> Report Options > Convert Date time field> select the appropriate time. that solved it! thanks!

thanks for the quick reply...I've done that before and I don't have anything in that displays time. When I select customize I still can't select anything dealing with time. I've also verified that my database field is a date/time and not short date type.

This should be super simple, but it isn't working the way I think it should. I'm pulling a sql server 2000 date/time field into my report and it only displays the date. I need it to display the time too. I've checked the database and there is time and date being stored. How can I get crystal...

I have a table set up with a startTime and endTime ie: id startTime endTime == ===================== ==================== 1 1/15/2004 09:30:00 AM 1/15/2004 10:00:00 AM 2 1/15/2004 11:00:00 AM 1/15/2004 1:45:00 PM 3 1/15/2004 10:30:00 PM 1/15/2004 11:30:00...

nigelrivett that query works! Thanks for the help, for some reason I couldn't get the case selection working correctly when I was trying to create it... thanks again

I have a table that contains a start and end time. ID start end 1 1/15/2004 12:00:00 PM 1/15/2004 2:00:00 PM 2 1/15/2004 10:30:00 PM 1/15/2004 11:00:00 PM 3 1/15/2004 11:00:00 PM 1/16/2004 12:30:00 AM what I need is the total minutes...

I figured it out, you can run USRMGR.EXE under the NT machines system32 folder from any machine and it will do what I need it too.

I want to know if it's possible to administrate (mostly reset passwords and create new users) through windows 2000 server or pro, from a NT 4 domain.

I need to know the quickest way possible to move or copy all data from one table into another. Should I truncate the destination table then use INSERT, a DTS package, or drop the destination table and use a SELECT INTO...or is there another way? thanks

I'm using Notes 5.0.10 and when I double click notes.exe (to start program) it launches the splash screen, then it goes away but nothing else runs. I've checked the process in taskmgr and there is nothing running dealing with lotus. I've reinstalled numerous times and still the same...

Thank you. one more question about the groups. my boss also went though and deleted out what he thought shouldn't be there, so what group should i be using/be there?

Last night my boss patched 2 sql servers with the latest windows 2k patches. and now i have a bunch of jobs failing me and i can't figure out why. here is the error that i'm getting. The job failed. The Job was invoked by User sa. The last step to run was step 1 (Run DTS: package...

Great information everyone, I figured out that my query was doing a type cast, because I'm using a CASE statment, as soon as I changed the query to not include the case statement and lower the log growth to 25%, it seems to work. Everyone gave me great information. Thanks again :D

Server: Msg 9002, Level 17, State 6, Line 1 The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space. I read the other posts on this message board concerning this, thread183-355903 and I changed my log file for tempdb to grow at 50%, and...

I got something that works...it still seems to me that there should be an easier way but...for those that are following this post, this will work. SELECT MAST.* FROM QueryTrx..SO_90_UDF_Sales_Order MAST, QueryMaster..SO_90_UDF_Sales_Order TRANS WHERE --UNIQUE KEY...

swampBoogie, thanks for the quick reply. That fixes the problem I posted, but the I'm still having difficulty because I only gave a subset of the cols. Some of the tables I need to check have upwards of around 120 cols, which would require to check 120 cols for different values as well as if...

I'm simply trying to find all the fields from tbl1 (MAST) where a row is different from tbl2 (TRANS) Here's my query which seems like it *should* work, but it isn't returning anything at all. SELECT MAST.* FROM QueryTrx..SO_90_UDF_Sales_Order MAST, QueryMaster..SO_90_UDF_Sales_Order TRANS...

I think I found a solution... microsoft has a KBA on this exact situation. http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q309/1/82.ASP&NoWebContent=1 basically you have to run DBCC FREEPROCCACHE before any deletes, note this only works for...

I didn't realize I didn't say that both servers are SQL Server 2000.

We have a linked server and everything works fine, except whenever I need to run a delete or insert command the process is terribly slow. We have a T1 connection between the two sites and it only deletes around 100 records, which seems like it shouldn't take 15 minutes to run, but it does. I...