![[Valid Atom 1.0]](images/valid-atom.png "Valid Atom 1.0")
This is a valid Atom 1.0 feed.
This feed is valid, but interoperability with the widest range of feed readers could be improved by implementing the following recommendations.
<feed xmlns="http://www.w3.org/2005/Atom" xmlns:creativeCommons="http://back ...
<?xml version="1.0" encoding="utf-8"?><feed xmlns="http://www.w3.org/2005/Atom" xmlns:creativeCommons="http://backend.userland.com/creativeCommonsRssModule" xmlns:re="http://purl.org/atompub/rank/1.0"> <title type="text">User codeulike - Stack Overflow</title> <link rel="self" href="https://stackoverflow.com/feeds/user/22194" type="application/atom+xml" /> <link rel="alternate" href="https://stackoverflow.com/users/22194" type="text/html" /> <subtitle>most recent 30 from stackoverflow.com</subtitle> <updated>2024-04-26T20:49:07Z</updated> <id>https://stackoverflow.com/feeds/user/22194</id> <creativeCommons:license>https://creativecommons.org/licenses/by-sa/4.0/rdf</creativeCommons:license> <entry> <id>https://stackoverflow.com/questions/78073061/-/78073111#78073111</id> <re:rank scheme="https://stackoverflow.com">4</re:rank> <title type="text">Answer by codeulike for What is the maximum length that an Oracle Cloud ID (OCID) can have?</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/78073061/what-is-the-maximum-length-that-an-oracle-cloud-id-ocid-can-have/78073111#78073111" /> <published>2024-02-28T08:54:59Z</published> <updated>2024-02-28T08:54:59Z</updated> <summary type="html"><p>You're right, this doesn't seem to be defined anywhere. e.g this is an oracle page talking about OCIDs but doesn't give the length:</p>
<p><a href="https://docs.public.oneportal.content.oci.oraclecloud.com/en-us/iaas/Content/General/Concepts/identifiers.htm#Resource_Identifiers" rel="nofollow noreferrer">https://docs.public.oneportal.content.oci.oraclecloud.com/en-us/iaas/Content/General/Concepts/identifiers.htm#Resource_Identifiers</a></p>
<p>However I did find this obscure bit of code from some cloud-foundry thing:</p>
<p><a href="https://github.com/cloudfoundry-incubator/bosh-oracle-cpi-release/blob/master/src/github.com/oracle/bosh-oracle-cpi/vendor/oracle/oci/core/models/volume_backup_policy.go" rel="nofollow noreferrer">https://github.com/cloudfoundry-incubator/bosh-oracle-cpi-release/blob/master/src/github.com/oracle/bosh-oracle-cpi/vendor/oracle/oci/core/models/volume_backup_policy.go</a></p>
<pre><code>// The OCID of the volume backup policy.
// Required: true
// Max Length: 255
// Min Length: 1
</code></pre>
<p>So I'd say the max length is 255. I know its not much to go on, but 255 seems like a good bet for this sort of modern id.</p>
</summary> </entry> <entry> <id>https://stackoverflow.com/questions/78062577/-/78066544#78066544</id> <re:rank scheme="https://stackoverflow.com">0</re:rank> <title type="text">Answer by codeulike for SQL Query optimization for Join containing the DateTime</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/78062577/sql-query-optimization-for-join-containing-the-datetime/78066544#78066544" /> <published>2024-02-27T09:46:56Z</published> <updated>2024-02-27T09:46:56Z</updated> <summary type="html"><p>Call me old school but sometimes a temp table is worth trying, especially if the proportion of employees with <code>ContractExpire &gt; '20240410'</code> is only a fraction of the total. The idea is that this forces the optimiser to only spend time looking at the subset that you're interested in.</p>
<pre><code>SELECT e.EmpID, t.Status, t.Id
INTO #temptransactions
FROM Employee e
INNER JOIN Transactions t ON e.EmpID = t.EmpID 
WHERE e.ContractExpire &gt; '20240410'

-- creating index is optional but will probably help
CREATE INDEX idx_temptransactions on #temptransactions(EmpId, Id)


SELECT COUNT(DISTINCT t1.EmpID) 
FROM #temptransactions t1 
 INNER JOIN (SELECT EmpId,MAX(Id) as maxId 
 FROM #temptransactions t2
 GROUP BY EmpId) newest
 ON newest.EmpId = t1.EmpId
 AND newest.maxId = t1.Id
WHERE t1.Status = 20
</code></pre>
</summary> </entry> <entry> <id>https://stackoverflow.com/questions/1256925/-/9862901#9862901</id> <re:rank scheme="https://stackoverflow.com">50</re:rank> <title type="text">Answer by codeulike for SSRS multi-value parameter using a stored procedure</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/1256925/ssrs-multi-value-parameter-using-a-stored-procedure/9862901#9862901" /> <published>2012-03-25T18:40:54Z</published> <updated>2024-02-07T22:54:23Z</updated> <summary type="html"><p>You need three things:</p>
<ol>
<li><p>In the SSRS dataset properties, pass the multi-value param to the stored procedure as a comma-delimited string</p>
 <pre class="lang-vb prettyprint-override"><code> =Join(Parameters!TerritoryMulti.Value, &quot;,&quot;)
</code></pre>
</li>
<li><p>In SQL Server, you need a table-value function that can split a comma-delimited string back out into a mini table (eg <a href="https://stackoverflow.com/a/512300/22194">see here</a>). edit: Since SQL Server 2016 you can use the built-in function <code>STRING_SPLIT</code> for this</p>
</li>
<li><p>In the stored procedure, have a where clause something like this:</p>
 <pre class="lang-sql prettyprint-override"><code> WHERE sometable.TerritoryID in (select value from STRING_SPLIT(@TerritoryMulti,','))
</code></pre>
<p>... where STRING_SPLIT is splitting the comma-delimited string back out into a table structure. NB: If you're on something older than SQL Server 2016 you'll need a custom function here instead of STRING_SPLIT, e.g. <a href="https://stackoverflow.com/a/512300/22194">see here</a>.</p>
</li>
</ol>
<p>(Full steps and code in my blog post '<a href="https://codeulike.com/2012/03/ssrs-multi-value-parameters-with-less.html" rel="nofollow noreferrer">SSRS multi-value parameters with less fail</a>'):</p>
</summary> </entry> <entry> <id>https://stackoverflow.com/questions/77788170/removing-1-and-2-from-a-string-with-out-removing-11-and-12/77788351#77788351</id> <re:rank scheme="https://stackoverflow.com">2</re:rank> <title type="text">Answer by codeulike for Removing "1, " and "2, " from a string with out removing "11, " and "12, "</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/77788170/removing-1-and-2-from-a-string-with-out-removing-11-and-12/77788351#77788351" /> <published>2024-01-09T16:37:39Z</published> <updated>2024-01-09T17:05:57Z</updated> <summary type="html"><p>edit: after typing all this out, I see its similar to the answer Thom A already gave except I'm using CTEs instead of creating tables.</p>
<p>You can use STRING_SPLIT to pivot the csv field into proper data, then process that data, then use STRING_AGG to unpivot it back into a csv field.</p>
<p>STRING_SPLIT was introduced in SQL Server 2016<br />
STRING_AGG was introduced in SQL Server 2017</p>
<p>For example if your key is MyPrimaryKey and the field with the CSV data is called CsvField you can split it out like this:</p>
<pre><code>select t.MyPrimaryKey, LTRIM(RTRIM(split.value)) as split_out
from MyTable t
 cross apply STRING_SPLIT(t.CsvField,',') as split
</code></pre>
<p>This will give you separate rows for each value like this:</p>
<pre><code>MyPrimaryKey split_out
------------ ---------
one 2
one 3
one 4
one 5
one 6
two 1
two 2
 etc...
</code></pre>
<p>Once you've got it in that format, you can easily remove the values you dont want, using something like this:</p>
<pre><code>with cteStageOne as (
 select t.MyPrimaryKey, LTRIM(RTRIM(split.value)) as split_out
 from MyTable t
 cross apply STRING_SPLIT(t.CsvField,',') as split
)
select *
from cteStageOne
where split_out not in ('1','2')
</code></pre>
<p>Here's a complete solution that re-aggregates the strings back together:</p>
<pre><code>with cteStageOne as (
 select t.MyPrimaryKey, LTRIM(RTRIM(split.value)) as split_out
 from MyTable t
 cross apply STRING_SPLIT(t.CsvField,',') as split
), cteStageTwo as (
 select MyPrimaryKey, split_out
 from cteStageOne
 where split_out not in ('1','2')
)
select MyPrimaryKey, STRING_AGG(split_out,', ') as recombine
from cteStageTwo
group by MyPrimaryKey
</code></pre>
</summary> </entry> <entry> <id>https://stackoverflow.com/q/5694241</id> <re:rank scheme="https://stackoverflow.com">238</re:rank> <title type="text">DDD - the rule that Entities can't access Repositories directly</title> <category scheme="https://stackoverflow.com/tags" term="oop" /> <category scheme="https://stackoverflow.com/tags" term="domain-driven-design" /> <category scheme="https://stackoverflow.com/tags" term="repository-pattern" /> <category scheme="https://stackoverflow.com/tags" term="s#arp-architecture" /> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/5694241/ddd-the-rule-that-entities-cant-access-repositories-directly" /> <published>2011-04-17T15:02:02Z</published> <updated>2023-12-22T20:58:06Z</updated> <summary type="html"> <p>In Domain Driven Design, there seems to be <a href="http://thinkddd.com/blog/2009/03/02/the-specification-pattern/" rel="noreferrer">lots</a> of <a href="https://stackoverflow.com/questions/827670/is-it-ok-for-entities-to-access-repositories/827693#827693">agreement</a> that Entities should not access Repositories directly. </p>

<p>Did this come from Eric Evans <a href="http://www.amazon.co.uk/Domain-driven-Design-Tackling-Complexity-Software/dp/0321125215" rel="noreferrer">Domain Driven Design</a> book, or did it come from elsewhere?</p>

<p>Where are there some good explanations for the reasoning behind it?</p>

<p>edit: To clarify: I'm not talking about the classic OO practice of separating data access off into a separate layer from the business logic - I'm talking about the specific arrangement whereby in DDD, Entities are not supposed to talk to the data access layer at all (i.e. they are not supposed to hold references to Repository objects)</p>

<p>update: I gave the bounty to BacceSR because his answer seemed closest, but I'm still pretty in the dark about this. If its such an important principle, there should be some good articles about it online somewhere, surely?</p>

<p>update: March 2013, the upvotes on the question imply there's a lot of interest in this, and even though there's been lots of answers, I still think there's room for more if people have ideas about this.</p>
 </summary> </entry> <entry> <id>https://stackoverflow.com/q/74070542</id> <re:rank scheme="https://stackoverflow.com">2</re:rank> <title type="text">Powershell Add-Member with an expression for the value</title> <category scheme="https://stackoverflow.com/tags" term="powershell" /> <category scheme="https://stackoverflow.com/tags" term="calculated-property" /> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/74070542/powershell-add-member-with-an-expression-for-the-value" /> <published>2022-10-14T14:10:12Z</published> <updated>2023-10-29T20:23:43Z</updated> <summary type="html"> <p>Trying to add a new member to an array of powershell objects, can't get the expression to evaluate. Here's some example code:</p>
<pre><code>$testData =
@([pscustomobject]@{Name=&quot;Cat&quot;;Legs=4},
[pscustomobject]@{Name=&quot;Parrot&quot;;Legs=2},
[pscustomobject]@{Name=&quot;Snake&quot;;Legs=0})

# this works
$testData | Select-Object Name, Legs, @{N='CopyName';E={$_.Name}}

# why doesnt this work?
$testData | Add-Member -NotePropertyName &quot;CopyName&quot; -NotePropertyValue $_.Name
$testData
</code></pre>
<p>(Using Powershell 7)</p>
 </summary> </entry> <entry> <id>https://stackoverflow.com/questions/69947188/-/77074351#77074351</id> <re:rank scheme="https://stackoverflow.com">0</re:rank> <title type="text">Answer by codeulike for Load data to Salesforce using ADF SF connector</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/69947188/load-data-to-salesforce-using-adf-sf-connector/77074351#77074351" /> <published>2023-09-09T23:28:55Z</published> <updated>2023-09-09T23:28:55Z</updated> <summary type="html"><p>ADF now has a built-in <a href="https://learn.microsoft.com/en-us/azure/data-factory/connector-salesforce?tabs=data-factory" rel="nofollow noreferrer">Salesforce Connector</a>. It uses Bulk API V1 but thats perfectly respectable - Bulk API V1 and V2 co-exist and V1 is better in some ways*</p>
<p>The ADF Salesforce Connector is pretty good but if you want to retrieve the results of a bulk load (which rows failed etc) you have to jump through a few hoops, see <a href="https://www.codeulike.com/posts/2023/adf-salesforce" rel="nofollow noreferrer">blog post</a> about it.</p>
<p>* re: Bulk API V1 and V2: I prefer V1 because it lets you retrieve results via the UI, but V2 doesn't. V1 lets you set a batch size but V2 doesn't, etc.</p>
</summary> </entry> <entry> <id>https://stackoverflow.com/questions/837358/-/837378#837378</id> <re:rank scheme="https://stackoverflow.com">14</re:rank> <title type="text">Answer by codeulike for CREATE LOGIN - can't use @parameter as username</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/837358/create-login-cant-use-parameter-as-username/837378#837378" /> <published>2009-05-07T22:25:04Z</published> <updated>2023-08-11T11:40:57Z</updated> <summary type="html"><p>Apparently CREATE LOGIN only accepts literals.
You could try wrapping it in an exec and building it as a string:</p>
<p>Add <code>quotename</code> for safety from sql injection attacks</p>
<pre class="lang-sql prettyprint-override"><code>DECLARE @sql nvarchar(max) = 'CREATE LOGIN ' + quotename(@username) + ' WITH PASSWORD = ' + quotename(@password, '''');
EXEC(@sql)
</code></pre>
</summary> </entry> <entry> <id>https://stackoverflow.com/q/4080215</id> <re:rank scheme="https://stackoverflow.com">4</re:rank> <title type="text">Salesforce API: get the time on the Salesforce server</title> <category scheme="https://stackoverflow.com/tags" term="time" /> <category scheme="https://stackoverflow.com/tags" term="salesforce" /> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/4080215/salesforce-api-get-the-time-on-the-salesforce-server" /> <published>2010-11-02T17:09:36Z</published> <updated>2023-05-12T12:28:05Z</updated> <summary type="html"> <p>With the Salesforce API, is there a way to get the current time on the Salesforce server?</p>
 </summary> </entry> <entry> <id>https://stackoverflow.com/q/74110642</id> <re:rank scheme="https://stackoverflow.com">3</re:rank> <title type="text">Powershell - how to read Ansi CSV file</title> <category scheme="https://stackoverflow.com/tags" term="powershell" /> <category scheme="https://stackoverflow.com/tags" term="powershell-7.2" /> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/74110642/powershell-how-to-read-ansi-csv-file" /> <published>2022-10-18T12:01:15Z</published> <updated>2023-04-06T08:36:13Z</updated> <summary type="html"> <p>Notepad++ says the CSV file is Ansi encoded.</p>
<p>The Powershell 7 Import-CSV commandlet has various -Encoding options but 'Ansi' is not one of them.</p>
<p>How do I get Powershell to read this CSV without mangling it?</p>
<p>The options for -Encoding are:</p>
<ul>
<li>ascii</li>
<li>bigendianunicode</li>
<li>bigendianutf32</li>
<li>oem</li>
<li>unicode</li>
<li>utf7</li>
<li>utf8</li>
<li>utf8BOM</li>
<li>utf8NoBOM</li>
<li>utf32</li>
</ul>
 </summary> </entry> <entry> <id>https://stackoverflow.com/questions/75743627/-/75744017#75744017</id> <re:rank scheme="https://stackoverflow.com">1</re:rank> <title type="text">Answer by codeulike for I get runtime error when editing a currently existing recordset in my vba module</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/75743627/i-get-runtime-error-when-editing-a-currently-existing-recordset-in-my-vba-module/75744017#75744017" /> <published>2023-03-15T11:20:59Z</published> <updated>2023-03-15T11:20:59Z</updated> <summary type="html"><p>Runtime error runtime error '-214352571(80020005)' usually means Type Mismatch which means you've got some sort of problem with strings vs numbers or maybe a null value problem.</p>
<p>This line is giving the error:</p>
<pre><code>.kolCod.AddItem kol!klC
</code></pre>
<p>... and I think this line is pulling a value from a recordset and adding it to a combobox as an item?</p>
<p>What is the value of kol!klC? Maybe it is null? In which case you could try this:</p>
<pre><code>.kolCod.AddItem Nz(kol!klC,&quot;(empty)&quot;)
</code></pre>
</summary> </entry> <entry> <id>https://stackoverflow.com/questions/75734744/-/75734825#75734825</id> <re:rank scheme="https://stackoverflow.com">4</re:rank> <title type="text">Answer by codeulike for C# Null Coalescing for choosing between an object's properties?</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/75734744/c-sharp-null-coalescing-for-choosing-between-an-objects-properties/75734825#75734825" /> <published>2023-03-14T14:57:48Z</published> <updated>2023-03-14T15:04:38Z</updated> <summary type="html"><p>I would add it to the class</p>
<pre><code>class User{
 long Id;
 string FirstName;
 string Nickname;

 string NameToBeCalledBy { 
 get { return this.Nickname ?? this.FirstName; }
 }
}
</code></pre>
<p>Then you can do</p>
<pre><code>string nameToBeCalledBy = locationObj.Users.First(u =&gt; u.Id == 1).NameToBeCalledBy;
</code></pre>
<p>Thats kindof what classes were for, in the old days, to keep methods related to an object's data near that data. Although the .Select() answers people have given are also pretty tidy.</p>
</summary> </entry> <entry> <id>https://stackoverflow.com/questions/1303075/-/1303126#1303126</id> <re:rank scheme="https://stackoverflow.com">2</re:rank> <title type="text">Answer by codeulike for Nothing from Property TagKey()</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/1303075/nothing-from-property-tagkey/1303126#1303126" /> <published>2009-08-19T23:15:31Z</published> <updated>2022-12-21T15:02:47Z</updated> <summary type="html"><p>It’s possible to get rid of the containing tag with a CompositeControl, but it’s working against the way CompositeControl likes to work (see below).</p>
<p>The proper way, apparently, is to set TagKey to whatever the main tag of your control actually is (a div, table, or whatever).</p>
<p>Then override AddAttributesToRender() to set the attributes you want on your wrapper tag.</p>
<p>The stuff you want inside the wrapping tags should be rendered by overriding the RenderContents() method.</p>
<p>CompositeControl inherits from WebControl. See a discussion of the user of TagKey and AddAttributesToRender() <a href="https://learn.microsoft.com/en-us/previous-versions/f820d25y%28v=vs.140%29" rel="nofollow noreferrer">here</a>.</p>
<p>Someone on GeeksWithBlogs writes about a similar issue <a href="https://web.archive.org/web/20190904010434/http://geekswithblogs.net/mcastro/archive/2006/01/19/66393.aspx" rel="nofollow noreferrer">here</a>.</p>
<p>To just get rid of the wrapping though, see this <a href="https://social.msdn.microsoft.com/Forums/en-US/aadf87a5-1c27-48b0-b60a-986f74ed659b/removing-span-tags-in-custom-control-amp-tabindex?forum=aspservercontrols" rel="nofollow noreferrer">forum post</a> that shows a way to override the control constructor and the RenderBeginTag and RenderEndTag methods to remove the wrapping tags.</p>
</summary> </entry> <entry> <id>https://stackoverflow.com/questions/72200372/active-directory-web-service-adws-is-missing-on-windows-10-pro/74578746#74578746</id> <re:rank scheme="https://stackoverflow.com">2</re:rank> <title type="text">Answer by codeulike for Active directory web service (ADWS) is missing on Windows 10 Pro</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/72200372/active-directory-web-service-adws-is-missing-on-windows-10-pro/74578746#74578746" /> <published>2022-11-26T00:02:18Z</published> <updated>2022-11-26T00:02:18Z</updated> <summary type="html"><p>The Powershell ActiveDirectory examples that you find on the web usually assume you are using a PC thats on the domain, and you are logged into that PC as a domain user. But often these days thats not the case.</p>
<p>These days people are often logged into their own PC as 'Joe' and connected via VPN to a company's domain, with the DC running in Azure somewhere.</p>
<p>And when its like that, you have to tell the cmdlet where the DC is, and supply some credentials. So you do that like this:</p>
<pre><code>Get-ADUser -Server (name or IP address of DC) -Credential (Get-Credential) -filter *
</code></pre>
<p>The 'Get-Credential' bit will interactively ask you for credentials - you need to supply credentials for a user in the domain</p>
</summary> </entry> <entry> <id>https://stackoverflow.com/questions/1785474/-/74566541#74566541</id> <re:rank scheme="https://stackoverflow.com">4</re:rank> <title type="text">Answer by codeulike for Get index of current item in a PowerShell loop</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/1785474/get-index-of-current-item-in-a-powershell-loop/74566541#74566541" /> <published>2022-11-24T21:55:52Z</published> <updated>2022-11-24T21:55:52Z</updated> <summary type="html"><p>I found <a href="https://stackoverflow.com/a/1785546/22194">Cédric Rup's answer</a> very helpful but if (like me) you are confused by the '%' syntax/alias, here it is expanded out:</p>
<pre><code>$letters = { 'A', 'B', 'C' }
$letters | ForEach-Object -Begin {$counter = 0} -Process {...;$counter++}
</code></pre>
</summary> </entry> <entry> <id>https://stackoverflow.com/questions/74261797/sql-how-to-select-data-countries-that-only-has-code-with-3-characters/74261866#74261866</id> <re:rank scheme="https://stackoverflow.com">0</re:rank> <title type="text">Answer by codeulike for SQL How to select data (countries) that only has code with 3 characters?</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/74261797/sql-how-to-select-data-countries-that-only-has-code-with-3-characters/74261866#74261866" /> <published>2022-10-31T10:24:05Z</published> <updated>2022-10-31T10:24:05Z</updated> <summary type="html"><p>Like this:</p>
<pre><code>select count(distinct country) as &quot;Number of Countries&quot; 
FROM owid_energy_data 
where len(iso_code) = 3
</code></pre>
</summary> </entry> <entry> <id>https://stackoverflow.com/q/74123310</id> <re:rank scheme="https://stackoverflow.com">0</re:rank> <title type="text">Powershell function returns Array of Arrays, but gets flattened if only 1 Array [duplicate]</title> <category scheme="https://stackoverflow.com/tags" term="powershell" /> <category scheme="https://stackoverflow.com/tags" term="multidimensional-array" /> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/74123310/powershell-function-returns-array-of-arrays-but-gets-flattened-if-only-1-array" /> <published>2022-10-19T09:52:08Z</published> <updated>2022-10-19T09:52:08Z</updated> <summary type="html"> <p>So I've got a long list of strings that I am arranging into 'chunks' of (say) 10. So the data structure for that is an array of 'chunks' where each 'chunk' is an array of up to 10 strings. So you can imagine it like this:</p>
<pre><code>Chunk Array
-----------
a,b,c,d,e,f,g,h,i,j &lt;-- an array of 10 strings
h,i,j,k,l,m,n,o,p,q &lt;-- an array of 10 strings
r,s,t &lt;-- an array of 3 strings

^ So this is an array of three 'chunks'
</code></pre>
<p>I have a function that takes in a long list and outputs an array of chunks as above. The function is <a href="https://stackoverflow.com/a/20112686/22194">from here</a> and for most cases it works well.</p>
<pre><code>function ChunkBy($items,[int]$size) {
 $list = new-object System.Collections.ArrayList
 $tmpList = new-object System.Collections.ArrayList
 foreach($item in $items) {
 $tmpList.Add($item) | out-null
 if ($tmpList.Count -ge $size) {
 $list.Add($tmpList.ToArray()) | out-null
 $tmpList.Clear()
 }
 }

 if ($tmpList.Count -gt 0) {
 $list.Add($tmpList.ToArray()) | out-null
 }

 return $list.ToArray()
}
</code></pre>
<p>The problem is that if you call the function with a small list that will result in only one 'chunk', powershell flattens the outer array, so instead of an array containing one 'chunk', you get a flat array of strings.</p>
<p>Here's a little helper function to write the chunk structure to the console:</p>
<pre><code>function ShowChunks($items)
{
 Write-Output &quot; &quot;
 Write-Output &quot;array has $($items.Length) chunks&quot;
 Write-Output &quot;-----------------&quot;
 foreach($c in $items)
 { 
 [system.String]::Join(&quot;,&quot;, $c)
 }
}
</code></pre>
<p>And here's some test code to demonstrate the problem, using the two functions above</p>
<pre><code>$testArray = (&quot;a&quot;,&quot;b&quot;,&quot;c&quot;,&quot;d&quot;,&quot;e&quot;)

$res1 = ChunkBy $testArray 3
ShowChunks $res1

$res2 = ChunkBy $testArray 6
ShowChunks $res2
</code></pre>
<p>$res1 is fine. But for $res2 this gives:</p>
<pre><code>array has 5 chunks
-----------------
a
b
c
d
e
</code></pre>
<p>But really what I want is:</p>
<pre><code>array has 1 chunks
-----------------
a,b,c,d,e
</code></pre>
<p>So to summarise, the problem is:</p>
<p>I've got a function that returns an 'Array of Arrays', but when there's only one Array to return, instead of an 'Array of one Array', I just get an 'Array'.</p>
<p>This happens because of Powershells tendancy to flatten one-element arrays into just an element. How can we fix it?</p>
 </summary> </entry> <entry> <id>https://stackoverflow.com/questions/3825901/-/3826040#3826040</id> <re:rank scheme="https://stackoverflow.com">16</re:rank> <title type="text">Answer by codeulike for Bulk insert fixed width fields</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/3825901/bulk-insert-fixed-width-fields/3826040#3826040" /> <published>2010-09-29T21:34:45Z</published> <updated>2022-10-13T19:26:00Z</updated> <summary type="html"><p>I think you need to define a format file</p>
<p>e.g.</p>
<pre><code>BULK INSERT TableA FROM 'C:\Temp\TableA.txt'
WITH (FORMATFILE = 'C:\Temp\Format.xml')
SELECT * FROM TableA
</code></pre>
<p>For that to work, though, you need a Format File, obviously.</p>
<p>See here for general info about creating one:</p>
<p><a href="http://msdn.microsoft.com/en-us/library/ms191516%28v=SQL.90%29.aspx" rel="nofollow noreferrer">Creating a Format File</a></p>
<p>At a guess, from looking at the <a href="http://msdn.microsoft.com/en-us/library/ms189327%28v=SQL.90%29.aspx" rel="nofollow noreferrer">Schema</a>, something like this might do it:</p>
<pre><code>&lt;?xml version=&quot;1.0&quot;?&gt;
&lt;BCPFORMAT xmlns=&quot;http://schemas.microsoft.com/sqlserver/2004/bulkload/format&quot; xmlns:xsi=&quot;http://www.w3.org/2001/XMLSchema-instance&quot;&gt;
&lt;RECORD&gt;
 &lt;FIELD ID=&quot;1&quot; xsi:type=&quot;CharFixed&quot; LENGTH=&quot;3&quot;/&gt;
 &lt;FIELD ID=&quot;2&quot; xsi:type=&quot;CharFixed&quot; LENGTH=&quot;3&quot;/&gt;
&lt;/RECORD&gt;
&lt;ROW&gt;
 &lt;COLUMN SOURCE=&quot;1&quot; NAME=&quot;Field1&quot; xsi:type=&quot;SQLCHAR&quot; LENGTH=&quot;3&quot;/&gt;
 &lt;COLUMN SOURCE=&quot;2&quot; NAME=&quot;Field2&quot; xsi:type=&quot;SQLCHAR&quot; LENGTH=&quot;3&quot;/&gt;
&lt;/ROW&gt;
&lt;/BCPFORMAT&gt;
</code></pre>
</summary> </entry> <entry> <id>https://stackoverflow.com/questions/73972961/-/73973057#73973057</id> <re:rank scheme="https://stackoverflow.com">-1</re:rank> <title type="text">Answer by codeulike for ERROR: 'Incorrect syntax near the keyword 'ORDER'.'</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/73972961/error-incorrect-syntax-near-the-keyword-order/73973057#73973057" /> <published>2022-10-06T11:30:02Z</published> <updated>2022-10-06T11:40:16Z</updated> <summary type="html"><p>Probably, you just need to give the subquery an alias:</p>
<pre><code>SELECT TOP 20 * FROM 
 (
 SELECT DISTINCT
 p.ItemGroupName, p.Varenummer, s.EAN, s.inventoryQuantity 
 FROM 
 ShopInventory s, ProductData p
 WHERE s.EAN = p.EAN
) mytable
ORDER BY cast(inventoryQuantity AS int) DESC
</code></pre>
<p>Some would say you are using the old join syntax instead of the recommended JOIN clause but for the purposes of solving your question I think thats a bit of a distraction. If you're interested in INNER JOIN , OUTER JOIN and all that you can read up here: <a href="https://stackoverflow.com/questions/38549/what-is-the-difference-between-inner-join-and-outer-join">What is the difference between &quot;INNER JOIN&quot; and &quot;OUTER JOIN&quot;?</a></p>
</summary> </entry> <entry> <id>https://stackoverflow.com/q/860966</id> <re:rank scheme="https://stackoverflow.com">194</re:rank> <title type="text">Calculate a Running Total in SQL Server</title> <category scheme="https://stackoverflow.com/tags" term="sql" /> <category scheme="https://stackoverflow.com/tags" term="sql-server" /> <category scheme="https://stackoverflow.com/tags" term="t-sql" /> <category scheme="https://stackoverflow.com/tags" term="cumulative-sum" /> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/860966/calculate-a-running-total-in-sql-server" /> <published>2009-05-13T23:42:26Z</published> <updated>2022-10-02T07:01:56Z</updated> <summary type="html"> <p>Imagine the following table (called <code>TestTable</code>):</p>
<pre><code>id somedate somevalue
-- -------- ---------
45 01/Jan/09 3
23 08/Jan/09 5
12 02/Feb/09 0
77 14/Feb/09 7
39 20/Feb/09 34
33 02/Mar/09 6
</code></pre>
<p>I would like a query that returns a running total in date order, like:</p>
<pre><code>id somedate somevalue runningtotal
-- -------- --------- ------------
45 01/Jan/09 3 3
23 08/Jan/09 5 8
12 02/Feb/09 0 8
77 14/Feb/09 7 15 
39 20/Feb/09 34 49
33 02/Mar/09 6 55
</code></pre>
<p>I know there are <a href="https://web.archive.org/web/20200212211219/http://geekswithblogs.net:80/Rhames/archive/2008/10/28/calculating-running-totals-in-sql-server-2005---the-optimal.aspx" rel="noreferrer">various ways of doing this</a> in SQL Server 2000 / 2005 / 2008.</p>
<p>I am particularly interested in this sort of method that uses the aggregating-set-statement trick:</p>
<pre><code>INSERT INTO @AnotherTbl(id, somedate, somevalue, runningtotal) 
 SELECT id, somedate, somevalue, null
 FROM TestTable
 ORDER BY somedate

DECLARE @RunningTotal int
SET @RunningTotal = 0

UPDATE @AnotherTbl
SET @RunningTotal = runningtotal = @RunningTotal + somevalue
FROM @AnotherTbl
</code></pre>
<p>... this is very efficient but I have heard there are issues around this because you can't necessarily guarantee that the <code>UPDATE</code> statement will process the rows in the correct order. Maybe we can get some definitive answers about that issue.</p>
<p>But maybe there are other ways that people can suggest?</p>
<p>edit: Now with a <a href="http://sqlfiddle.com/#!3/c8880/4" rel="noreferrer">SqlFiddle</a> with the setup and the 'update trick' example above</p>
 </summary> </entry> <entry> <id>https://stackoverflow.com/questions/17858598/-/72469169#72469169</id> <re:rank scheme="https://stackoverflow.com">2</re:rank> <title type="text">Answer by codeulike for Add styling rules in pandoc tables for odt/docx output (table borders)</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/17858598/add-styling-rules-in-pandoc-tables-for-odt-docx-output-table-borders/72469169#72469169" /> <published>2022-06-01T23:54:52Z</published> <updated>2022-06-02T00:00:09Z</updated> <summary type="html"><p>I really liked <a href="https://stackoverflow.com/a/30917615/22194">gbjbaanb's answer</a> - here's a powershell version:</p>
<p>Background: Set up a PanDoc <code>--reference-doc</code> template as described in the <a href="https://pandoc.org/MANUAL.html" rel="nofollow noreferrer">pandoc documentation</a> for the <code>--reference-doc</code> parameter</p>
<p>Open up Word and create a new custom table style in the template doc. In our example that custom table style is called 'MyCustomTable'</p>
<p>Generate your word doc using the <code>--reference-doc</code> parameter - the custom table style will be included in the doc, you just have to insert its name in the right place. This bit of powershell will do that for you:</p>
<pre><code>$outFile = &quot;C:\Path\To\Your\Doc.docx&quot;
$workFolder = &quot;C:\Some\Temp\Folder\Somewhere\&quot;
# then this replaces table style in $outFile:
$zipFile = $outFile.Replace(&quot;.docx&quot;,&quot;.zip&quot;)
Rename-Item $outFile $zipFile 
Expand-Archive $zipFile -DestinationPath $workFolder -Force
$wordXml = Get-Content &quot;${workFolder}Word\Document.xml&quot;
$updatedXml = $wordXml.Replace('&lt;w:tblStyle w:val=&quot;Table&quot; /&gt;','&lt;w:tblStyle w:val=&quot;MyCustomTable&quot; /&gt;')
Set-Content -Path &quot;${workFolder}Word\Document.xml&quot; -Value $updatedXml
Compress-Archive -Path &quot;${workFolder}*&quot; -DestinationPath $zipFile -Force
Rename-Item $zipFile $outFile
</code></pre>
<p>... where $outFile is the docx, and $workFolder is a temp folder somewhere.</p>
<p>In some earlier versions of PanDoc, instead of seaching for <code>&lt;w:tblStyle w:val=&quot;Table&quot; /&gt;</code> you'll need to search for <code>&lt;w:tblStyle w:val=&quot;TableNormal&quot; /&gt;</code></p>
</summary> </entry> <entry> <id>https://stackoverflow.com/questions/71672285/-/72376457#72376457</id> <re:rank scheme="https://stackoverflow.com">1</re:rank> <title type="text">Answer by codeulike for sql query using script activity in ADF pipeline</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/71672285/sql-query-using-script-activity-in-adf-pipeline/72376457#72376457" /> <published>2022-05-25T11:04:20Z</published> <updated>2022-05-25T11:04:20Z</updated> <summary type="html"><p>You can't really get the tablename out of the Copy Data activity. But what you can do is use a variable to generate your tablename before the Copy Data activity, and then use that variable in both the Copy Data activity and the Script activity:</p>
<p>Like this:</p>
<ul>
<li>Create a Pipeline Variable</li>
<li>Add a Set Variable activity before the Copy Data activity and use that to do the <code>tbl@{replace(pipeline().RunId,'-','')}</code> expression evaluation</li>
<li>Then use that variable in the Copy Activity as the table name <code>@variables('yourVariableName')</code></li>
<li>then use that same variable in the Script Activity when you do the index <code>CREATE CLUSTERED INDEX IDX_Whatever ON @{variables('yourVariableName')}</code></li>
</ul>
</summary> </entry> <entry> <id>https://stackoverflow.com/q/850327</id> <re:rank scheme="https://stackoverflow.com">91</re:rank> <title type="text">How to insert into a table with just one IDENTITY column?</title> <category scheme="https://stackoverflow.com/tags" term="sql" /> <category scheme="https://stackoverflow.com/tags" term="sql-server" /> <category scheme="https://stackoverflow.com/tags" term="identity" /> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/850327/how-to-insert-into-a-table-with-just-one-identity-column" /> <published>2009-05-11T22:08:34Z</published> <updated>2022-05-14T12:36:05Z</updated> <summary type="html"> <p>(Came up with this question in the course of trying to answer <a href="https://stackoverflow.com/questions/850017/how-to-manage-groups-in-the-database/850049#850049">this other one</a>) </p>

<p>Consider the following MS-SQL table, called GroupTable:</p>

<pre>
GroupID
-------
1 
2 
3 
</pre>

<p>where GroupID is the primary key and is an Identity column.</p>

<p>How do you insert a new row into the table (and hence generate a new ID) <strong>without</strong> using IDENTITY_INSERT ON?</p>

<p>Note that this: </p>

<pre><code>INSERT INTO GroupTable() Values () 
</code></pre>

<p>... won't work.</p>

<p>edit: we're talking SQL 2005 or SQL 2008 here.</p>
 </summary> </entry> <entry> <id>https://stackoverflow.com/questions/21302947/-/72156076#72156076</id> <re:rank scheme="https://stackoverflow.com">0</re:rank> <title type="text">Answer by codeulike for SSMS add comma delimiter - shortcut</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/21302947/ssms-add-comma-delimiter-shortcut/72156076#72156076" /> <published>2022-05-07T20:20:14Z</published> <updated>2022-05-07T20:20:14Z</updated> <summary type="html"><p>Some good answers here already but here's some more:</p>
<blockquote>
<p>... Person's Id values let's say from some Excel file ...</p>
</blockquote>
<p>If you're copying from Excel its sometimes easier to add commas (or speechmarks) or whatever in Excel before copying.</p>
<p>e.g. in the cell to the right do</p>
<pre><code>=A1 &amp; &quot;,&quot;
</code></pre>
<p>Then copy that formula all the way down the list.</p>
<p>Also Notepad++ is great for this sort of thing, you can record a macro to do one line, and then run it N times:</p>
<ul>
<li>In Notepad++ go to the start of the first line</li>
<li>Select Macro - Start Recording</li>
<li>Do the right keypresses - in this case: End, Comma, Down, Home</li>
<li>Select Macro - Stop Recording</li>
<li>Select 'Run a Macro Multiple Times ...'</li>
<li>It will by default show 'current recorded macro' (the one you just recorded)</li>
<li>Tell it how many times you want it, then off you go</li>
</ul>
</summary> </entry> <entry> <id>https://stackoverflow.com/q/71999320</id> <re:rank scheme="https://stackoverflow.com">1</re:rank> <title type="text">ADF - get table name from dataset</title> <category scheme="https://stackoverflow.com/tags" term="dynamic" /> <category scheme="https://stackoverflow.com/tags" term="azure-data-factory" /> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/71999320/adf-get-table-name-from-dataset" /> <published>2022-04-25T12:09:49Z</published> <updated>2022-04-27T21:59:13Z</updated> <summary type="html"> <p>Azure Data Factory dynamic content seems very powerful and very under-documented.</p>
<p>Lets say I have a simple (non-dynamic) dataset pointing to a SQL table:</p>
<p><a href="https://i.stack.imgur.com/c4e93.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/c4e93.png" alt="enter image description here" /></a></p>
<p>And then in a Copy Data task I want to reference that table in the Pre-copy script, e.g. to clear out all the data.</p>
<p><a href="https://i.stack.imgur.com/0JUtd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/0JUtd.png" alt="enter image description here" /></a></p>
<p>How can I pull the table name out of the dataset? Its right there in the Json so surely there's a way?</p>
<p>e.g I see ADF has an activities collection that you can pull things from, e.g. <code>@activity(&quot;Activity Name&quot;).output</code> ... is there anything similar for pulling properties from datasets? Or from the current Copy Data activity and then get through to the dataset from there?</p>
<p>The official documentation gives a <a href="https://learn.microsoft.com/en-us/azure/data-factory/control-flow-expression-language-functions" rel="nofollow noreferrer">few quick examples</a> but is very light on details. e.g. when you do <code>@activity(&quot;Activity Name&quot;).output</code> you are hitting some sort of object model but what other objects are available and what are their properties? Anyone got anything on that?</p>
 </summary> </entry> <entry> <id>https://stackoverflow.com/questions/72001443/-/72001538#72001538</id> <re:rank scheme="https://stackoverflow.com">1</re:rank> <title type="text">Answer by codeulike for Syntax error (missing operator) in query expression Access database</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/72001443/syntax-error-missing-operator-in-query-expression-access-database/72001538#72001538" /> <published>2022-04-25T14:55:53Z</published> <updated>2022-04-25T15:02:31Z</updated> <summary type="html"><p>you need a comma at end of first line:</p>
<pre><code>SELECT dbo_CUS_SortRef , dbo_IMA_ItemID ,
</code></pre>
<p>edit: oh also you cant use CASE WHEN THEN ELSE END in Access, thats a T-SQL thing. You could try switch instead <a href="https://stackoverflow.com/a/54906589/22194">https://stackoverflow.com/a/54906589/22194</a></p>
<p>edit: oh and isnull only has one parameter in Access</p>
<p>edit: oh and <a href="https://stackoverflow.com/a/20929533/22194">Access requires parentheses in the FROM clause for queries which include more than one join.</a></p>
<p>with thanks to HansUp, Nathan_Sav in the comments</p>
</summary> </entry> <entry> <id>https://stackoverflow.com/questions/60870210/-/71659554#71659554</id> <re:rank scheme="https://stackoverflow.com">3</re:rank> <title type="text">Answer by codeulike for How to run SQL Server Agent Powershell script with output and exit code</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/60870210/how-to-run-sql-server-agent-powershell-script-with-output-and-exit-code/71659554#71659554" /> <published>2022-03-29T09:28:18Z</published> <updated>2022-03-29T09:28:18Z</updated> <summary type="html"><p>I struggled with this. The logged output from the Sql Job Powershell steps is pretty useless. I found it better to use a CmdExex step instead that calls Powershell.exe.</p>
<p>In a Sql 2019 CmdExec job step you can just call your powershell script like this:</p>
<pre><code>Powershell &quot;F:\Temp\TestScript.ps1&quot;
</code></pre>
<p>... and you'll get all the output (and you can log it to a file if you like). And if there's an error, the job stops properly.</p>
<p>In some earlier versions of SQL Server, Powershell errors would get logged but the job would continue to run (see here <a href="https://stackoverflow.com/a/53732722/22194">https://stackoverflow.com/a/53732722/22194</a> ), so you need to wrap your script in a try/catch to bubble up the error in a way SQL can deal with it:</p>
<pre><code>Powershell.exe -command &quot;try { &amp; 'F:\Temp\TestScript.ps1'} catch { throw $_ }&quot;
</code></pre>
<p>Note that if your script path has spaces in it you might get different problems, see here <a href="https://stackoverflow.com/a/45762288/22194">https://stackoverflow.com/a/45762288/22194</a></p>
</summary> </entry> <entry> <id>https://stackoverflow.com/questions/71510437/-/71510987#71510987</id> <re:rank scheme="https://stackoverflow.com">1</re:rank> <title type="text">Answer by codeulike for Multi-value parameter in SSRS not working with select all : An expression of nonboolean type specified context where a condition is expected, near ','</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/71510437/multi-value-parameter-in-ssrs-not-working-with-select-all-an-expression-of-non/71510987#71510987" /> <published>2022-03-17T10:44:43Z</published> <updated>2022-03-17T10:51:50Z</updated> <summary type="html"><p>This bit is the problem:</p>
<p><code>WHERE @Branch IN (Branch)</code></p>
<p>You've got that 4 times in the #PIA3 query.</p>
<p>With a multi-valued param this will become <code>Where 'one','two','three' IN (Branch)</code> which is illegal sql. But with a single value you get <code>'one' IN (Branch)</code> which will work.</p>
<p>SSRS does multi-valued parameters by using a 'trick' - instead of doing proper parameterised SQL, it just chucks the comma separated list of values into the SQL using string substitituion.</p>
<p>But that only works for <code>Branch in (@Branch)</code></p>
<p>It wont work for <code>@Branch in (Branch)</code></p>
<p>From what I can see of your query if you just swap them round it will be fine. @Branch always needs to be on the right hand side of an IN</p>
</summary> </entry> <entry> <id>https://stackoverflow.com/questions/71340254/-/71340475#71340475</id> <re:rank scheme="https://stackoverflow.com">1</re:rank> <title type="text">Answer by codeulike for IS There any condition for not deleting the images in Word ,via C#?</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/71340254/is-there-any-condition-for-not-deleting-the-images-in-word-via-c/71340475#71340475" /> <published>2022-03-03T16:26:23Z</published> <updated>2022-03-03T16:26:23Z</updated> <summary type="html"><p>You're just looking for Text:</p>
<p><code>document1.ActiveWindow.Selection.Text.Trim().Length &lt;= 1</code></p>
<p>I think you also need to look for 'InlineShapes' which would include things like images and drawings:</p>
<p><code>document1.ActiveWindow.Selection.InlineShapes.Count == 0</code></p>
<p>So probably something like</p>
<pre><code> if (document1.ActiveWindow.Selection.Text.Trim().Length &lt;= 1
 &amp;&amp; document1.ActiveWindow.Selection.InlineShapes.Count == 0)
 {
 document1.ActiveWindow.Selection.Delete();
 }
</code></pre>
<p>... although I don't really understand what your second 'if' block is for, you probably need something similar there too</p>
</summary> </entry> <entry> <id>https://stackoverflow.com/questions/71130278/-/71144678#71144678</id> <re:rank scheme="https://stackoverflow.com">2</re:rank> <title type="text">Answer by codeulike for Why would SQL truncate the right-side of a string when using the right function?</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/71130278/why-would-sql-truncate-the-right-side-of-a-string-when-using-the-right-function/71144678#71144678" /> <published>2022-02-16T15:30:35Z</published> <updated>2022-02-16T15:41:41Z</updated> <summary type="html"><p>OK this is tricky, I did some Foxpro 20 years ago but don't have it to hand.</p>
<p>Your SELECT statement looks OK to me. In the comments under the question Thomas G created this DbFiddle which shows that in a 'normal' dbms, your SELECT statement gives the result you are expecting: <a href="https://dbfiddle.uk/?rdbms=sqlserver_2017&amp;fiddle=37047d2b7efb91aaa029fa0fb98eea24" rel="nofollow noreferrer">https://dbfiddle.uk/?rdbms=sqlserver_2017&amp;fiddle=37047d2b7efb91aaa029fa0fb98eea24</a></p>
<p>So the problem must be something FoxPro/dBase specific rather than a problem with your SELECT statement.</p>
<p>Reading up I see people say that with FoxPro always use ALLTRIM() when using RIGHT() or LEN() on table fields because the data gets returned padded with spaces. I don't see how that would cause the exact bug you're seeing but you could try this maybe:</p>
<pre><code>SELECT RIGHT(ALLTRIM(LINK),LEN(ALLTRIM(LINK))-8) ,LEN(ALLTRIM(LINK))-8,RIGHT(ALLTRIM(LINK),77),ALLTRIM(LINK)
FROM LINKSTORE 
WHERE DOCLBL = &quot;V46145002A&quot;
</code></pre>
<p>edit: OK I got a better idea - are there other rows in your result set?</p>
<p>According to this: <a href="https://www.tek-tips.com/viewthread.cfm?qid=1706948" rel="nofollow noreferrer">https://www.tek-tips.com/viewthread.cfm?qid=1706948</a> ... when you do SELECT (expr) in FoxPro whatever the length of the expr in the first row becomes that max length for that 'field' and so all subsequent rows get truncated to that length. Makes sense in a crazy 1970s sort of way.</p>
<p>So perhaps you have a row of data above the one we are talking about which comes out at 68 chars long and so every subsequent value gets truncated to that length.</p>
<p>The way around it is to pad your expression results with CAST or PADR:</p>
<pre><code>SELECT PADR(RIGHT(ALLTRIM(LINK),LEN(ALLTRIM(LINK))-8),100),LEN(ALLTRIM(LINK))-8,PADR(RIGHT(ALLTRIM(LINK),77),100),LINK
 FROM LINKSTORE 
 WHERE DOCLBL = &quot;V46145002A&quot;
</code></pre>
<p>Or same without the ALLTRIM()</p>
<pre><code>SELECT PADR(RIGHT(LINK,LEN(LINK)-8),100),LEN(LINK)-8,PADR(RIGHT(LINK,77),100),LINK
 FROM LINKSTORE 
 WHERE DOCLBL = &quot;V46145002A&quot;
</code></pre>
</summary> </entry> <entry> <id>https://stackoverflow.com/questions/77898346/talend-open-studio-tos-qlik-removed-the-talend-community-any-backup-availabl/77911483?cid=138028947#77911483</id> <title type="text">Comment by codeulike on Talend Open Studio (TOS): Qlik removed the Talend Community. Any backup available?</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/77898346/talend-open-studio-tos-qlik-removed-the-talend-community-any-backup-availabl/77911483#77911483" /> <published>2024-04-08T15:35:19Z</published> <updated>2024-04-08T15:35:19Z</updated> <summary type="html">thanks for the info. Never heard of Qlik till now but they have annoyed me no end by making googling Talend problem so much more difficult</summary> </entry> <entry> <id>https://stackoverflow.com/questions/78090908/conditionally-update-a-column?cid=137670396</id> <title type="text">Comment by codeulike on Conditionally update a column</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/78090908/conditionally-update-a-column" /> <published>2024-03-01T23:37:20Z</published> <updated>2024-03-01T23:37:20Z</updated> <summary type="html"><i>The only way I can think of doing that is to have a separate parameter like @noExpiration and if that is supplied, then set EXPIRATION_DATE = NULL ... Is there a more elegant/common way of handling this?</i> No, thats probably the best way.</summary> </entry> <entry> <id>https://stackoverflow.com/questions/78062577/sql-query-optimization-for-join-containing-the-datetime?cid=137618705</id> <title type="text">Comment by codeulike on SQL Query optimization for Join containing the DateTime</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/78062577/sql-query-optimization-for-join-containing-the-datetime" /> <published>2024-02-26T17:02:15Z</published> <updated>2024-02-26T17:02:15Z</updated> <summary type="html">Can I buy shares in this company that has 1,00,00,000 Employees?</summary> </entry> <entry> <id>https://stackoverflow.com/questions/78050579/wildcards-in-if-statement?cid=137598313</id> <title type="text">Comment by codeulike on Wildcards in "IF" Statement</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/78050579/wildcards-in-if-statement" /> <published>2024-02-23T23:05:41Z</published> <updated>2024-02-23T23:05:41Z</updated> <summary type="html">Wildcards dont work like that in C# string comparisons. you can do <code>!ltr.Contains(&quot;LT&quot;)</code> though</summary> </entry> <entry> <id>https://stackoverflow.com/questions/78041059/how-to-properly-calculate-the-total-sum-of-each-die-face?cid=137587482</id> <title type="text">Comment by codeulike on How to properly calculate the total sum of each die face</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/78041059/how-to-properly-calculate-the-total-sum-of-each-die-face" /> <published>2024-02-22T22:44:34Z</published> <updated>2024-02-22T22:44:34Z</updated> <summary type="html">@Oueza oh yeah I see it now. My best guess then, is that your DisplayCurrentDiceValue object is losing its state somehow and so it can&#39;t add the dice up properly. When does the DisplayCurrentDiceValue object get created and how long does it last for?</summary> </entry> <entry> <id>https://stackoverflow.com/questions/78041059/how-to-properly-calculate-the-total-sum-of-each-die-face?cid=137582132</id> <title type="text">Comment by codeulike on How to properly calculate the total sum of each die face</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/78041059/how-to-properly-calculate-the-total-sum-of-each-die-face" /> <published>2024-02-22T14:05:08Z</published> <updated>2024-02-22T14:05:08Z</updated> <summary type="html">@Oueza I don&#39;t see diceResults declared anywhere. What holds a reference to it?</summary> </entry> <entry> <id>https://stackoverflow.com/questions/78041059/how-to-properly-calculate-the-total-sum-of-each-die-face?cid=137581357</id> <title type="text">Comment by codeulike on How to properly calculate the total sum of each die face</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/78041059/how-to-properly-calculate-the-total-sum-of-each-die-face" /> <published>2024-02-22T13:00:59Z</published> <updated>2024-02-22T13:00:59Z</updated> <summary type="html">The class DisplayCurrentDiceValue is supposed to add up the dice, it uses a diceResults object and the int totalDiceValue to do that. I can&#39;t see where diceResults is defined or what its lifetime is - your problem might be that diceResults is losing its state somewhere. Where is the diceResults object defined and when does it get reset?</summary> </entry> <entry> <id>https://stackoverflow.com/questions/77788170/removing-1-and-2-from-a-string-with-out-removing-11-and-12/77788221?cid=137309225#77788221</id> <title type="text">Comment by codeulike on Removing "1, " and "2, " from a string with out removing "11, " and "12, "</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/77788170/removing-1-and-2-from-a-string-with-out-removing-11-and-12/77788221#77788221" /> <published>2024-01-26T13:16:51Z</published> <updated>2024-01-26T13:16:51Z</updated> <summary type="html">At first I was confused as to why the third row of results has a 1, but then I realised the query has <code>Id &lt; 3</code> (someone keeps deleting this comment but I believe it is a useful comment)</summary> </entry> <entry> <id>https://stackoverflow.com/questions/77885306/set-based-approach-to-distributing-a-value-ssms-tsql?cid=137307437</id> <title type="text">Comment by codeulike on Set-based approach to distributing a value SSMS TSQL</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/77885306/set-based-approach-to-distributing-a-value-ssms-tsql" /> <published>2024-01-26T10:08:43Z</published> <updated>2024-01-26T10:08:43Z</updated> <summary type="html">I&#39;ve done SQL for 20+ years and with something like this (where you have to track a value that reduces row-by-row) I would definitely use a loop, unless the volumes were so large that that was not feasible. There probably is a way to do this with window functions but it will look completely incomprehensible to everyone whereas if you write a loop anyone can look at it, and see what it does. And thats important!</summary> </entry> <entry> <id>https://stackoverflow.com/questions/77788170/removing-1-and-2-from-a-string-with-out-removing-11-and-12?cid=137142053</id> <title type="text">Comment by codeulike on Removing "1, " and "2, " from a string with out removing "11, " and "12, "</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/77788170/removing-1-and-2-from-a-string-with-out-removing-11-and-12" /> <published>2024-01-10T11:39:02Z</published> <updated>2024-01-10T11:39:02Z</updated> <summary type="html">Its a good question though, things like this happen in the real world</summary> </entry> <entry> <id>https://stackoverflow.com/questions/273238/how-to-use-group-by-to-concatenate-strings-in-sql-server/43664415?cid=136673270#43664415</id> <title type="text">Comment by codeulike on How to use GROUP BY to concatenate strings in SQL Server?</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/273238/how-to-use-group-by-to-concatenate-strings-in-sql-server/43664415#43664415" /> <published>2023-11-21T19:22:58Z</published> <updated>2023-11-21T19:22:58Z</updated> <summary type="html">hot damn! and I have to add extra words to make the comment long enough but really the first two words were all I wanted to say here</summary> </entry> <entry> <id>https://stackoverflow.com/questions/76641445/how-to-query-the-salesforce-case-object-from-inside-adf?cid=135873756</id> <title type="text">Comment by codeulike on How to query the Salesforce Case object from inside ADF</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/76641445/how-to-query-the-salesforce-case-object-from-inside-adf" /> <published>2023-09-09T23:34:34Z</published> <updated>2023-09-09T23:34:34Z</updated> <summary type="html">You are querying sql server right? Not Salesforce? Because <code>select *</code> wont work in Salesforce. For SQL Server you could try adding the schema? e.g. <code>SELECT * FROM [dbo].[Case] ... </code></summary> </entry> <entry> <id>https://stackoverflow.com/questions/61808060/what-is-the-difference-between-adf-pipeline-and-adf-data-flow?cid=135873705</id> <title type="text">Comment by codeulike on What is the difference between ADF Pipeline and ADF Data flow?</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/61808060/what-is-the-difference-between-adf-pipeline-and-adf-data-flow" /> <published>2023-09-09T23:22:43Z</published> <updated>2023-09-09T23:22:43Z</updated> <summary type="html">Microsoft licensed DataBricks which runs on Apache Spark from DataBricks inc and package that up as the ADF Data Flow. Meanwhile you&#39;ve got the rest of ADF, the Copy Data activity and so on, thats all Microsoft-built. So its two different things welded together.</summary> </entry> <entry> <id>https://stackoverflow.com/questions/63727360/invoke-sqlcmd-and-export-csv-consume-huge-amounts-of-memory?cid=134944830</id> <title type="text">Comment by codeulike on Invoke-Sqlcmd and Export-Csv consume huge amounts of memory?</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/63727360/invoke-sqlcmd-and-export-csv-consume-huge-amounts-of-memory" /> <published>2023-06-22T20:37:23Z</published> <updated>2023-06-22T20:37:23Z</updated> <summary type="html">@Sachiko did you get anywhere with DataReader? I&#39;&#39;ve got the same problem</summary> </entry> <entry> <id>https://stackoverflow.com/questions/53218416/powershell-parsing-pipeline-csv-data-with-newlines-using-convertfrom-csv/53218417?cid=134249322#53218417</id> <title type="text">Comment by codeulike on Powershell Parsing Pipeline CSV data with newlines using ConvertFrom-Csv</title> <author> <name>codeulike</name> <uri>https://stackoverflow.com/users/22194</uri> </author> <link rel="alternate" href="https://stackoverflow.com/questions/53218416/powershell-parsing-pipeline-csv-data-with-newlines-using-convertfrom-csv/53218417#53218417" /> <published>2023-04-27T19:25:10Z</published> <updated>2023-04-27T19:25:10Z</updated> <summary type="html">That Out-String technique just saved my bacon, thanks</summary> </entry> </feed>If you would like to create a banner that links to this page (i.e. this validation result), do the following:
Download the "valid Atom 1.0" banner.
Upload the image to your own server. (This step is important. Please do not link directly to the image on this server.)
Add this HTML to your page (change the image src attribute if necessary):
If you would like to create a text link instead, here is the URL you can use:
http://www.feedvalidator.org/check.cgi?url=http%3A//stackoverflow.com/feeds/user/22194
