Viewing 15 posts - 3,811 through 3,825 (of 59,067 total)
Even after participating in forums for more than 2 decades I guess I'll never understand why people post and then never answer a simple question asking a a small example...
March 2, 2022 at 6:02 pm
You are probably right Jeff, the actual use case is to log specific query executions to a table...but now you've got me thinking of other potential ways...🤔
It's partly for...
March 2, 2022 at 5:25 pm
It would be really helpful if you could include an ACTUAL Execution Plan (as opposed to an Estimated Execution Plan). See the article at the second link in my signature...
March 2, 2022 at 5:20 pm
My current plan is to keep the ID field and my current indexes because it is working fine.
Then I will probably make a copy of the table and try...
March 2, 2022 at 5:05 pm
I normally do try. I even violated my own decision to "black ball" someone last night and tried to figure out what the heck it was they were...
March 1, 2022 at 8:20 pm
I normally do try. I even violated my own decision to "black ball" someone last night and tried to figure out what the heck it was they were talking about. ...
March 1, 2022 at 5:12 pm
I've found that a lot of people are using XE to do a lot of things that SQL Server already does better than you could do it with XE. With...
March 1, 2022 at 5:04 pm
Another way
SELECT C.x.value('@Id', 'varchar(20)') as Id
,C.x.value('@ChapterName', 'varchar(20)') as ChapterName
,C.x.value('concat(local-name(parent::*/parent::*),"\",local-name(parent::*),"\",local-name(.)) ', 'VARCHAR(1000)') AS [Path]
FROM @doc.nodes('ROOT/*/*/item') as C(x)
You've helped a great number of people with sometimes some...
February 28, 2022 at 10:12 pm
Since there's no sample data, if the date is the only thing in the string, find the first occurrence of a digit and the last occurrence of a digit and...
February 28, 2022 at 9:50 pm
At least they live up to the name of this thread. 😀
February 28, 2022 at 9:45 pm
how to give logic for it. I am newbie
Heh... no you're not. According to the date of your first post, you've been working with SQL for nearly 2 years. ...
February 28, 2022 at 9:30 pm
The STRING_AGG() function, available in SQL Server 2017 and up, makes this a pretty easy task along with a very useful tool that originates from this very site. You could...
February 28, 2022 at 7:50 pm
I'm trying to extract date from a text field. I'm using PADINDEX to do this. My results are very inconsistent. Is there anyway I can do this through SQL. ...
February 28, 2022 at 6:25 pm
There are several people that I've recently decided are earning a living based on the kindness of strangers that I will no longer help especially since they've been doing the...
February 28, 2022 at 5:56 pm
(Although the product ID is correctly an NVARCHAR and I'm hoping the NVARCHAR isn't actually a part of the column name 🙁 )
Hmm, I think it's a waste...
February 28, 2022 at 5:48 pm
Viewing 15 posts - 3,811 through 3,825 (of 59,067 total)