Viewing 15 posts - 1,306 through 1,320 (of 59,066 total)
This will make some people get all scratchy but I use SQL Profiler... usually with a SPID filter.
July 5, 2023 at 6:59 am
Heh... you're seriously going to export SSNs to a file in an unencrypted manner along with all that nice PII. What company did you say you work for?
Just...
July 5, 2023 at 6:41 am
Heh... you're seriously going to export SSNs to a file in an unencrypted manner along with all that nice PII. What company did you say you work for?
July 3, 2023 at 11:32 pm
One comment: I hope the example table isn't an exact replica of your production table, because to use that many columns defined as nvarchar(max) just to be on the...
July 3, 2023 at 6:31 pm
Hi
I have resolved the issue and doesn't need your comment or answer. Your comment is too late.
You just got done saying "I tried your suggestion and I have...
July 3, 2023 at 6:26 pm
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
Viewing 15 posts - 1,306 through 1,320 (of 59,066 total)