No, there is no syntax to ALTER a table and ADD column only if it doesn't exist, and (presumably) ALTER the column if it does like, for example, CREATE OR...

Wouldn't someone who "outranks" you want to teach you the why along with the...

On Windows, ShareX. I...

Just to prove Grant's statement a little more, here's a quick demo.

So you can see that the first SELECT, which wants rows on or after the current...

Just to prove Grant's statement a little more, here's a quick demo.

So you can see that the first SELECT, which wants rows on or after the current...

This implies that the ownership chain is being broken somewhere; the point of ownership chaining is that you don't need to give explicit access to the objects. Who are the...

How are you getting this query out from the database? Are you, by any chance, copying out of a grid view in SSMS? Is so, do you have Retain CR/LF...

Ownership chaining doesn't work cross database unless the cross database chaining feature is enabled on both databases and the login in question has a user in both database. Cross database...

• This reply was modified 1 year, 10 months ago by  Thom A.

Thank you for the assistance. Do you mean it must be part of the Group By statement/columns, like below(but a new error appears)?

"Msg 2714, Level 16, State 3, Procedure...

So where does this file get the list of tables with the tables that has the column you want to query? How...

I will be honest, I assumed you wouldn't be using an unsupported version of SQL Server, as you didn't state you were....

If you can do this in T-SQL, rather than Powershell, this isn't particularly difficult if I am honest. I use a column name that appears often in one of my...

yeah thinking the script in PS so if needed updated adding more tables to list would be easy to update script rather than having someone having to use SSMS...

Neither of those tables have atransactiondate column though, so the reason you are getting the error is...

• This reply was modified 1 year, 10 months ago by  Thom A.

You've posted this in the Powershell forum, so should we be assuming you want a solution that uses Powershell, rather than T-SQL?