Search results for query: *

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

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

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

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

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

I have working linked server (ie I can pull data from it). The problem I'm running into is when I'm trying to execute a delete command, basically I want to delete any records on server2(SO_90), where the id is in another table on server1(tempE). here's my (incorrect syntax) DELETE FROM...

I can't seem to wrap my head around this one. Basically this table tblProductionReporting records production entries based on shift, date, item, ect. I need to sum a quantity based on shift, date, and item. production reporting table layout: itemNum, ShiftNum, ProductionTime (date/time)...

I need to have multiple parameters while filtering a recordset. IE: rs.Filter = "LineNumber=0001 AND (Status='Complete' OR Status='READY')" basically I need all the items for line 0001 where its Complete or Ready. I tried the above code and it gives the error. "Arguments are of...

I have a datagrid (dgReports) which is bound to an ado (adoProductionReports) control. I have certain columns that can be edited. On my datagrid's keypress event I check for the "enter" key and if that is pushed I update my database. like this: Private Sub dgReports_KeyPress(KeyAscii...

I'm using vb 6 and the crystal reports ocx, which connects to a sql server 2000 database. And when I try to directly print the report, it gives me an error "run - time error 20500 not enough memory for operation" The program works on my development computers, but just not on client...

I'm wondering what is the best way to replicate all transactions (inserts, updates, and deltes) from one sql 2000 server to another, at as close to "real-time" as possible. We need to have a up to date server ready to go in case the main db server should fail. I was looking at using...

I have a vb6 app that uses crystal reports 8.5. We have the application install on our production floor, the problem that we keep running into is when I have the user print they go through a series of vb "yes/no" boxes verifing input. Then I automatically print out 3 copies of my...

I'm trying to display a datetime value from my sql server 2000 database. When ever crystal pulls the field it only shows &quot;<<''&quot; and when I try to convert it using: CDate (totext({tblProductionReporting.ProductionTime})) crystal says &quot;Bad Date Format String&quot; the date stored...

I have two fields startTime and EndTime both are datetime format and hold the current date as well as a user defined time. ie: startTime(7/1/2003 11:34:00 AM) and endTime(7/1/2003 3:34:00 PM) I only need these fields to get the time from not the actual date. How can I do a between on them and...

I'm not using the Visual Basic crystal designer or viewer. I have a report on my harddrive (created from crystal 8.5) that I want to be able to print to &quot;whatever&quot; the local default printer is, from my application (vb6). I can get the preview and everything else to work fine, I just...