J Livingston SQL (9/13/2016)

---

ashishkumarrai (9/13/2016)

---

It seems this is not what I am after. I want the filler data to feed to bucket in recursive way and store each recursion. the...

It seems this is not what I am after. I want the filler data to feed to bucket in recursive way and store each recursion. the output should look like:

After...

ChrisM@Work (9/13/2016)

---

ashishkumarrai (9/13/2016)

---

ChrisM@Work (9/9/2016)

---

This should be a step in the right direction:

DROP TABLE #Buckets

CREATE TABLE #Buckets (bucketID INT, FullCapacity INT, CurrentAmount INT);

INSERT INTO #Buckets

VALUES ( '1', 85, 0 )...

ChrisM@Work (9/9/2016)

---

This should be a step in the right direction:

DROP TABLE #Buckets

CREATE TABLE #Buckets (bucketID INT, FullCapacity INT, CurrentAmount INT);

INSERT INTO #Buckets

VALUES ( '1', 85, 0 ) ,

...

Yes, I would like to show all iteration, recursion as well. Final recursion/iteration should look like what you shown.

I think this will not run on SQL 2008, Can we achieve this in 2008?

Posted my problem with all the details and sample data over here. https://ask.sqlservercentral.com/questions/140089/sql-server-2008-cte-bucket-filling.html

Hi

Thanks for the post, really useful. I am working on similar stuff. My problem is the value the above query is using is static. What will be the solution...