Viewing 10 posts - 16 through 25 (of 25 total)
Hello!
Let me please ask you for advice again
Attached is another example of a xml file, now with 3 layers of data below point of entrance '/config/queues/queue', so to speak
For the...
April 30, 2022 at 1:40 am
Thank you, Eddie! This is way more elegant than my approach
April 21, 2022 at 1:48 pm
SELECT
HIGHERLEVEL.QueueName,
LOWERLEVEL.Serial
FROM
(
SELECT
row_number() over(order by (select 0)) as ID
,doc.col.value('serial[1]', 'nvarchar(30)') Serial
FROM
@xml.nodes('/config/queues/queue/assets') doc(col)
) as LOWERLEVEL
INNER JOIN
(
SELECT
row_number() over(order by (select 0)) as ID
,doc1.col.value('@id[1]','nvarchar(30)') as QueueName
FROM @xml.nodes('/config/queues/queue') doc1(col)
)...
April 15, 2022 at 9:31 pm
Yes, at least for what you are trying to accomplish. I have had...
May 10, 2018 at 11:46 am
Lynn Pettis - Thursday, May 10, 2018 11:15 AM
I guess, you're saying "this is impossible" 🙂
May 10, 2018 at 11:37 am
May 10, 2018 at 11:33 am
Give this a try:
DECLARE @theDate varchar(22)
, @SQLCmd NVARCHAR(MAX);
SET @theDate = CONVERT(VARCHAR(22),CAST(CAST(dateadd(dd,-28,getdate())...
May 10, 2018 at 11:12 am
Here is a simplified version
DECLARE @theDate varchar(22)
SET @theDate = concat(convert(varchar,dateadd(dd,-28,getdate()),112),'000000.Z0')
SELECT *,
@theDate
FROM OPENQUERY(ADSI,
'
SELECT sAMAccountName
FROM ''LDAP://10.10.10.10/CN=Users,DC=v-domain,DC=com''
WHERE objectCategory = ''Person''
May 10, 2018 at 7:35 am
May 10, 2018 at 6:21 am
Viewing 10 posts - 16 through 25 (of 25 total)