Hi,

The INSERT command supports calling a stored procedure to supply rows for insertion into a table

CREATE TABLE #locks (spid int, dbid int, objid int, objectname sysname NULL,

indid int, type...

I think there is problem with your connction string.

Can you give me the connection string you are using?

Or you can get the useful connection string from http://www.connectionstring.com

Thanks

Regards,

Baliram Suryawanshi

Hi,

Try with following condition, It will work to solve your problem..

where Datefield > '13 Jun2006' and Datefield < '14 Jun 2006'

Regards,

Baliram

Thanks Carl,

Can you please tell me about the View

Can we update the record from view.

If yes then in which condition?

Thanks in advance.

Regards,

Baliram