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 2 years, 7 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 2 years, 7 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?

I, personally, tend to use the expressions on properties of the connection manager, rather than the tool you are using there.

Did you do as the error suggested? What were your findings? We can't see the expression, or the data types, so you need to give more information here.

So you're trying to dynamically get the columns from the XML and (presumably) dynamically insert that into the appropriate columns? Then you are going to need dynamic SQL; you can't...

Does your XML always have the same nodes?

Unfortunately, I can't run the above, it initially gives an error about the scalar variable @MLID not being declared (more on that later), and then if I do define it,...

Design your tables to be appropriate for the data you need to store. If you need to store things like names, addresses, DOB, and passport Numbers, create all those columns...