Please disregard this post.

I just noticed I queried a different table. It worked. Thank you all.

Good question Jeff.

I let SSMS generate the code to print the TOP 1000 records. There are over 100 columns in the table so here is the code after removing most....

Thanks Luis. No triggers.

I appreciate your time to help me with this challenge. Please be patient since I am a rookie. I have never intentially created a trigger since I honestly do not...

I don't believe there is a trigger. How can I find out for sure?

I did remove the GROUP BY and and achieved the correct result. My original post shows a 2nd script without GROUP BY.

In this case SKU and UPC are the same and therefore its usage is correct. However my challenge is that there may be more than 1 record that meets this...

Thanks. I do have a problem with the output but I thought it might be related to using OR with the FROM clause. I will keep looking.

I knew there had to be a better way other than complicating the script with dynamic sql.

Thank you.

All input was very helpful. Thank you.

My intent is to retrieve the last 5 records in the table by first sorting the table in descending order:

ORDER BY

ROW_NUMBER() OVER(ORDER BY RETAIL_SALES.YR

,RETAIL_SALES.MO, RETAIL_SALES.WK ASC) DESC

Now the bottom 5...

Here is the entire script:

create table #tblFiscalWk

( YR int,

MOint,

WKint,

YR_WKint,

sqlidint

)

INSERT INTO

#tblFiscalWk

SELECT TOP 5

RETAIL_SALES.YR as YR

...

Thank you for the quick reply.

I am embarrassed to say that the variable is declared as @Style varchar(10). Sorry for bothering you. Have a great day.

The remote location needs to function in real-time. If a change is made to a customer record at one location, the other location should see it a instantaneously.