Viewing 15 posts - 1 through 15 (of 200 total)
Thanks to both of you. I have amended the query using OUTER APPLY (which I've only rarely used before) and that works fine.
December 13, 2023 at 8:44 am
Ah thank you Steve. Every day is a school day, particularly for me - my lesson here is to read the actual error message!
November 8, 2023 at 5:03 pm
I don't agree with this. I ran the code in my sandbox and it returned
Msg 2749, Level 16, State 3, Line 6
Identity column 'InvoiceID' must be of...
November 8, 2023 at 8:46 am
I don't use "tooling" - just SSMS and touch-typing for me. I remain unconvinced by the arguments for aliasing, but as I'm 66 and retiring in a few months I'm...
July 13, 2023 at 7:09 am
standards - and for those that do work a lot on this and use tools to help with coding, putting the alias can be automatic, and expanding the columns...
July 12, 2023 at 10:59 am
Why write this:
SELECT TOP 10
s.stateid,
s.statecode,
s.statename
FROM webapi.states AS s;
when you could save yourself some typing and write:
SELECT TOP 10
stateid,
statecode,
statename
FROM...
July 12, 2023 at 9:06 am
Which JSON related function returns a table?
The question suggests a singular answer. The best and most correct singular answer is, surely, OPENJSON().
June 19, 2023 at 8:00 am
It's been mentioned to me that it might be a by-product of the PC going into stand-by mode; previously I've merely locked my PC overnight or when I'm away from...
June 16, 2023 at 8:21 am
Imo it depends on whether or not Approved is exactly equivalent to Taken. Could a user be officially approved and yet not take the day? If there's an...
March 15, 2023 at 8:07 am
Thank you. An interesting article indeed.
March 15, 2023 at 8:05 am
Thanks everyone. As I said in my original post, instinctively I felt that this was a "no-brainer" but I'm now content to proceed with the current model (not that I...
March 7, 2023 at 8:50 am
The heuristic is that if the Status = Approved AND Date < Today then it is accepted as Taken.
I apologise if I didn't make myself clear: I'm not suggesting an...
March 6, 2023 at 1:03 pm
The columns were permitted to be null for good business reasons. I know that there are two (or possibly more) schools of thought about using null as a meaningful value,...
February 17, 2023 at 8:23 am
Thank you Ken - that works a treat!
February 16, 2023 at 1:53 pm
Viewing 15 posts - 1 through 15 (of 200 total)