Viewing 15 posts - 421 through 435 (of 9,720 total)
Wow. So apparently I learn something new every day with SQL Server. Yesterday, I accidentally learned that if you highlight a section of code in a SSMS query...
May 8, 2019 at 1:28 pm
Sorry I didn't have a chance to respond yesterday. It was very busy at work.
But yes, that's exactly my problem. What Sue said and what you posted.
May 8, 2019 at 12:25 pm
Yeah, I saw someone post about that one several months ago and I've been using it ever since.
Previously we'd been doing that in UltraEdit. It was nice to know I...
May 8, 2019 at 10:56 am
Wow. So apparently I learn something new every day with SQL Server. Yesterday, I accidentally learned that if you highlight a section of code in a SSMS query window and...
May 8, 2019 at 10:16 am
Thank you all for your responses. I'm choosing not to go with either of the additional solutions because I'm trying to cut down the code I have rather than add...
May 7, 2019 at 3:31 pm
<headdesk>. Wow. How did I miss this?
SELECT DATEDIFF(hh,CONVERT(DATE,GETDATE(),120),CONVERT(DATETIME,(RIGHT(LEFT(SubDirectory,LEN(SubDirectory)-8),8))))
+ DATEDIFF(hh,CONVERT(TIME,GETDATE()),CONVERT(TIME,(SUBSTRING(Subdirectory,20,2) + ':' + SUBSTRING(Subdirectory,22,2) + ':00.0000000'),120)) AS HrsAged, Subdirectory
--INTO #PurgeBackups
FROM #DirTree;
And apparently I can't bold the changed parts...
May 7, 2019 at 1:42 pm
My database is too large. Restoring headers takes far too long for this operation. I need it to be quick. The code above completes in less than a minute.
May 7, 2019 at 1:37 pm
I down voted everything on that post. None of the people involved including the original poster, the two people that posted the answers, the idiot that edited the original...
May 7, 2019 at 1:19 pm
Can you please post the DDL for the tables and the sample data? IE, table creates and inserts for the sample data.
It's mighty hard to read the images you've inserted...
May 7, 2019 at 12:24 pm
I don't have a Stack Overflow account, let alone a 50 rep on the site. Since the topic is still open, maybe could someone able to post to the site...
May 6, 2019 at 2:15 pm
Annnnnddddd...
Because I just realized y'all are going to ask.
May 6, 2019 at 1:34 pm
Yesterday night, a job failed with a weird error I'd never seen before. I hop onto Google this morning to search for it and find all sorts of interesting responses....
May 6, 2019 at 1:32 pm
Does she have a business case for changing the data sources? Or did she just do it because that's what she knows?
May 1, 2019 at 10:06 am
You *can* connect using the legacy Integration Services connection in SSMS, but only for packages that are deployed to MSDB. I rarely see packages deployed to MSDB in 2012...
May 1, 2019 at 10:04 am
From what I understand of the CISSP, the exam is a "lawyers" exam more than it is a "tech person's" exam. That's what makes it so difficult for a lot...
April 30, 2019 at 5:39 pm
Viewing 15 posts - 421 through 435 (of 9,720 total)