Viewing 15 posts - 1 through 15 (of 98 total)
"My word is my bond". Great motto, that. No goalpost-shifting allowed.
MarkD
May 12, 2022 at 8:11 am
Hello sipi41
Sorry you have had to wait for your question to be bumped, and hopefully you are still interested in getting an answer!
Bulk insert goes like a rocket, if you...
April 29, 2022 at 8:31 am
Ha, sorted it.
The critical setting was Tools > Options > SQL Server Object Explorer > Scripting > Check for object existence. The option was set to True.
When I reverted it...
February 16, 2022 at 1:38 pm
Nice summary, Ginger, and good analogy about the grocery bag. Helps to bring home the point that shrinking the log file might be a really bad idea.
Personally, I think the...
February 16, 2022 at 10:55 am
Thanks Michael, fair enough.
I'm going to put the extra fields in to start with, but I may rip them out if testing indicates it. At this early stage I can't...
February 10, 2022 at 6:16 pm
Yes Michael, correct. You're right that I could join on the CTRseqNo field and pull the patient ID and review date out of the parent CTRs table.
My thought behind duplicating...
February 10, 2022 at 3:05 pm
I ran Phil's code, and it worked perfectly. As far as I can tell, it is equivalent to what I wrote.
I then re-executed my original code - which also worked...
February 10, 2022 at 2:54 pm
I should have said "Stack Exchange" rather than SO. Stack Exchange refers to the whole group of sites with the same overarching philosophy and structure -- though Stack Overflow was...
February 10, 2022 at 11:38 am
To concur with Kathi, I agree that people need to include their DDL for the sake of context.
My own experience on SO has been a bit mixed. Like Rod says,...
February 9, 2022 at 10:50 am
Sky-diving, anyone?
Ah, yes. If at first you don't succeed, sky-diving is definitely not for you.
MarkD
January 19, 2021 at 2:49 pm
Two - no, three - really instructive answers here.
I think Steve Collins' first suggestion was the sort of thing I had at the back of my mind. That CROSS APPLY...
December 21, 2020 at 10:18 pm
I had the same question, but found the following : https://squaredup.com/content/guides/what-is-scom/
It is a bit sales-y, but has enough technical detail to serve as a starting point.
Disclosure:...
September 10, 2020 at 9:51 am
Sorted it.
Uninstalled both the 32-bit and the 64-bit AccessDatabaseEngine.exe 2016 drivers.
Uninstalled all earlier versions of said drivers.
Reinstalled the 32-bit AccessDatabase Engine.exe 2016 program from the command line using /quiet in...
July 24, 2020 at 5:38 pm
My apologies, Jeffrey. I must have been skimming and missed the question at the end of your post. I just saw it now when I was checking the thread.
The answer...
July 22, 2020 at 6:39 pm
Hi Ken
You have sent out many positive vibes. I am arranging to get them returned with interest.
Can't do much more from way over here, but it's a good start.
Thanks for...
July 7, 2020 at 12:56 pm
Viewing 15 posts - 1 through 15 (of 98 total)