Viewing 15 posts - 2,266 through 2,280 (of 8,760 total)
WayneS - Tuesday, April 4, 2017 11:37 AM
Congratulations!!! Well done and well deserved!
😎
April 5, 2017 at 1:56 am
April 4, 2017 at 7:20 am
March 31, 2017 at 11:22 am
I have two questions. I just restored a full backup into norecovery from a...
March 31, 2017 at 9:42 am
March 31, 2017 at 8:58 am
The query that we ran:
March 28, 2017 at 9:11 am
We just moved from SQL Server 2008 R2 32 bit to SQL Server 2014 64...
March 28, 2017 at 6:42 am
A quick test harness and a set based method to play around with
😎
USE TEEST;
GO
SET NOCOUNT ON;
DECLARE @NUM_ROWS INT = 100000;
;WITH...
March 28, 2017 at 1:26 am
Slightly different method
😎
USE TEEST;
GO
SET NOCOUNT ON;
DECLARE @NUMLIST TABLE
(
NM_ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED
,SKU BIGINT ...
March 27, 2017 at 9:43 am
This might get you started
😎
SELECT
PROP.DATA.value('local-name(../.)','VARCHAR(100)') AS Parent_element
,PROP.DATA.value('local-name(.)','VARCHAR(100)') AS Element
,PROP.DATA.value('(@*)[1]','VARCHAR(100)') AS Parameter_Value
FROM @TXML.nodes('//*:Property') PROP(DATA)
;
March 27, 2017 at 9:27 am
Many ways of doing this, here are two of them. There is a difference in the performance depending on the data so check which fits your environment better.
😎
March 25, 2017 at 9:37 am
Viewing 15 posts - 2,266 through 2,280 (of 8,760 total)