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,...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
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 =...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
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,
...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 26, 2019 at 6:09 pm
duplicate post, see https://www.sqlservercentral.com/forums/topic/calculate-last-friday-date-with-timestamp-ssis
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
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?
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
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"...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 6, 2019 at 2:26 pm
yeah, I was trying to find a kinder response than "oof, time to polish up that resume"
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 6, 2019 at 1:42 pm
Viewing 15 posts - 211 through 225 (of 607 total)