Viewing 15 posts - 211 through 225 (of 607 total)
"... since I moved the status bar to the top..."
genius, didn't even know that was possible.
SQL Guy 1 - use horizontal or vertical groups to separate groups of your tabs,...
June 27, 2019 at 12:39 pm
Well, two things. 1 - you can't use dynamic SQL in a view, so you might have to make it a table valued function or something. 2 - perhaps your...
June 27, 2019 at 12:27 pm
You should invest in a call center monitoring package. Perhaps Jim was in the bathroom or at lunch, or working on documentation from a previous call, etc. None of that...
June 26, 2019 at 7:31 pm
You are assuming again (in a development forum) that the user *can* make a change to the structure. You're solving the design of the cart when we can only guide...
June 26, 2019 at 7:24 pm
You can try something dumb like I did, old views and all, like this:
DECLARE @schema varchar(150),@procedure varchar(150),@innerSchema varchar(150), @innerProc varchar(150),@counter int,@maxRows int
SET @schema = 'MMC\something'
SET @procedure =...
June 26, 2019 at 6:33 pm
Ignore Joe, he's not entirely wrong, but grumpy. Why don't you use a CASE and depending on the type, return the column you want?
select d.Id,
...
June 26, 2019 at 6:21 pm
You can't compare anything to NULL, as NULL is undefined, do you need to convert those to current date/time or a future default date to do the comparison? Our system...
June 26, 2019 at 6:15 pm
Do you guys run EVERYTHING that goes into production through QA/UAT, or do you trust some users if they have a proven track record of high scores, and only check...
June 26, 2019 at 6:09 pm
duplicate post, see https://www.sqlservercentral.com/forums/topic/calculate-last-friday-date-with-timestamp-ssis
June 14, 2019 at 12:23 pm
In your dataset, check to see if your results are null, if so, return "No Data Available" or some such in one of your fields in the SELECT. So, for...
June 12, 2019 at 11:51 am
MS have added database diagrams back into SSMS - https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017
25 votes, not even two full months old, and they put it back? since when does that happen?
June 12, 2019 at 11:46 am
I would bet it's displaying where the x,y coordinates would be for that parameter dropdown if your parameter section wasn't scrolled and just took up screen real estate. seems like...
June 6, 2019 at 2:35 pm
oh, and if you went the text output route, you'd want to make sure you picked a font that treats all the characters as the same width, otherwise your "graphs"...
June 6, 2019 at 2:27 pm
yeah, that's a custom image, I suppose you could do that with the padding suggestion and make it just spit out text for the report, just populate a tablix with...
June 6, 2019 at 2:26 pm
yeah, I was trying to find a kinder response than "oof, time to polish up that resume"
June 6, 2019 at 1:42 pm
Viewing 15 posts - 211 through 225 (of 607 total)