Activity overview
Latest activity by MattB_SCA
I'm seeing it in both areas. The creation part shows nothing expect the table the column to be renamed is in and Dependencies shows no dependant objects, even though they exist. Once created, the script only mentions the table the column is in, but no dependencies.. / comments
I'm seeing it in both areas. The creation part shows nothing expect the table the column to be renamed is in and Dependencies shows no dependant objects, even though they exist. Once created, the ...
SQL Prompt Smart rename is not finding dependencies.
SQL Prompt Smart rename is not finding dependencies. Is SQL Dependency tracker required for this or should SQL Prompt stand-alone do it?I've used it before in a previous workplace where the whole S...
Thanks for the response Jessica. I can now get it to: ,Row_Cnt = ROW_NUMBER() OVER (PARTITION BY A.part ORDER BY A.PDate DESC)which is better than the ORDER in the left column, but ideally I'd like the ORDER aligned under the PARTITION ,Row_Cnt = ROW_NUMBER() OVER (PARTITION BY A.part
ORDER BY A.PDate DESC)
Matt / comments
Thanks for the response Jessica.I can now get it to: ,Row_Cnt = ROW_NUMBER() OVER (PARTITION BY A.part ORDER BY A.PDate DESC)which is bette...