Viewing 15 posts - 2,086 through 2,100 (of 8,761 total)
Slightly different flavor of John's fine solution
😎USE TEEST;
GO
SET NOCOUNT ON;
;WITH SAMPLE_DATA(AssetId,LabelId,LabelName) AS
(
SELECT
X.AssetId
,X.LabelId
June 21, 2017 at 3:34 am
Further, using scalar functions to select from a table is going to cause a...
June 20, 2017 at 12:50 pm
June 20, 2017 at 12:44 pm
All the data is there, SSMS cannot display anything after the 0 character but that is a totally different thing😉
😎
June 20, 2017 at 12:39 pm
June 20, 2017 at 3:52 am
June 20, 2017 at 2:22 am
Corrected version without a scalar function
😎
DECLARE @m NVARCHAR(max)= N'\u0633\u0644\u0627\u0645'
;WITH T(N) AS (SELECT X.N FROM (VALUES (0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) X(N))
, NUMS(N) AS (SELECT...
June 20, 2017 at 2:01 am
Eric Prévost - Monday, June 19, 2017 6:35 AMYes, the SSIS packages are run locally through SQL Agent jobs
What are the permissions...
June 19, 2017 at 7:31 am
DECLARE @m NVARCHAR(max)= N'\u0633\u0644\u0627\u0645'
June 19, 2017 at 5:58 am
This is one of those questions where the answer is "it depends", do you need to report from the full content of all the databases? Can you pre-aggregate the extraction?...
June 18, 2017 at 7:31 am
June 18, 2017 at 5:38 am
June 18, 2017 at 3:04 am
June 17, 2017 at 4:26 am
Since we are on the 2012 forum, here is a LEAD version
😎USE TEEST;
GO
SET NOCOUNT ON;
DECLARE @ProductCode VARCHAR(256) = 'Organitation/My Companies/company...
June 16, 2017 at 6:55 am
June 16, 2017 at 6:40 am
Viewing 15 posts - 2,086 through 2,100 (of 8,761 total)