ASP.NET

Prajin wrote:

I want to Upload a .resx file to the App_GlobalResource folder.

chand10 wrote:

I am trying to generate a XML file from a SQL Server table's data in a formatted way.

select * from tablename for XML auto

CREATE PROCEDURE datetesting
(
@months as tinyint,
@years as smallint
)
As

DECLARE
@startDate datetime,
@nextdate datetime,
@endDate datetime

create table #temp(startdate datetime)

begin

SET @startDate = CAST( CAST(@years AS varchar(4) ) + '0101' AS datetime )
SET @startDate = DATEADD( m, @months - 1, @startDate )

set @enddate=dateadd(m,1,@startdate)
set @enddate=dateadd(d,-1,@enddate)

insert into #temp
select @startdate as startdate

if @startdate < @enddate
begin

SET @nextdate = DATEADD( d, 0, @startdate )
set @startdate=dateadd(d,1,@nextdate)

insert into #temp
select @startdate as startdate

end

select * from #temp
drop table #temp

<br />
EXEC datetesting 1,2007<br />