Michael, thank you very much for your reply. I think we have a requirement that all our reports should have an ability to be exported into Excell. We can't use...

the reason we are using OPENXML in SQL Server 2000 is we get a list of integers from a source and we need to pass them into a stored procedure...

db documentor is a decent tool but if you have a large number of objects with dependencies (i.e. table is referenced by a big number of foreign key constraints )...

I don't think there is another way of doing this besides using a dynamic query. If you declare your sql string as nvarchar you can use sp_executesql and through parmeter...

create table test(Account int, fMonth int, PTDDebit int, YTDDebit int)

insert test select 10001 ,01, 100,null

union all

select

10001 ,02, 150,null

union all

select

10001, 03 ,200,null

union all

select

10002, 01, 200,null

union all

select

10002,02 ,300,null

union all

select

10002, 03, 350...

sorry, should read:

cast(@vbtime as datetime)<cast(convert(varchar(8),getdate(),108) as datetime)

IF @vbtime<cast(convert(varchar(8),getdate(),108) as datetime) print 'less'