Viewing 15 posts - 6,991 through 7,005 (of 59,070 total)
Why not write a query that finds all enabled jobs, makes a list (table of them), and then disable all jobs except for that critical one you're talking about?
May 27, 2020 at 3:12 am
I think this will be a bit more safe... details are in the comments in the code
WITH cteEnumerate AS
(--==== Number each set of rows in descending...
May 27, 2020 at 2:20 am
I need to delete the rows where status = 1
DELETE
FROM TestPO
WHERE Status=1;
?
From your description, it's not at all clear what records you really want deleted. Which record(s) are duplicates?...
May 27, 2020 at 2:12 am
well i remember a time where we used to provide scripts, and then an explanation of what not to do....
Ah, lordy... be careful, Lowell...
It's not that I don't want...
May 26, 2020 at 11:44 pm
Sorry, Brian... I don't know if that came out the wrong way but, to be sure, I didn't mean to make it sound like I was talking about you specifically. ...
May 26, 2020 at 8:01 pm
My take on this is that if you have to ask for scripts to do this, you're probably not qualified to use the scripts. I don't mean that as a...
May 26, 2020 at 6:23 pm
Yes, that's what I've seen on the internet. But I don't believe I have that much space in reality. To convert to GB you would divide by 256, right?
No. ...
May 26, 2020 at 4:35 pm
I know this post is a bit old but...
There's nothing in Table A to absolutely guarantee the correct order of data... that also means there's not going to be anything...
May 26, 2020 at 2:36 pm
Sometimes the ultimate fix is a rewrite of the queries to a more optimal pattern.
Totally agreed... sometimes, it's the only fix.
May 26, 2020 at 1:53 pm
The last 5 or so years I've become very interested in UI/UX. In fact I subscribe to at least two newsletters about it. What's surprised me, a great deal,...
May 26, 2020 at 1:18 am
Heh... you spelled it incorrectly, David... it's not "shiny". Replace the "n" to get the true meaning. 😀
May 25, 2020 at 10:04 pm
Might have even been a "Line#" column so you could verify that no lines were lost during transmission and to also guarantee a sort order if that was important to...
May 25, 2020 at 6:06 pm
Just as a side bar, I generally don't mix meta data (headers/footers/line counts, whatever) in fixed field format files simply because most people on the receiving end have problems dealing...
May 25, 2020 at 4:25 pm
Viewing 15 posts - 6,991 through 7,005 (of 59,070 total)