Forum Replies Created
Viewing 15 posts - 61 through 75 (of 506 total)
-
RE: SP with dynamic sql parameters
You are defaulting @criteria to null so null concatenated with any string is null.
-
RE: EXCEPT operator problem
UPDATE a SET
a.Address1 = b.Address1
, a.Address2 = b.Address2
, a.city = b.city
, a.stateAbbrev = b.stateAbbrev
, a.phoneNumber = b.phoneNumber
, a.email = b.email
,... -
RE: SPROC that queries another DB permissions issue
GRANT IMPERSONATE ON USER :: [login with adequate permissions] TO [login with inadequate permission]
ALTER PROCECURE MyProc
EXECUTE AS 'login with adequate permissions' -
RE: Monitoring slow running queries of different variety of SQL Server versions without any 3rd party tool.
Look at the reports included in SSMS. Right click the server and choose Reports_>Standard Reports
-
RE: Create a specific Pivot Table from a table output table
SELECT
Min(o.HistoryDateTime2) BegDt
, Max(o.HistoryDateTime) EndDt
, o.IndicatorID
, o.HoldingID
FROM #OutputTable o
GROUP BY o.IndicatorID
, o.HoldingID;
-
RE: Strange Agent job failure
Is the email coming from the package?
-
RE: Capture Foreignkey Constraint via Trace?
You could create an after delete trigger and insert deleted into a delete history table. You could add a column for SUser_Name() to track who made the delete if they...
-
RE: Capture Foreignkey Constraint via Trace?
What version of SQL server are you using?
-
RE: Capture Foreignkey Constraint via Trace?
SELECT
f.name ForeignKey
, OBJECT_NAME(f.parent_object_id) TableName
, COL_NAME(fc.parent_object_id, fc.parent_column_id) ConstraintColumn
, OBJECT_NAME (f.referenced_object_id) ReferencedObject
, COL_NAME(fc.referenced_object_id, fc.referenced_column_id) ReferencedColumn
, delete_referential_action_desc ... -
RE: Run query against for all DB on monthly basis
Use SSIS and schedule a job to run it.
-
RE: Init-cap the characters in SQL server
USE Jic
GO
CREATE TABLE dbo.abc (Month_Name nvarchar(10) NOT NULL PRIMARY KEY)
GO
INSERT dbo.abc ( Month_Name )
VALUES (N'APRIL')
, (N'AUGUST')
, (N'DECEMBER')
,... -
RE: Init-cap the characters in SQL server
USE Jic
GO
CREATE TABLE dbo.abc (Month_Name nvarchar(10) NOT NULL PRIMARY KEY)
GO
INSERT dbo.abc ( Month_Name )
VALUES (N'APRIL')
, (N'AUGUST')
, (N'DECEMBER')
, (N'FEBRUARY')
, (N'JANUARY')
, (N'JULY')
, (N'JUNE')
,... -
RE: Select Query Assistance (Comparison)
SELECT pcs.MACHINE_NAME
October 5, 2018 at 3:00 pm
Viewing 15 posts - 61 through 75 (of 506 total)