Is it possible there's a leading space in the field including '5687' ?

Try using the following query:

SELECT *
FROM dbo.artran
WHERE Cust_num LIKE N'%5687';

I don't think the sys.dm_exec_procedure_stats view can return a NULL execution_count. It's definition represents that column as non-nullable.

Are you sure you're querying the view correctly? Do you still see...

I think Microsoft's response was wise to extend and adjust their certification platform due to the pandemic. If you're currently in pursuit of this certification track, or even just find...

To stay on the safe side and since you're on SQL Server 2012, you can use TRY_CAST rather than ISNUMERIC here. ISNUMERIC can do some strange things, as Phil Factor...

Hey Carlo, thank you for the feedback! That is the same when working with sets, it's important to look at the...

• This reply was modified 4 years, 7 months ago by  BTylerWhite.
• This reply was modified 4 years, 7 months ago by  BTylerWhite.

It looks like this issue could be due to the use of STR. The optional length argument using STR is 10, meaning it will pad some additional spaces for...

Excellent April Fool's Day post! I'm a tad annoyed with myself that I didn't initially see the "humor" tag on this article. 🙂

I am curious as to what will features...

Hey Jon,

Please see the following article on formatting code for questions:

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

In the meantime, I've replicated your table using the following:

CREATE TABLE #CustomerAccounts
(
   ...

Thanks for the question, Steve! This was a feature I didn't know existed within SSMS before I started seeing it referenced in the QOTD.

Have you created a job executing this package in a step? I know this may seem obvious, but could be missed.

If not, you can try using the following SSISDB stored...

I don't currently work with too many In-Memory OLTP tables, so this is great to know! Thanks for the question, Steve.

I used the following code to achieve the expected result.

DECLARE @FileName nvarchar (256) = N'SVPP_ROYA_00001_00021_7_of_7_20200326_101116.csv';

DECLARE @PatIndex nvarchar (32) = N'%[0-9][_]of[_][0-9]%';

SELECT CONCAT(
      ...

This is quite a tricky task. It also looks like from your provided desired output you want some string aggregation with the CourseIDs. I'm not really sure if a PIVOT...

You'll need to enable 'Ad Hoc Distributed Queries' as a server configuration if it is not already enabled to perform this task using T-SQL.

EXEC sp_reconfigure 'show advanced...

Great question to start off the week, Miles!