What is OPEN_QUERY? I can find it in relation to Oracle, but are you talking about OPENQUERY?

I tested using a column list insert with OPENQUERY with a linked server. If...

Are they looking for columns that are entirely null? or not null, but entirely populated by a default value?Or columns that are not referenced by code?

Yeah it’s meant to be datafin as d, but you’re right. If the newdata only has changed or new data then there is no need to compare the dates either...

Are you sure? I struggle to understand cursors ate the best of times, but I think the set based solution might delete...

Maybe it is for consistency among aggregates, they always return something and sometimes the answer is NULL.

Why should the MAX() behave differently because the COUNT() is also present?

            
March 1, 2023 at 7:34 pm
            
#4155603

            
            
                                                
        

If you just run a select on the child table, the sum returns a row with a null, but the select returns nothing. I assume the cross apply is picking...

What is the data type of PJM.PipeJoinMethodId ?

If it is numeric, the value column from the table variable will be implicitly converted to be compared with it.

If the value column...

Is there no clustered index?

Do I understand correctly? If Subtable is empty you want to delete the Orders table completely, but if there are rows in Subtable you want to limit the deletes to...

QDS does continue to watch the queries that are stored in the it's table, letting you know how they are performing. If you don't want any other ones, this...

I am not familiar with table adapters in SSRS. Do you have to specify a source database type? The error message mentions MySQL which suggests the source is MySQL, or...

This looks like valid syntax for MySQL, but am I correct thinking you want this code to run against SQL Server? I created some tables to test the code and...

• This reply was modified 2 years, 7 months ago by Ed B.

I have no answers, only questions. Is there anything unusual about this partition? Is it the open time period partition of a fact? or is it much larger than other...

This has the same output, what have I missed?

Msg 515, Level 16, State 2, Line 6

Cannot insert the value NULL into column 'myid', table 'database.dbo.NotNullTable'; column does not allow nulls....

I doubt this is the cause, but is is advised not to name procedures with the sp_ prefix. This is reserved for system stored procedures. I have read there is...