Jeffrey Williams

Forum Replies Created

Viewing 15 posts - 1,171 through 1,185 (of 6,676 total)

Reply To: Using REVERSE
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 5 years, 2 months ago by Jeffrey Williams. Reason: Added Level6 to the code
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 7, 2021 at 6:37 pm

#3866503
Reply To: parse files in folder

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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

April 7, 2021 at 6:14 pm

#3866488
Reply To: parse files in folder
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 5 years, 2 months ago by Jeffrey Williams.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 6, 2021 at 9:03 pm

#3866103
Reply To: Can SSRS 2019 and SQL Server 2019 access a 2012 SQL Service database

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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

April 1, 2021 at 2:43 pm

#3864441
Reply To: CU

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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

March 31, 2021 at 5:07 pm

#3864104
Reply To: create CNAME in upgrade SQL server

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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

March 31, 2021 at 5:03 pm

#3864097
Reply To: admin account and pwd

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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

March 31, 2021 at 3:49 pm

#3864072
Reply To: admin account and pwd

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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

March 31, 2021 at 2:35 pm

#3864034
Reply To: parse files in folder

Bruin wrote:
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

March 30, 2021 at 7:49 pm

#3863735
Reply To: Dynamic parameter transfer in msdb.dbo.sp_send_dbmail

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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

March 30, 2021 at 3:27 pm

#3863651
Reply To: Dynamic parameter transfer in msdb.dbo.sp_send_dbmail

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.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

March 29, 2021 at 10:45 pm

#3863402
Reply To: Dynamic parameter transfer in msdb.dbo.sp_send_dbmail

The Dixie Flatline wrote:
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

March 29, 2021 at 10:02 pm

#3863395
Reply To: Dynamic parameter transfer in msdb.dbo.sp_send_dbmail
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:
```
Jeffrey Williams

“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll
How to post questions to get better answers faster

Managing Transaction Logs
```
March 29, 2021 at 8:49 pm

#3863373

Reply To: Better Practices for writing this query?

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'...

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

March 29, 2021 at 8:41 pm

#3863372

Reply To: Dynamic parameter transfer in msdb.dbo.sp_send_dbmail

christi1711 wrote:

Hi all,
yes, I got it. Thanks. I only try to remove users and group only by date

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

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

March 29, 2021 at 7:38 pm

#3863350

Viewing 15 posts - 1,171 through 1,185 (of 6,676 total)