What you need to do is to create a DATE TABLE with all the cvolumns you require. This is done in olap processing where you can query by day, month,...

Hindsight is a great thing, but I will tell you anyway.

If you had used a readconfig file to specify the db and password etc, you could have just changed it...

select (expiry_Dt)-(sysdate from dual) as noofdays

a minus sign is correct. However you need to 'select sysdate from dual' to get back todays date.

The best method I can think of is as follows:

You need to build a reference table that holds the controller id's. First time arounbd will involve an insert statement from...

Sounds like a permission problem.

Make sure that the account that sql server agent is running under has the right permissions.

Also check your sql server settings by running dcomcnfg.exe from the...

If you copied it over from dev using export and import to live you have to change the connection properties.

Also check to make sure that the account that sql server...

Can you not cycle through the recordset and use the print statement for the application in the debug window?

I often do this in vb. Alternatively, you can insert the recordset...

If I understand you correctly, you are looking to create the same table for many users but name it differently for each user.

If so, prefix the table with the users...

It sounds like the server and databases are the same names and that is causing problems. You need to use collation to fix, if this is the problem.

Just a guess!

On way would be to use the replace function.

E.g look for the value in table1 col1 and replace with the value table1 col new.

Check BOL for more info.

However, the...

One thing that stands out is the line -

([Order Details].[UnitPrice]*[Quantity]*(1-[Discount])/100)*100 AS ExtendedPrice.

You are not qualifying the quantity or discount by giving them table names. Could be picking the wring...

Have you got the oracle client on the server that you are running the job on. If not, it will not work. When you run the job manually, it using...

You want to use an 'execute sql task'.(Quickest method is to truncate the table) and on success/completion run the import task.

Check out this link - http://www.sql-server-performance.com/xml.asp

This web site is by far the best for giving out best practice advice over a wide range of subjects.