Viewing 15 posts - 1,306 through 1,320 (of 59,061 total)
Jeff, Perfect ! thanks so much for the help, I will run with this and see how it goes when moving to the next month.
but this looks great.
Thanks for...
July 3, 2023 at 5:18 pm
p.s. I fogot to do the exclusion if the start of the run is in the month before the end of the run. That's easy to do but let's first...
July 3, 2023 at 4:22 am
Ok... the following provides what you asked for. Give me 3 more Office names and I'll give you what I think they'll ask you for in the future and it'll...
July 3, 2023 at 4:14 am
I'll also tell you why sys.sp_sequence_get_range will disappoint. The only thing it does is give you the first value and reserves the rest of the values. If you want those...
July 3, 2023 at 2:13 am
I'll look into the sys.sp_sequence_get_range SP as I've seen someone said it is thread safe. This may be a good solution. (if thread safe)
Looking at it from a...
July 3, 2023 at 12:02 am
No answer... Ok then... good luck! 😉
July 2, 2023 at 11:43 pm
Post removed.
July 2, 2023 at 11:38 pm
What's the max oven number and what do you want to count if a "run" straddles the last day and the first day of the month? For example, do you...
July 2, 2023 at 11:25 pm
With the aim to help get rid of that Cursor/While Loop and remove some "rust" in the process 😀 , what does the CA4 column contain.?
July 2, 2023 at 8:18 pm
I am trying to add week number by month so Feb would have weeks 1 -4, March 1-5 etc.
To be sure, the reason why I'm asking questions is because...
July 1, 2023 at 4:47 pm
I apologize... This slipped off my radar. Hopefully, you found an answer but I notice that you updated the question a day ago.
To be honest, I'm not sure, from your...
July 1, 2023 at 3:13 pm
Just curious... did it work for you after my clarification above?
July 1, 2023 at 3:40 am
Well, we solved it.
To summarize, everything with the actual migration worked perfectly except for one thing (ok, call it two.. I bunched it together as "comms with other machines"). Neither...
July 1, 2023 at 12:12 am
Thanks, Frederico. One of the other ones I looked at said to change all the code to use a name and password. The one for Pinal Dave with the download...
June 30, 2023 at 6:10 pm
What I'm getting at is that if users at the end need to make changes for reporting or whatever, there is something seriously wrong with the source of data and...
June 28, 2023 at 8:13 pm
Viewing 15 posts - 1,306 through 1,320 (of 59,061 total)