create proc spname as

select object_name(@@PROCID) procname

go

exec spname

One of ways I use to output xml to file.

output query (stored procedure etc) result in xml format to url

use wsh take the url as input and output to file.

Check...

convert(decimal(12,1))

There is better way of doing this.

isqlw with -C option.

It can be used just like osql from console.

foreign key does not auto create index on the column. This indicates no performance impact.

In my experiece, index is needed for speeding search.

xslt could be a way for the translation.

I am using sqlxml <sql:query> option and redirect output steam to xslt to get final result.

Use function is a way.

Here is the test case.

Change Price to money for accurate result.

create table tdata(DateOnData datetime, Item varchar(10), ClosingPrice money)

insert tdata values('1-Jan-01','sugar',400)

insert tdata values('1-Jan-01','salt',450)

insert tdata values('1-Jan-01','coffee',700)

insert tdata values('2-Jan-01','sugar',425)

insert...