Viewing 15 posts - 9,151 through 9,165 (of 59,078 total)
I generally use the SQLinForm plugin for Notepad++, works fine for large code sets and most SQL flavors. 😎
With some settings changes, that actually does a fairly good...
June 13, 2019 at 5:40 pm
Why not just create a permanent Tally table? It's probably be useful in other situations. Just wondering...
I actually have both a Tally table and an iTFV that works like...
June 13, 2019 at 3:42 pm
Function MCS_ClarionDateToSQL is just a scalar function: Do you think GetNums is wrong? Thanks for your help!
Yes... it's partially incorrect. It has a real ORDER BY in...
June 13, 2019 at 3:09 pm
Function MCS_ClarionDateToSQL is just a scalar function:
Do you think GetNums is wrong? Thanks for your help!
Yes... it's partially incorrect. It has a real ORDER BY in it. Since it's...
June 13, 2019 at 3:06 pm
IIRC, it was David Poole that said "If you're the first person people come to with database problems rather than the last, you might be an exceptional DBA".
...
June 13, 2019 at 2:30 pm
I have used Poor Man's T-SQL Formatter, in different editors, works nicely. Now I mostly use SQL Prompt, from Toolbelt in SSMS. The SQL Prompt Core,...
June 13, 2019 at 1:59 pm
Thanks for your answer, Jeff. I've already solved the problem.
If you ended up using some other than a "GetNums" or other "Tally-like" function, you still have a problem, provided...
June 13, 2019 at 1:44 pm
This post was previously mistaken for SPAM and removed. It may not have even appeared on the "Active Threads" list. With that in mind, I'm bumping this post for the...
June 13, 2019 at 1:39 pm
Much like Des Norton, I don't see the need for CASE in this case (pun intended).
--===== Create a table of random PeriodID's.
--...
June 13, 2019 at 3:22 am
You can also use the following, which will take care of teh leap year
DECLARE @Year int = 2019;
SELECT PeriodID, EOMONTH(PeriodID + ' 01 ' + CONVERT(VARCHAR(4),...
June 13, 2019 at 3:06 am
thanks for all the posts. I have it now, and it works great. I really appreciate all of you posting these options. As you can tell I am not...
June 12, 2019 at 8:56 pm
So I created a proxy account and gave execute to this user on the xp_cmdshell...
NEVER give a non-DBA privs to execute xp_CmdShell directly. You have the proxy account setup...
June 12, 2019 at 8:51 pm
I was just under the 'Active threads' view/forum. For this topic I saw there was an update, so I clicked on the time of the last update '26 minutes...
June 12, 2019 at 5:56 pm
Break down those barriers! I've been on the opposite side where we have had DBA's who always looked busy and were never interested in what we did unless there...
June 12, 2019 at 5:47 pm
MS have added database diagrams back into SSMS - https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017
Other than Windowing functions, this is one of the best moves MS has ever done. It certainly made my...
June 12, 2019 at 2:12 pm
Viewing 15 posts - 9,151 through 9,165 (of 59,078 total)