I assume you are using VB Script in an ASP page, not an actual VB project? If this is the case, then you will need to create an instance of...

I dont belive you can actually do this using ADO, you will need to use SQLDMO for this...

For example you could have a function like:

Public Function chkDBStatusNormal() As Boolean

Dim...

use a select Case statement i.e.

Select Result = Case col2

when 0 then 0

else col1/col2

end

From table

aaahhh then I belive this should give the required results:

Select Count(orderNo) as TMOrders, [Month] as theMonth into #TempTMonthOrders

From Orders

Group by [Month]

Select Count(OrderNo) as CustOrders, [Month] as theMonth into #TempCOrders

From Orders

Where...

In that case try:

Select Count(orderNo) as COrders, Month as theMonth into #TempCustOrders

From Orders

Where CustId = @CustId

Group by Month

Select t.COrders as CustOrders, Count(OrderNo) as TotalMonthOrders, Month

From Orders

inner Join #TempCustOrders t...

You could do something along the lines of:

Declare @CustMonthOrders numeric

Declare @TotalMonthOrders numeric

Declare @Month numeric

Set @Month = 1

Set @CustId = 20

Set @CustMonthOrders = (Select Count(orderNo) From Orders

Where Month = @Month and...

Check that your server is set up for Mix authentication mode and that the login under which you application will run has access writes to run the package, alternativley you...

You Could try adding an Execute Process Task to the start of your Package that calls the VPN Executable. However if your VPN software is anything like ours and requires...

You could use something like:

Select aDate from TableA

Where (Month(aDate) >= 5 And Year(aDate) >= 2002)

And ((Month(aDate) <= 5 And Year(aDate) <= 2003)

First of all you need to add a reference to the Microsoft DTSPackage Object Library.

Then in your app do something along the lines of:

Dim oDTSPackage as DTS.Package2

Set oDTSPackage =...

I am assuming that you are using ADO and have error handling in the application but are not getting any errors from executing the SP!

If this is the case then...

Use

Select * from [db1].[dbo].[tablename]

Is that a case of far to much information...

Your problem is that you can only have the identity insert on for one table at a time so you would need:

SET...

Why not just use explicit dates in the format of '20/Sep/2003' this will get around any differences in the regional settings....

Do you mean something like this:

declare @aCountry as varchar(16)

Set @aCountry = 'Mexico'

Select * From Customers where Country = @aCountry