Please find the DDL and sample data below.

the requirement is to display the product_ID for the row where the values have changed for the following 5...

Maybe the answer is much simpler...

Will it be the DBA or the Developer that gets woken up at 3:00am because the application is slow/not working?  That person...

You simply do your best. If you are...

I'm not an R enthusiast but if you could tell me what it does, I might be able to help.

Also, doesn't SQL Server now allow diversions to R in some...

SELECT * FROM OPENQUERY([AS400], 'SELECT * FROM AS400.S78359E0.QS36F.INDETLWO')

I do not know much about AS400/DB2 but I think three part naming would be more likely to work with OPENQUERY

            
March 14, 2020 at 2:15 am
            
#3734367

            
            
                                                
        

I'm a bit confused by the first row of your posted desired result...  Is the 4/1/2008 date for the SaleDate just a typo that should have been 1/1/2008 or am...

So an international academic writers conference (ICFA) that I usually am invited to as a fiction writer, and forgot to accept the invite last October, has been cancelled. I...

A lot of people don't even know about it and a lot of people that have been spoiled by other things don't care for it but SQL Server "Diagrams" can...

Simple and Bulk Logged are the same for this type of thing.  You didn't answer the rest...

Thanks! I ran some tests first with clustered index in-place and second with clustered index dropped, load the data and add the  clustered index back . Noticed second one...

I'll give you a...

Aye.  And I'd also like to see them fix the actual code for the ordinal.  All they need to do is change one bloody word in the code...

Heh... Hi!  My name is Jeff.  Grant has a problem with SQL Profiler and I can't fix Grant! 😀 😀 😀

Hold the phone a minute... if this worked on a different instance, you have to ask yourself what changed when you copied it to the new instance if it doesn't...

Aye.  And I'd also like to see them fix the actual code for the ordinal.  All they need to do is change one bloody word in the code and update...