How about this ?

create table #CallCost

(

Phoneno varchar(10),

Duration varchar(15),

Cost numeric(8,2)

)

insert into #CallCost

select '9841645768','00:20:15',20

union all

select '9841645768','00:00:15',1

union all

select '9940272484','00:55:01',60

union all

select '9940272484','00:01:15',2

union all

select '9940272484','00:10:15',10

union all

select '9841645768','00:00:55',1

union all

select '9841645768','00:00:59',20

union all

select '9841645768','00:00:59',20

union all

select '9841645768','00:00:59',20

union all

select '9841645768','00:00:59',20

union...

Steve,

Thanks for your information.

I'm curious as to why you're interested and we certainly don't want people to have a goal of boosting their counts without adding to the site. We...

Please post with more details. You have given only Date ,whether it denotes start date or end date or both.

Bananas in pyjamas are coming down the stairs,

Bananas in pyjamas are coming down in pairs,

Bananas in pyjamas are chasing teddy bears,

'Cause on Tuesdays they all try to catch them unawares!

🙂

or ...

just replace your code to

MIN(isnull(u.ITEM,0)) AS UnitItem

Thanks rbarryoung.

can you tell me what are all those ?

If you want to know more about 'Tally' table, read the following URL.

http://www.sqlservercentral.com/articles/TSQL/62867/

You can do it by using Tally table or master..spt_values table.

I do agree with you, I am also suggested the same way.

Gila,

how...

rbarryyoung,

when will your article published ? i am eagerly expecting your article.

is it a group ? do we need to pay for this group ? Can you explain me the purpose of PASS ?

Jeff is my sql teacher. I have learned lot of things from his reply,forums & articles.

If i did any mistake, whether it may be in sql side or in communication...

But I think PIVOT option is introduced in sql2005 only.

SQL Server 2005 introduces the new PIVOT keyword, however I think it will be a disappointment to most. What people have...