Ctrl + 0  (zero )

How about this then for a quick answer, something similiar should be able to do it for you.

Declare @table table (EventDate int, RecordCount int)

Insert Into @table

select

 Day(CLDateofApplication) as Expr1,

 IsNULL( Count(*), 0)

From...

try something like

select Count(Events), Day(eventDate) From YourTable

Group By Day(EventDate)

Order By Day(EventDate)

hope this helps:

Create Table [Staging_Import] (

 iColumn varchar(300)

)

Create Table [Resultset] (

 FORENAME varchar(20),

 SURNAME varchar(20),

 ADDR1 varchar(30),

 ADDR2 varchar(30),

 ADDR3 varchar(30),

 TOWN varchar(30),

 COUNTY varchar(30),

 POSTCODE varchar(8),

 URN varchar(10)

)

INSERT INTO Staging_Import

(iColumn) VALUES ('1231231231231231231112312312312312312311123123123123123123111231231231123123123123123123111231231231123123123123123123111231231231123123123123123123111231231231123123123123123123111231231231123456780123456789')

INSERT INTO Staging_Import

(iColumn) VALUES ('abcdefghijklmnopqrstuvwxyz0123456789abcdefghijklmnopqrstuvwxyz0123456789abcdefghijklmnopqrstuvwxyz0123456789abcdefghijklmnopqrstuvwxyz0123456789abcdefghijklmnopqrstuvwxyz0123456789abcdefghijklmnopqrstuvwxyz01')

-- Insert Into Resultset

Select

iColumn...

Question,

will the format file always contain all those spaces? If so, then what addict is saying is not only very true, but right up your solutions alley.

My bad, misread the...

A trigger would not be the right terminology or method of doign this. Seems to me the best solution here is a DTS package that when completed, gets scheduled as...