Forum Replies Created
Viewing 15 posts - 436 through 450 (of 506 total)
-
RE: when creating FK constraint get error 'statement conflicted with [an existing] the FK constraint'
If you can't create the constraint, there must be data that violates it as Gail said. (BTW Gail, nice B-5 quote from the Rangers)
select j.*
from... -
RE: What does the $ mean in this calculation?
When I just select $60:
It looks as though it casts it as smallmoney. -
RE: How to get row values as column values in a table
Try:
DECLARE @tblcalculate table( Hardness numeric(5,1), Tower int);
INSERT @tblcalculate
( Hardness, Tower)
VALUES
( 1.2, 1 )
, ( 2.2, 2 )
, ( 3.2, 1 )
, (... -
RE: Database encription - deny access "with execute as" clause
revoke impersonate on user::privileged_user to group_of_unprivileged_users; -
RE: sp_send_dbmail Dynamic load of 'File Attachments' errors with "Attachment File is invalid"
Is S: a mapped drive or a local drive? Is this run as a SQL Agent Job? If so, does the account it runs under have permissions on that path?...
-
RE: Advice on creating unique clustered index
"All clustered indexes are unique" is not a true statement. A clustered index is any index you create as clustered, and the table is stored, at least logically, in... -
RE: Hierarchical data :skipping child rows up to the parent
Please read this and re-post as suggested.
http://www.sqlservercentral.com/blogs/spaghettidba/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/ -
RE: Performance degraded after migrating to 2016 from 2012
Try running update statistics on the tables preferably in an off peak usage period?
EXEC sys.sp_MSforeachtable @command1 = N'UPDATE STATISTICS ?', @replacechar = N'?'; -
RE: THROW won't continue a while loop
Leave off the Raiserror function and maybe add logging to a table instead.
-
RE: Find highest number in a column of strings
CREATE TABLE dbo.strings(string char(6), number AS Cast(RIGHT(string, 3) AS smallint) PERSISTED);
GO
CREATE CLUSTERED INDEX idx_strings ON dbo.strings(number);
INSERT dbo.strings
(string)
VALUES
('ABC348')
,... -
RE: XML to compare two rows is slow when dealing with large sets
Parsing large XML data sets is very expensive. You would get the fastest results putting the data into in memory tables, that would be fastest if you have Enterprise edition...
-
RE: t-sql 2012 calculation
SELECT Count(Distinct [State ID])
, CASE WHEN [State ID] IS NULL OR [State ID] = ' ' THEN 1 ELSE 0 END InvalidStateId
FROM CImport; -
RE: Running Total
Sorry, missed that:
This works in 2008:
IF Object_Id(N'tempdb.dbo.#mytable','U') IS NOT NULL
DROP TABLE #mytable;
GO
CREATE TABLE #mytable (
ID int IDENTITY,
PartNum... -
RE: Running Total
DROP TABLE IF EXISTS #mytable;
GO
CREATE TABLE #mytable (
PartNum varchar(50),
DueDate datetime,
RequirementFlag tinyint,
Quantity decimal(22,8));
GO
INSERT INTO #mytable (PartNum, DueDate, RequirementFlag,... -
RE: How to join these tables together
The answer is 42,
Viewing 15 posts - 436 through 450 (of 506 total)