Viewing 15 posts - 1 through 15 (of 186 total)
I was playing around and I got the first part
SELECT
top 2 'class1' as [@ClassName]
,AccountNumber as 'ExternalId' from Account
FOR XML PATH('Element'),type
--generates output
<Element ClassName="class1">
<ExternalId>3002543105</ExternalId>
</Element>
<Element ClassName="class1">
<ExternalId>3002651195</ExternalId>
</Element>
But not sure how I add "TYPE" in...
September 7, 2022 at 6:51 pm
The data is just simple I have a table named Account that stores the account number
Table : Account
3002543105
3002543106
September 7, 2022 at 5:53 pm
I want to keep the child data but just clear out the parent table.
September 20, 2019 at 3:29 pm
The data type is int for all columns . yes order by col1. Also there can be consecutive null values. But all the consecutive null values will be updated to...
August 28, 2019 at 9:24 pm
Yes, the indexing on the FOREIGN KEY on the referencing tables did it. Thank you !
May 13, 2019 at 3:38 pm
It has scan to find the 1000 rows
code for the view
select top 200 key1 from [dbo].[Mytable1]
where key1 not in (select key1 from Mytable2)
order by Key1
--I was not ordering before still...
May 10, 2019 at 6:21 pm
Guras wrote:No, I am the only one running this query at the moment.
That doesn't mean there can't be another process locking your table.
No processes nothing. I am the...
May 10, 2019 at 5:56 pm
No, I am the only one running this query at the moment.
May 10, 2019 at 4:55 pm
February 26, 2019 at 2:19 pm
February 26, 2019 at 7:10 am
November 28, 2018 at 1:22 pm
;WITH myTable AS November 28, 2018 at 9:46 am
July 12, 2018 at 9:13 am
Viewing 15 posts - 1 through 15 (of 186 total)