Viewing 15 posts - 151 through 165 (of 8,731 total)
Quoting is a big challenge with styling and code. Really, I'd urge you to avoid hitting quote every single time. In this thread, it is often helpful, but...
April 26, 2019 at 1:56 pm
Here's the link to the screen photo thread if you're in need of a good laugh: https://www.sqlservercentral.com/forums/topic/connection-to-integration-service-failed
You don't even need to use the Print Screen nowadays. You can use...
April 24, 2019 at 8:57 pm
Thanks Luis, yes I see that I had forgotten to move the cursor forward. I added that and it now performs the transaction. Just curious what you mean by ...
April 24, 2019 at 8:29 pm
You do have an infinite loop going on, but you also have some other problems. I would suggest that you change your trigger to allow you to handle multiple rows...
April 24, 2019 at 6:33 pm
According to what I understand, your query actually gets the correct results but it needs to be optimized for performance? You don't need to get the number of days from...
April 18, 2019 at 7:28 pm
However, if they spend even a second of time considering that as a problem before they fix attachments to posts/articles and links to the rest...
April 18, 2019 at 4:23 pm
MySQL and SQL Server use different methods to execute dynamic code. This is a forum for Microsoft SQL Server, you would get better help on a MySQL forum.
April 18, 2019 at 1:14 pm
Well, crud... I resurrected an old "Passport" disk and found my old animated "Death Star" explosion of rebar but the new forum apparently doesn't support animated GIFs. Had to...
April 18, 2019 at 1:07 pm
It's live now. A problem with some status not moving on auto publish, but the Corgi Contest is out: https://www.sqlservercentral.com/forums/topic/canine-corgi-completion-contest Not a great way to start a...
April 15, 2019 at 8:22 pm
I'm heartbroken here. The Corgi Completion Contest "discussion" hyperlink leads to the article on data compression (https://www.sqlservercentral.com/editorials/data-compression-double-take). <sniff><sniff>WAAAAAGGHHHH! @=(
Maybe the contest is to actually find the thread.
April 15, 2019 at 3:17 pm
Could it be that the statistics are not up to date?
April 15, 2019 at 3:16 pm
I think in most cases companies try to put double duties on SQL Developers and now they have to do administrative work. It is definitely in my company,...
April 15, 2019 at 1:52 pm
Good luck finding a thread like "Today's random word". Was going to go there and post something but the search can't seem to find it.
I don't seem to have...
April 12, 2019 at 8:55 pm
Have you tried converting the column type into a string? I'm just getting this out of memory, but it should be defined in the Excel Source Editor in the Columns...
April 12, 2019 at 4:16 pm
Here is a testament to something. I released a web application used only internally in October of 2010. This is an HR thing used to capture annual reviews for...
April 11, 2019 at 9:28 pm
Viewing 15 posts - 151 through 165 (of 8,731 total)