Does all this involve data migration too?

Thats too complex.

Really looking forward for your methodology.

Try Below Query!!!

select R.seqNum, r.StartTime, r.price, (l.price - r.price) as Diff

, AVG((l.price - r.price)) over(partition by month(r.starttime)) as average

from dbo.Data R

left join dbo.Data L

on R.seqNum = L.seqNum - 1

+1.

Really a nice question.

A very nice question! This helps a lot!

😀

Hi,

Yeah this is a very straightforward question but in the context of SQL Server. But will be bit confusing to those who work on other RDBMS products...

Hi Livingston,

No, the actual tables are different but the other columns are not significant. The essence of the problem is how to split the Receipt table row based on...

Hi Dwain!!!

Again a lot of thanx for your time and inputs.

I think we are in same line when thinking of a solution.

Here was my solution and you posted almost the...

HI dwain!!!

Could you help me in generating script with CURSOR?

Even with CURSOR it is bit tricky.

I am not able to find a perfect script for different kinds of data scenarios.

HI dwain!!

Thanx for your reply !!!

In fact I did the same thing.

I want an idea to split the the second Receipt ID based on the Balance amount of receipt...

Hi,

I am sorry again ...

Here is the updated output

MemberIDReceiptIDReceiptAmtConsumedAmtBALAmt

11300012001800

2118001600200

312002000

32500020003000

4230002456544

525445440

531200600600

If the premium amount of all members is greater than the total receipt amount then only the above output should display.

Hi Dwain!

Thanx for the reply.

Yeah as I am in hurry , I made copy-paste mistake. Sorry!

Here is the output should be

MemberIDReceiptIDReceiptAmtConsumedAmtBALAmt

111300012001800

21118001600200

3112002000

314500020003000

41430002456544

5145445440

5161200600600

The logic is to consume every receipt based on premium...

HI SQL biggies,

Please help me ! Still nobody replied...!

HI all,

After creating a check constraint using the function , no record is getting inserted...

Please help....

HI MickyT,

Thanks for the reply, the solution gave is partially correct. I want the slab to be checked is From Amount, To Amount , From Year & To...

Try this one !

DECLARE @COLOR VARCHAR(20);

SET @COLOR = NULL

SELECT * FROM TBLCOLOR

WHERE COALESCE (COLOR, '') = COALESCE (@COLOR, COLOR, '');

But its not optimized.