Gianluca Sartori (10/3/2011)

---

drew.allen (10/3/2011)

---

You do realize that...

Can any DBA clarify my doubt please???

Thanks in advance..

There will be different meter makers. The data from each meter make will be in different format . They will follow some standard.

Also some times the data from meters...

🙂 of course it is helpful also solved the problem.. that's why i asked you about CTE...

it's useful..thank you..

can you please share some references or pdf's if you have to learn about CTEs and OVER clause..

hi..

sorry for the late reply..

I will explain you clearly.

I have a view which stores the data of all the transactions of all the customers.

My requirement is I should get a...

As the requirement is in real time confidential data base, i can't post the original table structure and data.

So i have given the sample data but the requirement is same.

The...

Sudhir Dwivedi (9/12/2011)

---

Try this in case you are just looking for the count and CustomerIds :

select CustomerId, count(*) RechargeNr from customer_trans

group by customerid

having Count(*)>2 and DATEDIFF(day, MIN(RechargeDate), MAX(RechargeDate))<=5...

Thanks for your reply..

The out put for the script is as below..

Can you please explain why customerid 1 is coming two times???

CustomerIdRechargeDate(No column name)

12011-08-12 ...

Please find the script below..

create table customer_trans

(

customerid int,

rechargeamt varchar(50),

rechargedate varchar(30)

);

insert into customer_trans values(1,'100.00','2011-08-12');

insert into customer_trans values(2,'500.00','2011-08-15');

insert into customer_trans values(1,'300.00','2011-08-12');

insert into customer_trans values(3,'100.00','2011-08-12');

insert into customer_trans values(3,'700.00','2011-08-12');

insert into customer_trans values(2,'100.00','2011-08-15');

insert into customer_trans...

Thanks for the reply..

I tried as create procedure GET_HEIRARCHY_CODE(@str varchar(50),@code varchar(30) OUTPUT)

AS

BEGIN

-----statements

RETURN @CODE;

END

but while executing it is asking to pass value for @code also..

can u pls explain how to do...

Thanks for the reply..

I tried as create procedure GET_HEIRARCHY_CODE(@str varchar(50),@code varchar(30) OUTPUT)

AS

BEGIN

-----statements

RETURN @CODE;

END

but while executing it is asking to pass value for @code also..

can u pls explain how to do...

kumar20 (8/16/2011)

---

try thisSET NOCOUNT ON

DECLARE @score TABLE (

[PlayerId] [INT] IDENTITY(1,1) NOT NULL,

[PlayerName] [VARCHAR](50) NULL,

[PlayerScore] [INT] NULL,

[ScoreDate] [VARCHAR](30) NULL,

[overs] [INT] NULL)

INSERT INTO @score VALUES('sunil',5,'16-08-2011',1)

INSERT INTO @score VALUES('sunil',8,'16-08-2011',2)

INSERT INTO @score VALUES('sunil',13,'16-08-2011',3)

INSERT INTO...

Thank u so much... it's working fine..

This gives complete score in 1st over also in 2nd over. I want the score only in 2nd over.

i.e., difference between 2nd over and 1st over's score.

Also i want to...