Hi Dev,

>It's pretty bad table design.

Not really, because till non-incorporation of this new week day type task, application is running fine, no complaint. But yes, now it seems bit...

Hi,

First thank you for your reply and interest in my query. Here it is required informations :

USE [ScheduleTask]

GO

/****** Object: Table [dbo].[DBFILE] Script Date: 11/09/2011 16:54:54...

Yes, now i solved the error, just adding @ :

cmddata.Parameters("@CurrentDate") = Date

Thank you very much for your great help. Today i learnt something for SQL Server too....

First time seen,...

Here it is code and error please :

Dim cmddata As ADODB.Command

Dim cnConnection As ADODB.Connection

Dim rsdata As ADODB.Recordset

Set cmddata = New ADODB.Command

Set rsdata = New ADODB.Recordset

Set cnConnection = New ADODB.Connection

cnConnection.ConnectionString =...

"Spoon feeding"

yes, i know here i am asking spoon feeding, why, because :

1.I am not SQL Server DBA, i am Oracle DBA and here i am taking participate in my...

Thank you very much for your reply and interest in my query.

Kindly let me know how do i

1.Code the stored procedure

2.pass the required variables for the SP

So that,

I may...