it would be

< dateadd(d,-day(getdate())+1, getdate())

It would be

< dateadd(d,-day(getdate())+1, getdate())

hi Andy

I am creating #temp objects in VB code not using proc and these objects are available and i am able to use. Once these #temp objects are opened using...

hi jan

Thanks for ur reply. I can understand once the connection is closed, #tables will be deleted. But my connection is still open and #table still available in the server....