Viewing 15 posts - 1,981 through 1,995 (of 8,731 total)
The reason for the CTE was to include the ORDER BY which isn't available in the simple UPDATE.
October 25, 2016 at 12:42 pm
Check constraints will validate that data in a table follows certain rules.
Error handling will prevent errors from crashing a process by giving the option of following an alternate path if...
October 25, 2016 at 12:34 pm
Thank you for the feedback.
I hope that you noticed the change in the table name. I also hope that you understand the solution and how does it work.
October 25, 2016 at 12:26 pm
I was just going to mention that folder. I'm glad that you were able to attach the db successfully.
Remember that SQL Server has different credentials than your user account. That's...
October 25, 2016 at 12:25 pm
That's great. Thank you for the feedback.
October 25, 2016 at 12:10 pm
Try changing your code to this, there's no need for all that dynamic code:
DECLARE @colsUnpivot AS NVARCHAR(MAX);
DECLARE @query AS NVARCHAR(MAX);
DECLARE @Table_Name as Varchar(200);
DECLARE @transaction_Table NVarchar(500);
SET @Table_Name =...
October 25, 2016 at 12:04 pm
What's the result from this query?
SELECT t.name, c.name, c.is_identity
FROM SCCOE_Order_Progression.sys.columns c
JOIN SCCOE_Order_Progression.sys.tables t ON c.object_id = t.object_id
JOIN SCCOE_Order_Progression.sys.schemas s ON t.schema_id = s.schema_id
WHERE s.name = 'dbo'
AND t.name = 'ATTU_Sales_organization'
AND c.name...
October 25, 2016 at 11:53 am
What's the result if you run this?
SELECT @@VERSION
October 25, 2016 at 11:47 am
It's not including only values from 8.0 to 9.9. It's also not comparing ASCII values.
It's ordering the values as a dictionary would do (but with more characters) and the order...
October 25, 2016 at 11:37 am
Brandie Tarvin (10/25/2016)
trangen1 (10/25/2016)
can I run it without this clearing of the LSG????
'dir -Recurse...
October 25, 2016 at 10:41 am
READ COMMITTED should be enough. I would test, though.
October 25, 2016 at 10:38 am
Why not do it at once instead of using a variable?
CREATE PROCEDURE dbo.GetNextId @Col1 INT
AS
SET NOCOUNT, XACT_ABORT ON;
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
...
October 25, 2016 at 10:23 am
Should I be concerned for this person's info?
October 25, 2016 at 10:09 am
SQL Server will assign the value automatically. Are you sure that the column has the identity property assigned correctly?
At first, I thought another possibility would be having SET IDENTITY_INSERT ON,...
October 25, 2016 at 9:32 am
Functions in SQL don't perform tasks. Functions return values, that's their main purpose in any language.
To perform a process, you need a stored procedure. To update the values in a...
October 25, 2016 at 9:22 am
Viewing 15 posts - 1,981 through 1,995 (of 8,731 total)