Viewing 15 posts - 421 through 435 (of 9,715 total)
<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
Best of luck with that test, Brandie. I haven't done it, but I know 2 people who have. One passed and the other missed it be 1 question on...
April 30, 2019 at 5:19 pm
I don't actually feel insulted. It was the way the response was worded with the whole "none of your business" and "you're wrong" comments that made me think the OP...
April 30, 2019 at 2:43 pm
I'm sorry you see my response as insulting. It was not intended that way. I was trying to assist you in understanding what a landmine you are sitting on and...
April 30, 2019 at 2:27 pm
Starting in SQL Server 2012, you no longer connect to Integration Services directly like you would in prior versions. It is now accessible as a node in the connection...
April 30, 2019 at 2:07 pm
You do have to wonder if someone is maybe a little out of their depth trying to use SQL Server, when they post photos (not screenshots) of computer's screen....
April 30, 2019 at 2:03 pm
Viewing 15 posts - 421 through 435 (of 9,715 total)