I think the following code

(LOTHIST.TransDate) > GETDATE()- 90

should be

(LOTHIST.TransDate) < GETDATE()- 90

Also, the parens around LOTHIST.TransDate are completely unnecessary.

Drew

yb751 (6/1/2016)

---

This MIGHT work but I'm not sure since I'm having a hard time understanding your requirement and I have a feeling your example data set isn't reflective of what...

marcossuriel (5/31/2016)

---

Hello Drew,

I replaced the variables with my table names (which are saved and contain data) on my SQL Server, but it does not work. I get "Invalid object name"...

I never use query designer, because I hate the code that it writes.

Drew

marcossuriel (5/31/2016)

---

Hello Drew,

Thanks for your reply. I see that your code starts with:

;

WITH

I'm getting an error saying that the variable, is some of your code missing?

Also, I included the...

Even though you said that you attached desired results, I'm not seeing them. Would the following work?

;

WITH LotHistOrdered AS (

SELECT *, ROW_NUMBER()OVER(PARTITION BY lh.LotNo ORDER BY lh.TransType DESC, lh.TransDate...

Why do you want to skip the first row in subsequent tables?

Drew

In SQL 2008, you would use RAISERROR rather than THROW. RAISERROR is being deprecated, so you should use THROW if you are on SQL 2012 or higher.

Drew

PS: If you...

The reason that we ask for sample data and expected output, is because it is often very difficult to describe in words what you are looking for. Your description...

I think it would be better to approach this as combining the tables into a single output and then applying the OFFSET/FETCH to that single output.

SELECT *, 1 AS table_num

FROM...

Looking at your queries, it looks like you may not realize that you can join to the same table multiple times as long as they have different aliases.

SELECT *

FROM Join_Details...

Please provide sample data and expected results as indicated by the link in my signature.

Drew

Yes, return a NULL and let the presentation layer deal with displaying 'N/A' when the field is NULL. It is best to leave this type of formatting to the...

I'm going to be there and both WayneS and...

It's going to complain about the Month...