There a lot of guesswork on this, but, perhaps...

WITH Groupings AS(
  SELECT DISTINCT s.ID, t.[TYPE], t.BATCH_NO, t.Xml_name, s.bank, s.[name]
  FROM #temp t
    CROSS APPLY...

What is your defining logic that data for HSBC and JPMORGON be in the same result? Is it because of the column with "XML_1_2" in it? Do you define...

On Linux, no. Unfortunately Microsoft are quite far behind for tools on the Linux Side. You do have SQL Operations Studio, which is currently in preview, but it's a long...

2 is a code that the application is returning to SSIS, in this case 7z.exe. Normally, when an application successfully completes it returns the code 0 (which, by default is...

You don't explain what your goal is here, nor do we have any data to work with. All we know is that your code generates an error; this doesn't tell...

If the account is being used by a application, website, etc, then they are service accounts, not System Accounts. Generally, service account passwords aren't set to expire; otherwise, when they...

"it didn't work for me"? What do you mean? Did you get an error, unexpected results? You didn't like what you saw?

Rather than using a SQL query to...

Glad to see Arcanum Unbound is there; Brandon Sanderson is a fantastic author and I couldn't have asked for a better author to finish the Wheel of Time series. He...

This would much more easily achieved using something like SSRS. You can put an expression on the column then, and hide it if the count of the values in the...

With the data you've provided, could you show what you want your expected result set to be?