Search results for query: *

I have a view using this line of code: isnull(Sum(Convert(decimal(10,2),credit_balance)),0) as creditamount Basically, it takes a value that is currently in a varchar type, changes it to a decimal and adds it up. I'm able to run this view with absolutely no problem. However, if I call this...

Please provide me with more detail. In DAO, I know to use .SQL (Ex. rst.SQL = "Exec sp_RefusedSales" & ParamString) to go inside the query to change the SQL statement but that syntax doesn't work in ADO. Please help!

How do I change the sql statement in a query using an ADO recordset? I know how to do it in DAO (.SQL) but I'm trying to use ADO for consistency.

Thanks, it worked perfectly!

I need to know how to do this in ADO not DAO.

I know how to do this using DAO but I need to use ADO instead so I can keep my programming uniform. In DAO you can change the SQL in a query using recordset and querydef but I can't figure out how to do this in ADO. The SQL statement in my pass_thru query is: EXEC sp_RefusedSales.

I have some new info regarding this problem. It seems to only be a problem on PCs that don't have SQL Server loaded on them. Because of licensing issues, loading it on all the computers that need it, isn't an option. Anybody have any ideas?

I'm having the same problem as well. If anyone has any idea regarding this, please respond!

I'm having the same problem as well. If anyone has any idead regarding this, please respond!

I found a workaround in case anyone wants to know. I still don't know why it disenables it self but I suspect its a bug in SQL Server 2000. I found out from another source that the two Enable check boxes turn off/on different things. The one in the General tab turns off/on the job while the...

Never mind . . . I think I found the problem; although, I'm not entirely sure. I believe the printer settings may have been set to print everying using a portrait orientation. The problem suddenly fixed itself about 5 minutes ago. Go figure!

I have a DTS package that runs every 5 minutes from 8am to 10pm. It's set to do this 6 days a week with no end date in site. When I check it the following day in Management->SQL Server Agent->Jobs, it shows that the scheduled job is still enabled, as it should be. However if I look to see...

I have a database in Access Project that only I use and have been using for several months. Today is the first time I've had a problem with the report orientation. All of them are stuck on portrait and I can't change it back to landscape when I'm in print preview. Please help!!!

I have a pdf file that I need to import to a table in sql server. I'd like to use DTS but I can't find anything that will work with this type of file. If there's not a way to do it through DTS, I'd like to know if I can open it in excel so I can import from there. Please help!

Thanks! I'll give it a try.

Is there a way to use a global temporary table as the record source in an access report? When I try, it tells me that the table doesn't exist.