Search results for query: *

...#Allowance.BoltOnRef) and (#Allowance.Allowance = 0) End SET @Charge = (Select Charge from #Allowance) SET @Mins = (Select Mins from #Allowance)*60 SET @IntMins = (Select IntMins from #Allowance)*60 Print @Charge Print @Mins Print @IntMins -- View Allowances for each customer Select *...

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

Cheers, I will have a go

I've created an Access 2000 database with linked tables to SQL V7. I want to use SQL Security, and get the Users to input there password at the startup of the database, but havn't a clue where to start. Would appreciate any help or pointers into the right direction

I'm trying to write a stored proceedure that allows me to generate numbers into a table. What I want to do is get a start number and end number then generate all the numbers in between in a specific format. ie. start Number = 2 end number = 400 I then want to process these numbers into the...

I've got an access application linked to SQL7 backend. What I am trying to do is link a form the main talbleis customers, the linked tables is TelephoneNumbers. What i am not sure is how tojust populate the subform with linked data, rather than bringing the who telephone numbers table accross...

I've found some code on the net that shows me how to change the source data file of a Bulk insert Task, Does anyone know How to change the source data file for an Excel 8.0 connection ? This is the code I've got Dim opkg, oBulkInsert Set oPkg = DTSGlobalVariables.Parent set oBulkInsert =...