Comic Sans all the way!!!!😀😛

What have you tried?

How do you define Last_data and last_data from 6 month?

Are the backup Start and Backup Finish dates always the same? Do they include times?

sgmunson (1/11/2017)

---

This sounds more like a "presentation" thing. I would suggest you just write a normal query that will have all the data for the server in every...

ZZartin (1/10/2017)

---

There's certainly nothing stopping you from using columns in one able to reference another table without making it an official foreign key. You would just have to rely...

You could replace the zero (in both places) with any other date or value that can be implicitly converted into a datetime. It's helpful to prevent errors when dealing with...

And the resetted row number can be achieved my using modulo.

SELECT *,

(ROW_NUMBER() OVER( ORDER BY SomeColumn) + 499) / 500,

ISNULL(...

jasona.work (1/10/2017)

---

Brandie Tarvin (1/10/2017)

---

BrainDonor (1/10/2017)

---

Winter...

Can you share that code with us?

But i have to implement it using procedure/function with LOOP...

Just pivot your table inside a CTE or subquery (derived table) before joining to the other table.

OK, let's take it slowly.

You have Table1 which is your orders table. You need to be sure you have all the rows needed as defined in your components table which...

Is it really that difficult? There should be a better way to get this information, but I would need to get a complete picture and do intensive research. Definitively not...

Thom A (1/10/2017)

---

Welcome to SSC, however, have you actually asked a question in your above post?

Also, can you supply DDL and DLM statements for your tables. At first glance you...

Bear

skmoh2 (1/10/2017)

---

i have two tables.

Table1

--------

PeggingSKU QTY RDD ComponentAvilable QtyAvlbl Dte Material Available Date

SO1 ...