Forum Replies Created
Viewing 15 posts - 2,446 through 2,460 (of 13,877 total)
-
Reply To: Parse Semi colon data in seperate columns
pietlinden wrote:This worked:
SELECT t.*
, ca.value
FROM #tblTest t
CROSS APPLY STRING_SPLIT(t.FileData, ';') ca
WHERE LEN(TRIM(ca.Value))>0;Really?
-
Reply To: Parse Semi colon data in seperate columns
Parsename() works only on strings which have . (full-stop) as their delimiter.
If there are only ever two columns, here is one way:
DROP TABLE IF EXISTS #Test;
CREATE TABLE... -
Reply To: how to pass datetime variable from Execute SQL task to the execute process task
Sergiy wrote:You need to declare those variables in sp_executesql as OUTPUT parameters
And map them to package variables, to use them in subsequent tasks.
-
Reply To: Sum of column from multiplied columns
wrote:Select Math from the Formula Type drop down list;
In the Choose a formula listbox, select SUMPRODUCT with criteria option;
No such option is available from within SSMS, as far as...
-
Reply To: Weird behaviour on Excel connection manager and files
Are you changing the file extension from .xls to .xlsx, by any chance?
-
Reply To: Embedded SQL script in deployed package
I suspect that there is some configuration on the server where the script is working which overrides the default (and invalid) path. It is unlikely that the SQL script is...
-
Reply To: Sum of column from multiplied columns
nbeason wrote:Yes! That will do nicely. Thank you very much for your time.
No problem, thanks for posting back.
-
Reply To: Sum of column from multiplied columns
PS, that's not a row, it's a column 🙂
-
Reply To: Sum of column from multiplied columns
Like this?
SELECT SUM(TxQty*AvgCostOld) AS TotalTransactionCost
FROM tblimInvTxHistory
WHERE TxDate > '2020-08-25'
AND TxCode = 'ADJ' -
Reply To: Sum of column from multiplied columns
If you are going to SUM over a collection of rows, you need to define the grouping to SUM over.
All rows? By item? By date?
-
Reply To: Exclude square bracket and text from start or end of string
Makes it easier. Try this.
SELECT CalcTextName = CASE
... -
Reply To: Exclude square bracket and text from start or end of string
OK, so the requirement now is "remove any square brackets and any text they may contain", is that correct?
-
Reply To: Exclude square bracket and text from start or end of string
None of your revised test data matches this requirement:
If the square bracket is found at the beginning of string and is followed by '-' then I want entire text after...
-
Reply To: Best place to find SQL Server Consultants
frederico_fonseca wrote:that really is normally task for 3 individuals - good luck finding someone that can fill all of them.
I'd throw my hat into the ring, if it weren't for...
Viewing 15 posts - 2,446 through 2,460 (of 13,877 total)