Viewing 15 posts - 706 through 720 (of 754 total)
I don't know of a built-in way, nor an addin, that supports that. Seems like a useful option.
Here's an azure feedback suggestion you can vote on: https://feedback.azure.com/forums/908035-sql-server/suggestions/42237427-add-parameters-and-variables-to-configurable-fonts
December 17, 2020 at 4:50 pm
GROUP_ID is a complex element composed of attributes. Value is an attribute of GROUP_ID, not an element.
Try this:
select
pt.id,
x.y.value('@Value','int') AS...
December 16, 2020 at 9:20 pm
The following seems to work. Add TRIM() if desired fix space before comma.
DROP TABLE IF EXISTS #attributes
CREATE TABLE #attributes
(
Attributes...
December 16, 2020 at 9:04 pm
I'm guessing it didn't.... You still aren't returning CALL_TIME in the subquery, but are trying to reference it in the pivot.
I believe that in your select, you would need to return...
December 14, 2020 at 9:43 pm
Your subquery is not returning TraceyHarley5, RhonaCornwall5 , or CALL_TIME, so the select, function, & PIVOT have no reference to those columns. And the only columns in your subquery --...
December 14, 2020 at 5:58 pm
Sample data that is failing? It sounds like perhaps you have a @TimeFormatted value that is only 1 character.
DECLARE @TimeFormatted varchar(max) = '2'
SELECT RIGHT(@TimeFormatted,LEN(@TimeFormatted)-2);
Do you really have...
December 4, 2020 at 3:29 pm
It depends:
December 2, 2020 at 11:44 pm
How much total memory does each machine have? What are the minimum & maximum memory settings in SQL Server (right-click the server in SSMS & select Memory)?
Do servers only have...
November 24, 2020 at 3:20 pm
Bare metal or VMs?
Network specs?
Where is the file? Local hard disk/SAN/other? Are the drives configured identically? Have you benchmarked/ & compared performance for the drives from which you're pulling the...
November 24, 2020 at 2:10 pm
"If it's so bad, Microsoft will improve on it, just as Microsoft fixed the notorious message 8152, "String or binary data would be truncated" for SQL 2016 SP2(+CU?) or later."
So...
November 18, 2020 at 2:04 pm
I used the below, which calls 1 million times (required catch block to be executable), and couldn't get a null (I assume that's what you meant by not always returning...
November 16, 2020 at 2:36 pm
Previous Generation Instances lists i2 and r3 instances.
November 11, 2020 at 2:03 pm
This should generate alter statements without using a cursor.
You will probably need to filter out system tables. Print to see the results before executing. If you can do it reliably in...
November 10, 2020 at 11:06 pm
Viewing 15 posts - 706 through 720 (of 754 total)