Recent content by DebbieChapman

Can anyone help on this stored procedure, The Proceedure works fine except that it rounds my charge ie if the charge is 3.5 it displays 4, I've tried to conver the @charge to money, but when I do this i get an error which says Err 257: Implicit Conversion from datatype money to nvarchar is not...

I've tried, I keep getting an error

How can i turn a negative number (ie -43) in 0 in SQL 7. I've tried using the round function but am not getting anywhere. In my view grid i want any negatives to return a 0

Cheers

Is there a way to see how long a DTS Package took to run?

No, It didn't for some reason, but I've followed your link and have it now. Thank You.

Is it possible to create a query that will display a running sum, ie Ref, Duration, RunningSum 1 10 10 2 5 15 3 30 45

How can I convert a string field containing a date into a datetime field the string field will always be in dd/mm/yy hh:mm:ss format

Cheers, I tried this but got the following error The converstion of char data type to a datetime data type resulted in an out-of-range datetime value any idea's

I have a table with 2 fields Date and time, the format of which are 23/01/2003 and 23.59.01 (hh:mm:ss) is there a way to merge these fields so that if I had to add, say 30 seconds, i could then make the datetime to be 24/01/2003 00:00:31. At the moment I can add the time, but this causes...

Yes I'm afraid the dialing code table could contain the both the dialing codes 023456 and 02345, so it does match the two, any other ideas?

I work in telecoms company, and I'm looking into a legacy sytem to try and work out a more effiecient way of doing stuff. I've found one problem, that I cant see any other way to do. Wonder if anyone else has any ideas. We keep a table of customers, and there telephone numbers (telephone...

I have and Access 2000 Database, linked to an SQL Server 7 Database. At the moment there is limited securtity within the database. The Database uses SQL Server authentication. trouble is both the user name and the password are the same, the User of the database. this is picked up from access...

I have a DTS package in which I need to force a failure, at the moment I've got Main = DTSTaskExecResult_Success in my script, I've tried changing that to Faalure, but it doesnt seem to like it, any ideas?

Again I am using an Access 2000 front end with linked tables from SQL Server 7. If I crete a startup form in Access, that askes for the user name and password, How do I pass this back to SQL to check to see firstly if the user exists for that database, and seconly if his/her password is correct