Lynn.. I have posted sample data this is the way i need it...

create table #temp2

(

crdate datetime,

Ban int

)

insert into #temp2 values ( '01/10/2009',1432)

insert into #temp2 values ( '01/11/2009',4134)

insert into #temp2 values...

Yeah tats right but all i want is to pivot that data....

when i am querying it ..i am getting

select convert(varchar(12),cr_date,101),count(*) from #tbl1

where cr_date >= convert(varchar(12),getdate()-7)

group by convert(varchar(12),cr_date,101)

i am...

Thanks Steveb...

But the problem here is...

I am srry i came to know tht the other guy is deleting manually on weekdays ...so it is not at all deleting anyday ...srry abt that and it used...

EXECUTE master.dbo.xp_delete_file 0,N'G:\DB_Backup',N'bak',N'2008-12-15T15:14:42',1

this is the delete tsql code ..please do let me know if any changes...

Thanks Lynn..I shall test it tomm in my office and i shall let u know...

Hi Lynn..

Actually i am putting verbal bcoz i need to find out how many ids have different Rnos..

anyway...i need the output this way..

id total

10 3

20 1

30...

barry by Executing that Query you will get like

10 125 4

10 20 1

but what all i need is how many ids have differenet RNos...so it should show like...

its a bit confidential so can i have your mail id so that i shall mail it to u ...

yes i am getting that but how should i do create the table and dr0p it i dont know that

no i am not adding an extra column its like startdate = getdate()

and enddate= getdate()-7

so itt will reduce a date and add a new date

Thanks for ur Support

source,type,10/12,09/12,08/12,07/12,06/12,05/12

but the above output which iam getting is from dynamic sql

when i execute this --exec @strssql --i am getting that output after which i...

what exactly i need is

today the output of the sp would be

column names

source,type,10/12,09/12,08/12,07/12,06/12,05/12

tommorow it would be

column names

source,type,11/12,10/12,09/12,08/12,07/12,06/12

after which i move this output data into a table in...

create table #temp

(

[source] varchar ,

[type] int,

[10/11]...

Hi eshan this is not a one time process i need to do it evryday so it should take the date itself....