Viewing 15 posts - 1 through 15 (of 179 total)
This is a complete violation of first normal form. It also violates the concept of a tiered architecture.
While that is true, this is a common requirement for medical...
February 21, 2022 at 12:22 pm
Guess the op lost interest.
It also looks like we've had a problem with DBCC TIMEWARP on this thread. The original post was on 14 Dec 2021 at 11:59PM.
Even the...
December 22, 2021 at 12:17 pm
The difference of bad data before and after computers is that bad data in computers can be perpetuated and disseminated so much faster.
And that more people believe the bad data...
November 3, 2021 at 11:39 am
You could use 120 and then replace the dashes, colons and space with ''. Is 3 REPLACE's worse than calling GETDATE twice?
October 22, 2021 at 11:46 am
Alternatively, you can do the logic arithmetic yourself. Change the AND's to OR's, equals to not equals, etc. But that can be tricky, and oftentimes leads to code that is...
August 9, 2021 at 11:25 am
Interesting that a business would defer to an IT person to determine business needs.
There must be someone in your company that is responsible for record retention. That person should make...
June 28, 2021 at 11:46 am
That was my point. Why pay to advertise to me, when I may have already bought their product?
Certainly the advertising program wouldn't know that, unless the company shared their sales...
June 16, 2021 at 2:52 pm
I am somewhat concerned about how much of my online activity is being tracked to target me for ads. Not that I have anything to hide from there. But if...
June 16, 2021 at 11:51 am
There's no value 5 in the table, so that meets the NOT EXISTS condition for value 6. That's why 6 is returned, in addition to 1, 10 and 14.
May 10, 2021 at 11:12 am
It was my second day, not my first, but the boss told me, "OK, put it into production." Wait, what? I was used to creating release packages, not doing the...
April 7, 2021 at 11:28 am
If someone spams a thread that you are getting replies, the spam reply will be sent to you. Vigilance!
March 9, 2021 at 12:14 pm
My comment was partially in jest wrt the quiz, but with some seriousness. I'm not going to remember what to do to find deprecated features. But I will always know...
March 8, 2021 at 6:27 pm
Michaels suggestion was probably this
SELECT[Date] = MAX([Date])
, city
, area
, Status
FROMMyTable
GROUP BY city
, area
, Status
which is a lot more skinny, provided that your code isn't more complicated...
March 5, 2021 at 12:56 pm
Sorry, replied to wrong post - will try again
March 5, 2021 at 12:54 pm
Viewing 15 posts - 1 through 15 (of 179 total)