Honestly, this is why I personally find it easier to just store anything in UTC if I'm ever working with time sensitive data, or multiple timezones (and I...

I'm wondering if you can just replace the stack of case statements with one:

case
   when @OriginalFirstStartDayOfWeek < @NewFirstStartDayOfWeek then @OriginalFirstStartDayOfWeek + 7 - @NewFirstStartDayOfWeek 
...

went with the obvious answer surely expecting to be wrong!

I had to guess since I didn't see "git'er done"

I love the grainy pictures of problems, I send my solutions back in pictures with even lower resolution! Heh maybe I'm just old and cranky but I get a cheap...

You are correct. However, there are multiple schemas (actually too many). So the solution shouldn't really be permitting a single schema.

I am really not sure what the best way...

Excel: enable bad solutions

Access: implement bad solutions that require other bad solutions in order to function

PowerBI: Automate all the bad solutions with a bad process, and call it "data...

I think you can get that behavior with one of those keywords right?

INSENSITIVE

Defines a cursor that makes a temporary copy of the data to be used by the cursor. All...

It takes less than 10 keystrokes to convert a column to text. (Ctrl + space, alt + 1, alt + C, t, t enter)

I'm getting the impression that you...

• This reply was modified 4 years, 5 months ago by  x.

I particularily enjoy pasting dates into excel, sort of like a box of chocolates ...

So you're saying that you are getting less rows in that routine than you expect? You could query separately for a row that should show up but doesn't and then...

But I didn't change the login parameters. So I don't know why is working the 1st...

But I didn't change the login parameters. So I don't know why is working the 1st case and...

reminds me of a story from one of my favorite books, a truly geeky must read in my opinion, "the soul of a new machine" by tracy kidder. they're bringing...

shake up your troubleshooting. don't save one copy of that batch file, fail, then give up. create another batch file. run a hexdump on your batch and look for hidden...