From BOL:

A view is a virtual table whose contents are defined by a query. Like a real table, a view consists of a set of named columns and rows of...

When you just use FOR you are actually creating an AFTER trigger. What you want is an INSTEAD OF trigger. The issue with INSTEAD OF triggers is that...

This should work:

[font="Courier New"]DECLARE @AMGR_Notes_Tbl TABLE (Data_Machine_Id INT, Sequence_Number INT, Owner_Id VARCHAR(10),

                               Client_Id VARCHAR(10), Contact_Number VARCHAR(15),

                               TYPE CHAR(1), Private INT, DateCol smalldatetime,

                               TimeCol smalldatetime, NewRecord INT, Owned_By_Id VARCHAR(10),

                              ...

Did you attempt to determine what might be the correct property to find folders within a folder? Maybe .Subfolders? ...

Sounds like you have spelled the column name wrong, check that.

Also, i cannot retrieve...

This is the general way to do this. Because you did not supply the schemas or clearly define what column in ptAppointments represents ScheduleID I used generic language. ...

Could you be more specific? Are there any errors? Is is not deleting files?

That would be basically the same query I gave you with datecol added to the output and a where clause.

Yes there is C# Express and VB Express 2008 available.

ISNULL (R.RateCount,'0') as R.RateCount should be ISNULL (R.RateCount, 0) as RateCount

Check out this article[/url] and the associated thread as there is custom component attached to the thread.

My VBScript skills are a little weak, but something like this should work:

Dim fso,fol,f

set fso = CreateObject("Scripting.FileSystemObject")

Set fol = fso.GetFolder("C:\Test\")

For each f in fol.Folders

...

Nope I did it in VS 2008, but I thought I had the compatability mode in 2005.

Sorry

If you are guaranteed a consistent order in the data this works:

Declare @AMGR_Notes_Tbl table (textcol varchar(max))

Insert Into @AMGR_Notes_Tbl

Select

'Spoke with Joe Adams. i told him ti schedule a demo meeting.'+

'Phone Call:...

Is there any delimiter you can use?