On another note, you shouldn't be using double quotes around your field names.  If you want to use anything, you should use open and close square brackets. ...

• This reply was modified 2 weeks, 2 days ago by  kaj.

On another note, you shouldn't be using double quotes around your field names.  If you want to use anything, you should use open and close square brackets.  "[" and...

Not sure if this is relevant, but UTF-8 support was introduced with MS SQL 2019. Is this something you use in either of those two tables?

https://learn.microsoft.com/en-us/answers/questions/1693889/unexpected-truncation-error-when-inserting-from-ut

• This reply was modified 2 weeks, 2 days ago by  kaj. Reason: added link

Agreed, but if query 1 is from server 1 and query 2 from server 2, how do you do the UNION?

I suspect that the OP was hoping to be...

Yes, I saw that as well, but how are the sources different? The OP didn't specify...

Not sure if I understand your problem, but couldn't you use a simple UNION for the Country drop-down list? Something like

SELECT Country
FROM DS_Asia
WHERE Continent = @Continent
UNION ALL
SELECT...

You will have to install the mySQL ODBC driver on your SQL Server and configure it.

Then you can set your remote mySQL server up as a Linked Server. Use the...

If you're not adverse to watching a video, there are several tutorials showing how to read a specific cell range from an Excel sheet available on youtube.com.

For example this short...

One has to laugh, RTO no longer stands for Recovery Time Objective, now it means Return To Office

Those ever-changing meanings of common TLAs are giving me a headache.

Does...

• This reply was modified 4 months ago by  kaj. Reason: Typo
• This reply was modified 4 months ago by  kaj. Reason: context

You misunderstood my suggestion.

Create...

Just a thought...

Depending on your need for data, you might also consider using the system view sys.dm_exec_sessions instead the somewhat unwieldy stored procedure sp_who2 as the basis for your query:

Either

Apologies I seem to have miss read the text way it was being converted.

As you have the job hex in varchar from the substring, converting that to the GUID and...

• This reply was modified 4 months, 4 weeks ago by  kaj.

There isn't really a need to use that scalar function for the conversion.

This will also work:

SELECT t.SPID, t.Status, t.ProgramName, j.name AS JobName
FROM @Table t
LEFT OUTER JOIN msdb.dbo.sysjobs...

Arrgh! At least in my browser the output from my post above isn't rendered correctly, even though I have used the Plain type format and it shows correctly when I...

If you don't want to do a group by pivot, but simply want to place the price in a separate column, something simple like this might work for you:

This reply was modified 4 months, 4 weeks ago by  kaj.


This reply was modified 4 months, 4 weeks ago by  kaj.


This reply was modified 4 months, 4 weeks ago by  kaj.


This reply was modified 4 months, 4 weeks ago by  kaj.


This reply was modified 4 months, 4 weeks ago by  kaj.