How can we help you today? How can we help you today?
MattB_SCA
Activity overview Badges (0) Posts (1) Comments (2)

Comments

Sort by recent activity
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
  1. Community
  2. SQL Prompt
  3. SQL Prompt Smart rename is not finding dependencies.
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 ...
0 votes
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
  1. Community
  2. SQL Prompt
  3. Apply style on Partition by clause - aligning order by
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...
0 votes
Total activity
5
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2