We can brute force this using CHARINDEX:

Declare @pDelimiter char(1) = ',';

 Select a.TreePath
      , Level1 = ltrim(substring(v.treePath, 1, p01.pos - 2))
 ...

• This reply was modified 4 years, 7 months ago by Jeffrey Williams. Reason: Added Level6 to the code

Not sure where you got that code - but it is not something I would recommend using.  There is no reason to build up the SQL connection when we have...

Using Invoke-SqlCmd you specify the server instance, the database, the authentication (defaults to windows authentication), the query and the variables.  Fixing up your SQL code - here is how that...

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

Yes - you can use SSRS 2019 and connect to your 2012 instance as well as any other instance in your domain.  Create a new server, install the database engine...

Yes - Windows Update does include SQL Server updates.  Normally they are optional - but it all depends on how you have this setup and configured in your environment.  It...

The DNS CNAME only references the IP address - which is the SQLA to SQLB portion of an instance name.  To resolve the instance name change you will need to...

Interesting - you must have started SQLCMD window and not a DOS command window.  That isn't an option on my Windows 10 system - but doesn't really matter.

Go here: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

Download...

If you are able to run SQLCMD and login - then you should be able to download SSMS and use that to access the system.  You said you were able...

SO I created a table in SQL that has many of the key fields

doc_bu doc_tp doc_filename doc_date doc_type

The doc_filename has the file name that the PS script found, and...

So now you want a column named 'User' with the value 'Total Minutes' - where before it was 'Report' and in your original code is was the user name.  I...

I don't understand what results you want.  Please provide sample data and expected results.

If you have a question on the code, then show which code and your question.

A single query can't return a variable number of columns.    It would have to reflect one column for every month of the year and a total at the...

This is what you had in your original query:

SELECT ISNULL([User],'UNKNOWN') as td,''

That is not a 'dummy' value...but if you really just want a dummy value - then use this:

            
March 29, 2021 at 8:49 pm
            
#3863373

            
            
                                                
        

You could change your function to this:

CREATE FUNCTION [dbo].[fnGetSeconds]
(
@TimeFormatted varchar(10)
)
RETURNS Table
WITH schemabinding
AS
  RETURN
  SELECT (LEFT(@TimeFormatted,2)*3600) +
       ROUND(DATEDIFF(MS, 0, '00'...

I don't understand - your original query had the user - but now...