Viewing 15 posts - 1 through 15 (of 26 total)
Not being good at SQL Server != Not being good at your job
Not everyone that uses SQL Server is an SQL Server professional. Do they need to be? Not necessarily....
April 8, 2019 at 11:45 am
December 13, 2018 at 1:38 am
Doesn't sp_executesql work for you? https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-executesql-transact-sql?view=sql-server-2017
December 5, 2018 at 8:20 am
Completely agree with everything you say here.I have lots of pet hates and one of them is the use of dbo schema for everything. One culprit I have encountered...
November 15, 2018 at 1:04 am
Hi,IMO, tone does matter, we are all people ... All people deserve respect and dignity. It is true that some are more sensitive than others. I include myself in that....
May 15, 2018 at 12:23 am
Before I started work in IT I was a postman, what Americans call a mailman (Yes, they were virtually all men then). Originally we were officially called Postal Delivery Officers...
November 1, 2017 at 1:25 am
Fully agree with these sentiments. Omnipotence on its own is not enough to become a "god", you need omniscience and foreknowledge also.
September 26, 2017 at 12:12 am
Kenneth.Fisher - Wednesday, August 16, 2017 7:07 PMAttached is the word doc version for those that want it.
August 17, 2017 at 12:06 am
By special request then, can the crossword be supplied as HTML instead of an image and have text boxes for each letter! All you need is a table...
August 16, 2017 at 7:18 am
HiWhat's the easiest way of filling the crosswords in short of printing it out?
August 16, 2017 at 1:51 am
Hi,Yes lets take full advantage of meaningful extension names; EXCEPT when there are long established conventions, e.g. txt, csv etc. I certainly would not want to see comma-separated-values as...
July 17, 2017 at 1:43 am
The primary key is fine.An index on LastUpdated is appropriate as suggested. But wouldn't a RANK WITH TIES be more accurate that a TOP 1?
January 18, 2017 at 12:25 am
January 16, 2017 at 2:28 am
Would this work?WHERE YEAR(Invoice_Date) = YEAR(GETDATE()) - 1 AND MONTH(Invoice_Date) = MONTH(GETDATE())
WHERE YEAR(Invoice_Date) = YEAR(GETDATE()) - 1 AND MONTH(Invoice_Date) = MONTH(GETDATE())
January 16, 2017 at 12:28 am
I bin robbed!:crying:
December 30, 2015 at 5:14 am