Search results for query: *

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

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

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

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

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

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

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

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

Does anybody know how i can send the file name to a stored proceedure. I've written a stored proceedure which used bulk insert to inport the contents of an excel spreadsheet (debbie.xls for example) i pick up the file name from within msAcces and can pass this in a variable to a stored...

I've set up a database using linked tables from SQL Server 7. It worked fine, but now we seem to be getting some connections issues. I traced my connections and it seems like as i am opening a main form (1) connection, from this form I'm opening another (2) connections, which contains 3...

I've set up a database using linked tables from SQL Server 7. It worked fine, but now we seem to be getting some connections issues. I traced my connections and it seems like as i am opening a main form (1) connection, from this form I'm opening another (2) connections, which contains 3...

Is it possible to link 2 DTS Packages togeather. I have created 2 packages, but I only want package 2 to run if package 1 is successful

Every day I have a file posted into a specific directory which I then manually import into an SQL table. I'm trying to work out a way to schedule this to be done automatically. I know I can set up a DTS package to import the file, but what I am trying to get my head around is getting SQL (7) to...